I have a unique problem with my cube refresh. I have Cognos 7.3 mr2 and I'm updating cubes every week using a batch file.
I scheduled it to run everyweek. The schedule runs only when I run the schedule with the logon ID that I used to install the cognos.If i use any other ID the schedule fails with this error."Fri 03 Apr 2009 11:53:08 AM 1 000622D3 (TR3110) An unknown error has occurred during the operation. Please contact Cognos Customer support. ->OK
PowerPlay Transformer Fri Apr 03 11:53:08 2009"
The same batch file will run and refresh the cubes sucessfully with any logon id if I start it manually.But fails if I schedule it to run with any Logon ID other than the one I used to install the cognos.(All the login ID has administrative privilages).
The command I'm using in the batch file is "D:\Program Files\cognos\cer4\bin\trnsfrmr.exe" -n1 -i -kSignon=userid/password -r4 -nologo "d:\cer4_pp_mdls\mycube.mdl"
If anyone has solution or input on this problem is very much appreciated.
Pinned topic Cube refresh using batch file and windows scheduler
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-08-24T12:24:27Z at 2009-08-24T12:24:27Z by SystemAdmin
SystemAdmin 110000D4XK280 Posts
Re: Cube refresh using batch file and windows scheduler2009-08-24T12:24:27ZThis is the accepted answer. This is the accepted answer.Hello Moin,
LOGIN ID should be have Cognos admin access and also access on windows scheduler
then only you can schedule the job.