COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: jeffgrace on 04 Sep 2014 09:27:27 AM

Title: Batch Cube build fails only when in task scheduler
Post by: jeffgrace on 04 Sep 2014 09:27:27 AM
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!
Title: Re: Batch Cube build fails only when in task scheduler
Post by: bdbits on 05 Sep 2014 02:49:36 PM
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.
Title: Re: Batch Cube build fails only when in task scheduler
Post by: cognostechie on 05 Sep 2014 03:08:19 PM
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.
Title: Re: Batch Cube build fails only when in task scheduler
Post by: jeffgrace on 08 Sep 2014 07:38:12 AM
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.