It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×7,386

question asked: Aug 11 '11, 6:00 a.m.
question was seen: 10,662 times
last updated: Jun 21 '12, 5:30 a.m.

Related questions

FAQ - How this Forum works

CLM/RRDI - 'sqlPrepareWithOptions' status='-201'.

0
Keng Lim (6●1●4●3) | asked Aug 11 '11, 6:00 a.m.
Installed & configured CLM 3.0.1 and RRDI 1.0.2 using ORACLE 11g r2 on win server 2008 r2 x64.

I have got to the stage where I can run the RQM live reports successfully but when I try to run a datawarehouse report I get the error below ...

RQP-DEF-0177

An error occurred while performing operation
'sqlPrepareWithOptions' status='-201'.

UDA-SQL-0107 A general exception has occurred during the operation
"columns".ORA-00942: table or view does not exist UDA-SQL-0196 The table or
view "VW_PROJECT_RESOURCE_LOOKUP" was not found in the
dictionary.RSV-SRV-0042 Trace back:RSReportService.cpp(779): QFException:
CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265):
QFException: CCL_RETHROW: RSReportServiceMethod::process():
asynchRun_RequestRSASyncExecutionThread.cpp(788): QFException:
RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224):
QFException: CCL_CAUGHT: RSASyncExecutionThread::run():
asynchRun_RequestRSASyncExecutionThread.cpp(838): QFException: CCL_RETHROW:
RSASyncExecutionThread::processCommand():
asynchRun_RequestExecution/RSRenderExecution.cpp(606): QFException:
CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp
(277): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77):
QFException: CCL_RETHROW:
RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSPageAssembly.cpp
(300): QFException: CCL_RETHROW:
RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp
(173): QFException: CCL_RETHROW:
RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp
(135): QFException: CCL_RETHROW:
RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardRSQueryMgr.cpp(1003):
QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1076):
QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp
(1241): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp
(1555): QFException: CCL_RETHROW:
RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1542): QFException:
CCL_RETHROW:
RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(187):
QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute
()RSQueryMgrExecutionHandlerImpl.cpp(167): QFException: CCL_RETHROW:
RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(305): QFException:
CCL_RETHROW: RSQFSession::DoRequestQFSSession.cpp(716): QFException:
CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(714):
QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(659):
QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp
(634): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest
()QFSConnection.cpp(751): QFException: CCL_RETHROW:
QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW:
QFSQuery::Execute v2CoordinationQFSQuery.cpp(4297): QFException: CCL_THROW:
CoordinationPlanner

7 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Peter Haumer (2.2k●1●20●19) | answered Aug 11 '11, 10:02 a.m.
JAZZ DEVELOPER
Hello.
The error says that it cannot see a database view called
VW_PROJECT_RESOURCE_LOOKUP that is used for the report (this particular
view is used for every report actually, as it is used for guarding
access rights to every other view in the warehouse's operational data
store).

In Cognos Administration, does your RIDW connection point to the correct
database? Do you see this RIDW.VW_PROJECT_RESOURCE_LOOKUP view in your
database? Does the db user that you specified for the sign-on for this
connection have the permission to select from this view?

Best regards,
Peter.


On 8/11/2011 5:08 AM, limkeng wrote:
Installed& configured CLM 3.0.1 and RRDI 1.0.2 using ORACLE 11g
r2 on win server 2008 r2 x64.

I have got to the stage where I can run the RQM live reports
successfully but when I try to run a datawarehouse report I get the
error below ...

RQP-DEF-0177

An error occurred while performing operation
'sqlPrepareWithOptions' status='-201'.

