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

Auto schedule of analyst macro fails and manual rerun succeeds

Started by kavitha.l, 03 Feb 2010 04:30:19 AM

Previous topic - Next topic

kavitha.l

Hi All,

I am facing an issue where the auto schedule of the batch file which runs an analyst macro and contributor macro fails and a manual rerun of the same succeeds. The batch file is scheduled by a 3rd party tool and it is used to run an analyst macro (used to update the D-list items) first and then followed by a contributor macro. This auto schedule frequently fails while executing the analyst macro at the same point and when the batch file is run manually it succeeds. Rarely the auto schedule is successful. While running manually, it is not asking for any prompt value and it is running successfully. Hope there is no prompt issue.

The batch file is scheduled by a 3rd party tool and it is not failing at the very beginning , it is failing after executing 41 steps. So we couldn't say it is a scheduler issue.  I can add more information about the problem like dlist update macro is updating the time scale dlist by using import link from a dcube. Can anyone kindly tell me what could be the possible reason for this failure of auto schedule? Has anyone faced similar issues? If so, kindly share your views.

PFB the log of the analyst macro execution and it fails at the same region during the auto schedule quite often:

2009-09-13 21:56:02 D-Cube Comet Common.RM:Weeks Attributes updated...
2009-09-13 21:56:02 0000 Error-free
2009-09-13 21:56:02 Executing macro step #42.
2009-09-13 21:56:02 Executing macro step #1.
2009-09-13 21:56:02 0000 Error-free
2009-09-13 21:56:02 Executing macro step #2.
2009-09-13 21:56:02 0000 Error-free
2009-09-13 21:56:02 Executing macro step #3.
2009-09-13 21:56:02 0000 Error-free
2009-09-13 21:56:02 Executing macro step #4.
2009-09-13 21:56:02 0000 Error-free
2009-09-13 21:56:02 Executing macro step #5.
2009-09-13 21:56:02 0000 Error-free
2009-09-13 21:56:02 Executing macro step #6.
2009-09-13 21:56:02 Reading file...
2009-09-13 21:56:02 Calculating totals...
2009-09-13 21:56:02   Calculate ...   
2009-09-13 21:56:03  Forward   
2009-09-13 21:56:03  Forward (100%)
2009-09-13 21:56:03   (¯100%)
2009-09-13 21:56:03  Forward  ...finished
2009-09-13 21:56:03 0000 Error-free
2009-09-13 21:56:03 Executing macro step #7.
2009-09-13 21:56:03 Reading file...
2009-09-13 21:56:03 Calculating totals...
2009-09-13 21:56:03   Calculate ...   
2009-09-13 21:56:03  Forward   
2009-09-13 21:56:03  Forward (100%)
2009-09-13 21:56:03   (¯100%)
2009-09-13 21:56:03  Forward  ...finished
2009-09-13 21:56:03 0000 Error-free
2009-09-13 21:56:03 Executing macro step #8.
2009-09-13 21:56:03 0000 Error-free
2009-09-13 21:56:03 Executing macro step #9.
2009-09-13 21:56:04 Reading file...
2009-09-13 21:56:04 Calculating totals...
2009-09-13 21:56:04   Calculate ...   
2009-09-13 21:56:04  Forward   
2009-09-13 21:56:04  Forward (100%)
2009-09-13 21:56:04   (¯100%)
2009-09-13 21:56:04  Forward  ...finished
2009-09-13 21:56:04 Expected prompt:
2009-09-13 21:56:04 Received prompt:  ERROR IN CALCULATION:   ERROR AT  , 
2009-09-13 21:56:04 Return code set to 9999 Response out of sequence


Thanks in advance.

vishalbhandari


I suspect that this could be a problem with the breakback, as the last line points to a error in Calculation.