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

Batch Cube build fails only when in task scheduler

Started by jeffgrace, 04 Sep 2014 09:27:27 AM

Previous topic - Next topic

jeffgrace

Guys,

In Transformer 10.1 and Windows Server Standard Service Pack 2...

I have a batch file that processes, and creates my cube/updates data source etc. 
It works great when I double click the file, but if I run it through task scheduler, I get
Thu 04 Sep 2014 9:51:48 AM   4   00027D31   Start cube update.
Thu 04 Sep 2014 9:51:48 AM   4   00027D31   Initializing categories.
Thu 04 Sep 2014 9:51:48 AM   4   00027D31   Timing, INITIALIZING CATEGORIES,00:00:00
Thu 04 Sep 2014 9:51:49 AM   4   00027D31   Start processing data source 'TransformerTest~1'.
Thu 04 Sep 2014 9:51:49 AM   4   00027D31   Reading source data.
Thu 04 Sep 2014 9:51:51 AM   2   00027D31   QE-DEF-0368 Unable to decrypt user name and password credentials from the content store. Review and save the Cognos Configuration settings to configure your reporting environment.
Thu 04 Sep 2014 9:51:51 AM   4   00027D31   End processing 0 records from data source 'TransformerTest~1'.
Thu 04 Sep 2014 9:51:51 AM   4   00027D31   Timing, READ DATA SOURCE,00:00:02
Thu 04 Sep 2014 9:51:51 AM   4   00027D31   End cube update.
Thu 04 Sep 2014 9:51:51 AM   4   00027D31   Timing, TOTAL TIME (CREATE CUBE),00:00:03


The batch file is

"c:\Program Files (x86)\IBM\Cognos\C10\bin\cogtr.exe" -n1 -l"Auto" -g -fE:\CognosData\Publish.xml -m"E:\CognosData\FM_Models\Transformer Upgrade\usprodcube.mdl"


Where Auto is a signon in transformer set to automatically sign on, with valid credentials.

Any ideas would be greatly appreciated!

bdbits

Are you using your credentials in the scheduled task? If not, whatever logon is being used for the task will need access to the model file. If possible, an easy way to test alternative credentials is to log on as that user and try to run the same command line as set in the scheduled task.

cognostechie

I always insert the credentials in the sign-on window in Transformer. Then you don't have to pass the credentials thru the batch file.

jeffgrace

In the scheduler security I have it set to sign on as a vailid user, in this case AMERICAS\svcWHQCognos  which is the domain/user that works straight from the batch.  I have tried it with both "Run whether user is logged on or not" and "Run only when user is logged on"   Nothing seems to do the trick.