We have upgraded from 11.1.1 to 11.2.2 over the top installation. In cognos configuration i can test every connection and it is OK. I can login on cognos analytics with sso, but when we run a report the we get: RSV-VAL-0010 Failed to load the report specification. XQE-JDB-0010 Connection to database with Single Sign On failed. I have tried every solution on the IBM page, still same issue.
This what i see in the Cognosserver log:
2022-05-24T16:37:42.835+0200 ERROR com.ibm.bi.platform.commons.web.BIResponseWrapper [Default Executor-thread-1699] jChsC94wwlwqld4MdvqG9v94G9hGqhwd2jhv9vdC jChsC94wwlwqld4MdvqG9v94G9hGqhwd2jhv9vdC NA 172.24.56.44 51956 LoginUser493899377 AggAAADfG5ZiAAAAAAoAAADsWc4ZiuHxZ1pfFAAAAEXs0UwZOeHHY/AXpidpFIQkv4waBwAAAFNIQS0yNTYgAAAAPvDRmGNQqzcjWWxYTmjA4ljIKqaWt56iaNaw+AhfExs= /v1/reports report-service 38460 HttpServletResponseCode for /p2pd/servlet/dispatch is in error: 500
2022-05-24T16:37:44.835+0200 INFO startup.Audit.RTUsage.RSVP [Thread-64] h82hwjvM2vll88jC9w8jhjC9G8GwdhvG298MMd92 h82hwjvM2vll88jC9w8jhjC9G8GwdhvG298MMd92 NA 172.24.56.44 9300 A267F8C36EA0A75A451A2E1048EE6150925869A5DFC84F91209A10DFDBC7A7C8 h82hwjvM2vll88jC9w8jhjC9G8GwdhvG298MMd92_h82hwjvM2vll88jC9w8jhjC9G8GwdhvG298MMd92_ RSVP 12736 Response Failure Report ReportService XQE-JDB-0010 Verbinding met de database via eenmalige aanmelding is mislukt.
2022-05-24T16:37:44.835+0200 INFO startup.Audit.dispatcher.caf [Thread-61] NA 172.24.56.44 9300 __ caf 38460 Request SecureErrorId: 2022-05-24-16:37:42.835-#76 Original Error: XQE-JDB-0010 Verbinding met de database via eenmalige aanmelding is mislukt. RSV-SRV-0042 Vorige bijhouden: RSReportService.cpp(786): XQEException: CCL_CAUGHT: RSReportService::processImpl() RSReportServiceMethod.cpp(260): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_Request RSASyncExecutionThread.cpp(902): XQEException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(368): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_Request RSASyncExecutionThread.cpp(947): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_Request Execution/RSRenderExecution.cpp(589): XQEException: CCL_RETHROW: RSRenderExecution::execute Assembly/RSDocAssemblyDispatch.cpp(341): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW: RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(450): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(183): XQEException: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(386): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp(314): XQEException: CCL_RETHROW: RSPageAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(386): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(386): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(151): XQEException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(450): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSDocAssemblyDispatch.cpp(386): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSAssembly.cpp(699): XQEException: CCL_RETHROW: RSAssembly::createListIterator Assembly/RSAssembly.cpp(767): XQEException: CCL_RETHROW: RSAssembly::createListIterator RSQueryMgr.cpp(853): XQEException: CCL_RETHROW: RSQueryMgr::getListIterator RSQueryMgr.cpp(925): XQEException: CCL_RETHROW: RSQueryMgr::getResultSetIterator RSQueryMgr.cpp(1048): XQEException: CCL_RETHROW: RSQueryMgr::createIterator RSQueryMgrBasic.cpp(298): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommand RSQueryMgrExecutionHandlerImpl.cpp(169): XQEException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() QFSSession.cpp(1190): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(1188): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(1145): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(888): XQEException: CCL_RETHROW: QFSConnection::Execute QFSQuery.cpp(311): XQEException: CCL_RETHROW: QFSQuery::Execute v2 XQEConnector.cpp(300): XQEException: CCL_THROW: XQEConnector::send Failure
#CognosAnalytics#CognosAnalyticswithWatson#Support#SupportMigration