I have a batch file with cogtr.exe -n command which is created to refresh cube as part of the daily batch queue.
When this batch file is executed manually, it refreshes cube successfully.
But, when the same batch file is triggered by the nightly batch queue, it doesn't refresh the cube. But the cube modified date changes, so I am sure that the cube is being contacted but somehow doesn't refreshes. The log file says 'beginning....' And gets stuck there.
Any ideas?
Transformer is 10.1 and cognos server is 10.2
Perhaps it is permissions related. Are the credentials for the nightly batch the same as when running manually?
Lynn - Yes, Its related to permissions. Its fixed now. Thanks!