If you are unable to create a new account, please email support@bspsoftware.com

 

{sysdate}" ) cannot be used for local processing failing when scheduling

Started by krishdw85, 15 Apr 2025 06:27:14 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

krishdw85

15 Apr 2025 06:27:14 AM
We recently migrated cognos from 10.2 to 11.1.7, one of my schedule reports is failing however when i run it on-demand in background or manually it is running fine, but whenever i schedule to run it is failing with the below error. Please share me your thoughts.

RQP-DEF-0177 An error occurred while performing operation 'sql�Prepare�With�Options' status='-271'. UDA-SQL-0607 Native SQL expressions ( "{sysdate}" ) cannot be used for local processing.

Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite