Client Automation Standard Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

reporting error

Frequent Advisor

reporting error

Hi All,
IN CCM 2.1 I am facing following reporting error
Error - /reportingserver//results.tcl
42S02 208 {[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.RRS_SESSION'.}
while executing
"$dbHandle "$query""
(object "::sql0" method "::rrs::sql::query" body line 11)
invoked from within
"query "DELETE FROM [set sessionTable] WHERE SESSIONID = '[set sessionId]'""
(object "::sql0" method "::rrs::sql::cleanDeviceTable" body line 16)
invoked from within
"cleanDeviceTable"
(object "::sql0" method "::rrs::sql::doMount" body line 12)
invoked from within
"doMount"
(object "::sql0" method "::rrs::sql::query" body line 3)
invoked from within
"$::rrs::sqlDb($sqlDsn) query $sqlStatement"
(procedure "sql" line 7)
invoked from within
"sql execute RIM "select count(device_id) from [config RIMPREFIX]deviceconfig""
invoked from within
"subst $cattrtmp(html)"
(procedure "RRSDefaultHome" line 46)
invoked from within
"$attrtmp(proc) $viewparams($object) $windowparams($object) $object"
(procedure "resultStub" line 77)
invoked from within
"resultStub"
invoked from within
"catch $cmd"


My rpm.cfg file settings are

## Patch Manager Reporting Server Configuration File

::rrs::mount RPM ODBC {
-ENABLE 0
-CACHEENABLE 0
-CACHELIFE 1200
-DEVICETABLE dbo.RRS_DEVICETABLE
-DATABASE sql
-PREFIX dbo.
-DSN {CCMDB}
-DSN_USER {sa}
-DSN_PASSWD {{DES}BDPOWFtTwnQ=:2}
-NOLOCK 0
-NORMALIZECASE 0
Thanks for the replier.
Darshana
10 REPLIES
Honored Contributor

Re: reporting error

Error message is about RIM configuration and not about the RPM one (therefore the rim.cfg is the relevant one).

Does RRS_SESSION tableexist in RIM?
If not, did you run prereq script (under rrs\prereq)?
If yes, does table owner match user defined in cfg file?

Frequent Advisor

Re: reporting error

thanks
how can i check rrs session in rim?
my rim.cfg file config. are

## RIM Reporting Server Configuration File

::rrs::mount RIM ODBC {
-ENABLE 1
-CACHEENABLE 0
-CACHELIFE 1200
-DEVICETABLE dbo.RRS_DEVICETABLE
-DATABASE sql
-PREFIX dbo.
-DSN {CCMDB}
-DSN_USER {sa}
-DSN_PASSWD {{DES}BDPOWFtTwnQ=:2}
-NORMALIZECASE 0
}
regards
darshana
Frequent Advisor

Re: reporting error

yes, rrs table exists in rim.
should i run the rim or rpm or rum prereq creation script now?
regards
darshana
Honored Contributor

Re: reporting error

Well, if it there you should check who is the owner of that table. Looks like this is not user sa.
Frequent Advisor

Re: reporting error

i checked table owner is sa. but proble at it is.

thanks for the replier
darshana
Honored Contributor

Re: reporting error

Is it solved?
Otherwise you may have some issue with your ODBC configuration.
Did you check that one? On what kind of system is it running?
Frequent Advisor

Re: reporting error

Problem is stile pending..
Honored Contributor

Re: reporting error

Though that does not fully anwser above questions ...
1/ Are you running on a 32 or 64 bit system?
2/ Do other CA components successfuly communicate with DB?
Frequent Advisor

Re: reporting error

My OS is windows 2003 standard sedition (32bit)
I donâ t have CA components.

Thanks for the replier.
Darshana
Trusted Contributor

Re: reporting error

Please let me know if this isn't solved. This should have been automatically created, however you ran run a script to create it. The script is located under reportingserver/prereq/SQL/rim/

Run that in SQL Query Analyzer and try again.
//Add this to "OnDomLoad" event