UDA-SQL-0107 A general exception has occurred during the operation
"columns".ORA-00942: table or view does not exist
UDA-SQL-0196 The table or
view "VW_PROJECT_RESOURCE_LOOKUP" was not found in the
dictionary.RSV-SRV-0042 Trace back:RSReportService.cpp(779):
QFException:
CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265):
QFException: CCL_RETHROW: RSReportServiceMethod::process():
asynchRun_RequestRSASyncExecutionThread.cpp(788): QFException:
RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224):
QFException: CCL_CAUGHT: RSASyncExecutionThread::run():
asynchRun_RequestRSASyncExecutionThread.cpp(838): QFException:
CCL_RETHROW:
RSASyncExecutionThread::processCommand():
asynchRun_RequestExecution/RSRenderExecution.cpp(606): QFException:
CCL_RETHROW:
RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp
(277): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77):
QFException: CCL_RETHROW:
RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSPageAssembly.cpp
(300): QFException: CCL_RETHROW:
RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp
(173): QFException: CCL_RETHROW:
RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp
(135): QFException: CCL_RETHROW:
RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardRSQueryMgr.cpp(1003):
QFException: CCL_RETHROW:
RSQueryMgr::getListIteratorRSQueryMgr.cpp(1076):
QFException: CCL_RETHROW:
RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp
(1241): QFException: CCL_RETHROW:
RSQueryMgr::createIteratorRSQueryMgr.cpp
(1555): QFException: CCL_RETHROW:
RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1542): QFException:
CCL_RETHROW:
RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(187):
QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute
()RSQueryMgrExecutionHandlerImpl.cpp(167): QFException: CCL_RETHROW:
RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(305):
QFException:
CCL_RETHROW: RSQFSession::DoRequestQFSSession.cpp(716): QFException:
CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(714):
QFException: CCL_CAUGHT:
QFSSession::ProcessDoRequest()QFSSession.cpp(659):
QFException: CCL_RETHROW:
QFSSession::ProcessDoRequest()QFSSession.cpp
(634): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest
()QFSConnection.cpp(751): QFException: CCL_RETHROW:
QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW:
QFSQuery::Execute v2CoordinationQFSQuery.cpp(4297): QFException:
CCL_THROW:
CoordinationPlanner
0
permanent link
Saurabh Malhotra (152●3●16●17) | answered Sep 14 '11, 10:05 a.m.
Hi All,

I am getting the same error as this one and I don't see RIDW.VW_PROJECT_RESOURCE_LOOKUP view. What is the cause for this? Also any troubleshooting / fix options would be greatly appreciated.

Thanks.
Saurabh
0
permanent link
Peter Haumer (2.2k●1●20●19) | answered Sep 15 '11, 9:37 p.m.
JAZZ DEVELOPER
Are there any tables in the DB? Is there a PROJECT or RESOURCE table? It
might be best to work with tech support to trace back the set-up steps
that you performed.

Peter.

On 9/14/2011 7:08 AM, saurabhm wrote:
Hi All,

I am getting the same error as this one and I don't see
RIDW.VW_PROJECT_RESOURCE_LOOKUP view. What is the cause for this?
Also any troubleshooting / fix options would be greatly appreciated.

Thanks.
Saurabh
0
permanent link
Leon Van Zyl (21●4●4) | answered Dec 12 '11, 1:21 a.m.
Installed & configured CLM 3.0.1 and RRDI 1.0.2 using ORACLE 11g r2 on win server 2008 r2 x64.

I have got to the stage where I can run the RQM live reports successfully but when I try to run a datawarehouse report I get the error below ...

RQP-DEF-0177

An error occurred while performing operation
'sqlPrepareWithOptions' status='-201'.

UDA-SQL-0107 A general exception has occurred during the operation
"columns".ORA-00942: table or view does not exist UDA-SQL-0196 The table or
view "VW_PROJECT_RESOURCE_LOOKUP" was not found in the
dictionary.RSV-SRV-0042 Trace back:RSReportService.cpp(779): QFException:
CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265):
QFException: CCL_RETHROW: RSReportServiceMethod::process():
asynchRun_RequestRSASyncExecutionThread.cpp(788): QFException:
RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224):
QFException: CCL_CAUGHT: RSASyncExecutionThread::run():
asynchRun_RequestRSASyncExecutionThread.cpp(838): QFException: CCL_RETHROW:
RSASyncExecutionThread::processCommand():
asynchRun_RequestExecution/RSRenderExecution.cpp(606): QFException:
CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp
(277): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77):
QFException: CCL_RETHROW:
RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSPageAssembly.cpp
(300): QFException: CCL_RETHROW:
RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp
(173): QFException: CCL_RETHROW:
RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp
(135): QFException: CCL_RETHROW:
RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardRSQueryMgr.cpp(1003):
QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1076):
QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp
(1241): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp
(1555): QFException: CCL_RETHROW:
RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1542): QFException:
CCL_RETHROW:
RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(187):
QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute
()RSQueryMgrExecutionHandlerImpl.cpp(167): QFException: CCL_RETHROW:
RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(305): QFException:
CCL_RETHROW: RSQFSession::DoRequestQFSSession.cpp(716): QFException:
CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(714):
QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(659):
QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp
(634): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest
()QFSConnection.cpp(751): QFException: CCL_RETHROW:
QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW:
QFSQuery::Execute v2CoordinationQFSQuery.cpp(4297): QFException: CCL_THROW:
CoordinationPlanner





Hi,
Check that your RPTUSER has the correct permissions on the RIDW database
0
permanent link
Keith Chuang (11●1●1) | answered Jan 02 '12, 1:07 a.m.
Hi, I'm encountering this issue as well.
I installed RRDI with DB2 on Windows Server 2003 and set everything by default.

