Client Automation Standard Practitioners Forum
cancel

reporting error

Highlighted
Murli A Rao
Regular Collector

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
Alexander Willn
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?

Murli A Rao
Regular Collector

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
Murli A Rao
Regular Collector

Re: reporting error

yes, rrs table exists in rim.
should i run the rim or rpm or rum prereq creation script now?
regards
darshana
Alexander Willn
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.
Murli A Rao
Regular Collector

Re: reporting error

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

thanks for the replier
darshana
Alexander Willn
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?
Murli A Rao
Regular Collector

Re: reporting error

Problem is stile pending..
Alexander Willn
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?
Murli A Rao
Regular Collector

Re: reporting error

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

Thanks for the replier.
Darshana
Steve Berube
Frequent Visitor

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