Hi all!
Here’s the short version: I’ve created a scheduled task on a Windows 2000 Server to run Cognos Powerplay Transformer which should create some cubes, which it doesn’t.
And with some more details: the task is essentially a batch file which runs the program and specifies a path to the cubes which are located on another server on the same domain. If I run the batch file when I log in to the server via Remote Desktop it works fine. But when I try to set it up as an automated task, it just won’t happen. Here are the error messages from the Transformer log files:
– DMS-E-DBACCESS, It was not possible to access the ‘Enterprise’ database.
– Specified driver could not be loaded due to system error 126 (Progress OpenEdge 10.1A driver).
– (TR0118) Transformer can’t read the database [Enterprise] defined in \\Tammet_server\tammet\tammisaari\Hallinto\Cognos\Tietolahteet\Asiakasryhmat.iqd. [->OK]
I’ve tried running the task as the server’s local admin and as a domain admin without result. A search on the error message 126 suggests that it’s a missing file or something similar, but if that’s the case it shouldn’t work when started manually.
I’ve also tried a couple of other cron tools like Z-cron and nnCron with similar results.
What am I missing? Nothing should be impossible, right? I would be really, truly grateful for any helpful answers.