1. I was wondering if the RICM, the default name of DB2 instance during the RRDI installation, will matter something unexpected.
I changed it into "RIDW" as the guide requests! (See Figure_1)

2. I should not be able to configure other settings, like creating the VW related tables and views for db2 if I opted Automatic installation mode, right? (See Figure_1)

<Figure_1>
http://www.imgplace.com/img151/1338/78dbname.th.png

However, I've been getting the ERROR message while generating reports. (See Figure_2)

<Figure_2>
http://www.imgplace.com/img515/5493/13errormsg.th.png

P.S. I have set the highest privilege to RPTUSER and the connection test to RIDW is successful too!

Any solution to this is appreciated!

Regards,
Keith

Installed & configured CLM 3.0.1 and RRDI 1.0.2 using ORACLE 11g r2 on win server 2008 r2 x64.

I have got to the stage where I can run the RQM live reports successfully but when I try to run a datawarehouse report I get the error below ...

RQP-DEF-0177

An error occurred while performing operation
'sqlPrepareWithOptions' status='-201'.

UDA-SQL-0107 A general exception has occurred during the operation
"columns".ORA-00942: table or view does not exist UDA-SQL-0196 The table or
view "VW_PROJECT_RESOURCE_LOOKUP" was not found in the
dictionary.RSV-SRV-0042 Trace back:RSReportService.cpp(779): QFException:
CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265):
QFException: CCL_RETHROW: RSReportServiceMethod::process():
asynchRun_RequestRSASyncExecutionThread.cpp(788): QFException:
RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224):
QFException: CCL_CAUGHT: RSASyncExecutionThread::run():
asynchRun_RequestRSASyncExecutionThread.cpp(838): QFException: CCL_RETHROW:
RSASyncExecutionThread::processCommand():
asynchRun_RequestExecution/RSRenderExecution.cpp(606): QFException:
CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp
(277): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77):
QFException: CCL_RETHROW:
RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSPageAssembly.cpp
(300): QFException: CCL_RETHROW:
RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp
(173): QFException: CCL_RETHROW:
RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp
(135): QFException: CCL_RETHROW:
RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344):
QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp
(344): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardRSQueryMgr.cpp(1003):
QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1076):
QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp
(1241): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp
(1555): QFException: CCL_RETHROW:
RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1542): QFException:
CCL_RETHROW:
RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(187):
QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute
()RSQueryMgrExecutionHandlerImpl.cpp(167): QFException: CCL_RETHROW:
RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(305): QFException:
CCL_RETHROW: RSQFSession::DoRequestQFSSession.cpp(716): QFException:
CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(714):
QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(659):
QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp
(634): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest
()QFSConnection.cpp(751): QFException: CCL_RETHROW:
QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW:
QFSQuery::Execute v2CoordinationQFSQuery.cpp(4297): QFException: CCL_THROW:
CoordinationPlanner





Hi,
Check that your RPTUSER has the correct permissions on the RIDW database
0
permanent link
Peter Haumer (2.2k●1●20●19) | answered Jan 10 '12, 1:08 p.m.
JAZZ DEVELOPER
You need two databases RIDW (the warehouse) and RICM (the content store
in which Cognos stores the reporting models, reports etc.).

I recorded a video with all the installation steps. Perhaps that helps:
https://jazz.net/forums/viewtopic.php?t=18853

Peter Haumer.


On 1/1/2012 10:08 PM, kzokv wrote:
Hi, I'm encountering this issue as well.
I installed RRDI with DB2 on Windows Server 2003 and set everything by
default.

1. I was wondering if the RICM, the default name of DB2 instance
during the RRDI installation, will matter something unexpected.
I changed it into "RIDW" as the guide requests! (See
Figure_1)

2. I should not be able to configure other settings, like creating the
VW related tables and views for db2 if I opted Automatic installation
mode, right? (See Figure_1)

Figure_1
http://www.imgplace.com/img151/1338/78dbname.th.png

However, I've been getting the ERROR message while generating reports.
(See Figure_2)

Figure_2
http://www.imgplace.com/img515/5493/13errormsg.th.png

P.S. I have set the highest privilege to RPTUSER and the connection
test to RIDW is successful too!

Any solution to this is appreciated!

Regards,
Keith
0
permanent link
Nagesh Srinivas (108●3●8) | answered Jun 21 '12, 5:30 a.m.
Make sure the user account configured to generate reports has the rights on the tables/views/procedures on RIDW, RICM (in my cade its insight so.. its RIODS).

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.