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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Scheduling Failed

Started by srinu51, 05 Sep 2014 01:58:41 PM

Previous topic - Next topic

srinu51

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.

bi4u2

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?

srinu51

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.


MFGF

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.
Meep!

Good Friend

I apologize if my post looks rude.

bi4u2

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?

srinu51

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. 

bi4u2

The log file is called cogserver.log, it should be located in the following directory: ibm/cognos/c10_64/logs

kchiang

Just curious, are there any other activity scheduled at that same time, maybe taking up resources or causing some kind of locks?

Raghuvir

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