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.