Hello Everyone,
I scheduled a report at 8 am in the morning. After some time the scheduling gets failed and shows up the below errror message.
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SOR-0001 Unable to allocate memory. UDA-EE-0023 An external routine has failed. UDA-SQL-0460 A general exception has occurred during local processing. UDA-EE-0023 An external routine has failed. UDA-SQL-0460 A general exception has occurred during local processing. UDA-EE-0023 An external routine has failed. UDA-SQL-0460 A general exception has occurred during local processing.
Can any one help me with the solution for the above issue.
Appreciate all your help !
Thanks.
Does this error only occur when you schedule it? What happens if you open the report in report studio and validate it? Are you able to run the report on demand and just not to a schedule?
Thanks for the reply.
I dont have issue running the report interactively or in the background, but when i schedules the report some times this issue is happening and some times schedule works with no issue.
Can you please address the issue and suggest any changes needed or these kind of issues happens intermittently.
Quote from: srinu51 on 05 Sep 2014 04:30:38 PM
Can you please address the issue and suggest any changes needed...
Hi,
bi4u2 was trying to help you here. Asking him to "please address the issue" seems like a very rude and pushy response to someone giving up their time for free to try to assist you. Please behave in a polite and acceptable manner on Cognoise.
MF.
I apologize if my post looks rude.
Srini51 - no offense taken, I know that there are lots of non-native English speakers on the forum. If the report validates and it runs on demand - does the log file contain any clues? Can you check for the timestamp of when the schedule was supposed to run?
I actually dont know how to check the log files :(. The schedule was supposed to run every day 8:00 am and the schedule was failing and running good some times.
The log file is called cogserver.log, it should be located in the following directory: ibm/cognos/c10_64/logs
Just curious, are there any other activity scheduled at that same time, maybe taking up resources or causing some kind of locks?
Quote from: srinu51 on 05 Sep 2014 01:58:41 PM
Hello Everyone,
I scheduled a report at 8 am in the morning. After some time the scheduling gets failed and shows up the below errror message.
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SOR-0001 Unable to allocate memory. UDA-EE-0023 An external routine has failed. UDA-SQL-0460 A general exception has occurred during local processing. UDA-EE-0023 An external routine has failed. UDA-SQL-0460 A general exception has occurred during local processing. UDA-EE-0023 An external routine has failed. UDA-SQL-0460 A general exception has occurred during local processing.
Can any one help me with the solution for the above issue.
Appreciate all your help !
Thanks.
Hi ,
In which format is your report delivered ? Excel ?
are you able to run the report and then export it to excel ?
Regards