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