Parsing Error Before Or Near Position 9 Of Distinct
Contents |
"contains" Technote (troubleshooting) Problem(Abstract) Using a custom function to access the qe-def-0459 cclexception qe-def-0260 DB2 for text search function "contains" fails during validation with the following error. Symptom QE-DEF-0260 Parsing error before or near position: 9 of: "contains" Details QE-DEF-0261
Qe-def-0459 Cclexception Cognos 10
QFWP - Parsing text: contains ('Golf',[Product])QE-DEF-0260 Parsing error before or near position: 9 of: "contains"QE-DEF-0261 QFWP - Parsing text: contains ('Golf',[Product])RSV-SRV-0042 Trace back:RSReportService.cpp(826): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(259): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(789): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(250): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(842): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(616): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(289): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(356): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(179): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(306): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(303): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(306): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(175): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(306): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(137): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(356): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSAsse
error before or near position: 38 of: "coun qe-def-0459 cclexception parsing error 3 replies Latest Post - 2012-03-26T07:25:20Z by SystemAdmin qe def 0260 parsing error cognos 8 Display:ConversationsBy Date 1-4 of 4 Previous Next ViralRaval 2700027STM 2 Posts Pinned
Qe-def-0459 Cclexception Cognos Report Studio
topic QE-DEF-0459 QE-DEF-0260 Parsing error before or near position: 38 of: "coun 2012-03-23T12:47:07Z | Tags: Answered question This question http://www-01.ibm.com/support/docview.wss?uid=swg21468714 has been answered. Unanswered question This question has not been answered yet. We have currently migrated to Cognos 10.1.1 from Cognos 8.4. We are facing an error message in certain reports where we have used "count( distinct( decode(" https://www.ibm.com/developerworks/forums/thread.jspa?messageID=14805045 kind of expression with aggregate property as "Calculated" and roll-up aggregate property as "Automatic". This expression is used in a graph as a measure. X-axis and Y-axis expressions are present in graph. These reports works fine in Cognos 8.4 environment but throws an error message in Cognos 10.1.1. Even result through "View Tabular Data" is correct in Cognos 10.1.1. Please do let me know is it a bug in Cognos 10.1.1? or I need to work around to be able to get this working in Cognos 10.1.1? Here is the expression: count(distinct decode( ?PRM_TYP_USER? ;'M'; decode(?PRM_INDIC?;4;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_ABO_RDP_QUO;5;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_IND_MED_ABO_RDP_QUO;2;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_ABO_RDP_HBD;3;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_IND_MED_ABO_RDP_HBD;0;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_ABO_FMC;1;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_IND_MED_ABO_FMC;6;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_ABO_UNI_INFO;7;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_IND_MED_ABO_UNI_INFO;8;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_ABO_MSD_INFO;9;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_IND_MED_ABO_MSD_INFO) ;'P'; decode(?PRM_INDIC?;4;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_ABO_RDP_QUO;5;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_IND_PHA_ABO_RDP_QUO;2;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_ABO_RDP_HBD;3;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_IND_PHA_ABO_RDP_HBD;0;Univadis Accounts.FCT_MED_UNIVADIS_CODEIND.CNT_USR_ABO_FMC;1;Univadis Acco
Technote http://www-01.ibm.com/support/docview.wss?uid=swg21388529 (troubleshooting) Problem(Abstract) Validating a report in Report Studio results in the following error messages. Symptom QE-DEF-0459 CCLException QE-DEF-0260 Parsing error before or near position: 10 of: "testValue" QE-DEF-0261 QFWP - Parsing text: testValue Cause The prompt macro has no default value. parsing error Diagnosing the problem The prompt macro has no default value. Resolving the problem The report includes one or several prompts like: #prompt('