Hi,
I am currently experiencing a problem with windows scheduler, I have scheduled a DTS job that truncates data and then builds a cube off that data via a batch file within the DTS process in SQL server 2000.
The truncate part works fine, however the PowerPlay Transformer hangs. I have scheduled a batch file to build another Cube; works great. I ensured that no transformer sessions are open at time of build.
The current Extract from the log.
LogFileDirectory=\\xxxxxx\cognos\cubes\logs
ModelSaveDirectory=\\xxxxxx\cognos\cubes\models\
DataSourceDirectory=d:\xxxx\iqds\
CubeSaveDirectory=\\xxxxxx\cognos\cubes\building site\
DataWorkDirectory=\\xxxxxx\cognos\cubes\temporary files\data1\
ModelWorkDirectory=\\xxxxxx\cognos\cubes\temporary files\model\
MaxTransactionNum=25000000
ReadCacheSize=65536
WriteCacheSize=65536
Temporary UDA directory=D:\xxxx\Temporary Files\Impromptu Temp
I have run the content of the batch from the command prompt; runs fine.
I have launched the batch file manually; works fine.
I have ran the DTS job manually; works fine.
Just when I automate it on windows 2000.
I am stomped at this..any suggestions would be great.
Batch File content :
"C:\Program Files\Cognos\cer3\bin\trnsfrmr.exe" -n2 -s "\\xxxxx\cognos\Cubes\Models\Cube (xxxxxx).pyi"
I am sure its not a permissions issue as I can automate other cubes that are part of the same group. I have also checked the event log; no entries.
I am currently experiencing a problem with windows scheduler, I have scheduled a DTS job that truncates data and then builds a cube off that data via a batch file within the DTS process in SQL server 2000.
The truncate part works fine, however the PowerPlay Transformer hangs. I have scheduled a batch file to build another Cube; works great. I ensured that no transformer sessions are open at time of build.
The current Extract from the log.
LogFileDirectory=\\xxxxxx\cognos\cubes\logs
ModelSaveDirectory=\\xxxxxx\cognos\cubes\models\
DataSourceDirectory=d:\xxxx\iqds\
CubeSaveDirectory=\\xxxxxx\cognos\cubes\building site\
DataWorkDirectory=\\xxxxxx\cognos\cubes\temporary files\data1\
ModelWorkDirectory=\\xxxxxx\cognos\cubes\temporary files\model\
MaxTransactionNum=25000000
ReadCacheSize=65536
WriteCacheSize=65536
Temporary UDA directory=D:\xxxx\Temporary Files\Impromptu Temp
I have run the content of the batch from the command prompt; runs fine.
I have launched the batch file manually; works fine.
I have ran the DTS job manually; works fine.
Just when I automate it on windows 2000.
I am stomped at this..any suggestions would be great.
Batch File content :
"C:\Program Files\Cognos\cer3\bin\trnsfrmr.exe" -n2 -s "\\xxxxx\cognos\Cubes\Models\Cube (xxxxxx).pyi"
I am sure its not a permissions issue as I can automate other cubes that are part of the same group. I have also checked the event log; no entries.