Client Automation Standard Practitioners Forum
cancel

problem with Reporting homepage (CCM )

Highlighted
Murli A Rao
Super Contributor.

problem with Reporting homepage (CCM )

Hi all, I have a problem with Reporting homepage of CCM. When I open my reporting server url this message appear:
42S02 208 {[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.nvd_destatus'.} while executing "$dbHandle "$query"" (object "::sql1" method "::rrs::sql::query" body line 11) invoked from within "$::rrs::sqlDb($sqlDsn) query $sqlStatement" (procedure "sql" line 7) invoked from within "sql execute RPM "SELECT COUNT(DISTINCT nvd_zobjdev) from [config RPMPREFIX]nvd_destatus"" 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" Please provide me a solution to solve this problem.
Thanks for the replier.
Darshana





3 REPLIES
Alexander Willn
Acclaimed Contributor.

Re: problem with Reporting homepage (CCM )

- table nvd_destatus, which belongs to patch
manager, seems to be missing OR
- you did not correctly configure PREFIX
setting in rpm.cfg (under
ReportingServer\etc) OR
- you don't make use of patch manager at all
and may set ENABLE in RPM.cfg to 0
Murli A Rao
Super Contributor.

Re: problem with Reporting homepage (CCM )

thanks 4 reply.
i am unable to start the following service.
HP OpenView CM Messaging Server
pls reply
darshana
Alexander Willn
Acclaimed Contributor.

Re: problem with Reporting homepage (CCM )

Some error message would be helpful either from log file or from system event log.