 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I have managed to get the cube to build and deploy from within Transformer.
What I have now done is copied the method from an existing SSIS package with the thought that if it works for something else it'll work for my process.
It doesn't...
I have attached the LOG files and as i read them it is failing because of a user credential. But I can't see where to put the correct credentials. I have set the SQL job to run from the system account, the same as the working packages, every item seems to be the same, bar the file name.
Within the SSIS execute process task, Executable is C:\Program Files (x86)\ibm\cognos\c10\bin\cogtr.exe and arguments is -n2 -s -g "f:\BI\Models\FootfallV3Cube.pyj"
Trying to use the above in cmd also produces a fail, with the same log entry.
Could someone point me in the right direction please.
LogFileDirectory=f:\bi\logs\
ModelSaveDirectory=f:\bi\models\
DataSourceDirectory=F:\Cognos\Data\
CubeSaveDirectory=e:\bi\cube build\
DataWorkDirectory=F:\Cognos\temp\
ModelWorkDirectory=F:\Cognos\temp\
MaxTransactionNum=500000
Product locale: English (en)
Run locale: English (United Kingdom) (en-gb)
Codepage: windows-1252
Transformer Wed Nov 18 02:01:24 2015
Transformer(XX.XX.XX.XX) Wed Nov 18 02:01:24 2015
LogFileDirectory=f:\bi\logs\
ModelSaveDirectory=f:\bi\models\
DataSourceDirectory=F:\Cognos\Data\
CubeSaveDirectory=e:\bi\cube build\
DataWorkDirectory=F:\Cognos\temp\
ModelWorkDirectory=F:\Cognos\temp\
MaxTransactionNum=500000
Product locale: English (en)
Run locale: English (United Kingdom) (en-gb)
Codepage: windows-1252
Wed 18 Nov 2015 02:01:25 0 00000000 (TR3703) The user ID or password is either missing or invalid. Please re-enter the credentials.
Wed 18 Nov 2015 02:01:25 2 00000000 (TR0116) Transformer can't open the file Footfallv3~1. [->OK]
Wed 18 Nov 2015 02:01:25 4 00000000 Creating directory 'f:\bi\cube_live\footfall\footfallv3cube_1'.
Wed 18 Nov 2015 02:01:25 4 00000000 Copying 'e:\bi\cube build\footfallv3cube_1.mdc' to 'f:\bi\cube_live\footfall\footfallv3cube_1\footfallv3cube_1.mdc'.
Wed 18 Nov 2015 02:01:25 4 00000000 Renaming 'f:\bi\cube_live\footfall\footfallv3cube_1' to 'f:\bi\cube_live\footfall\footfallv3cube_1__20151118020125'.
Wed 18 Nov 2015 02:01:25 4 00000000 Deleting 'f:\bi\cube_live\footfall\footfallv3cube_1__20151117162850.ver'.
Wed 18 Nov 2015 02:01:25 4 00000000 Creating version file 'f:\bi\cube_live\footfall\footfallv3cube_1__20151118020125.ver'.
Wed 18 Nov 2015 02:01:25 4 00000000 (TR3818) PowerCube 'Footfallv32' has been deployed to version 'footfallv3cube_1__20151118020125'.
Wed 18 Nov 2015 02:01:25 4 00000000
Transformer Wed Nov 18 02:01:25 2015
When you run it, its under your context and login access, when you've deployed it, its under the context of your Service account.
Perhaps (assuming you have access to..) log in as the service account and let it run to help debug..
i have tried three logins, of these none works, when i schedule it to run as part of a job, using the service account, it fails. and the above is the actual log when i tried to run as service. Of the three i think? one is the service account, if it isn't then i don't have a chance of accessing it.
I am sure i have missed something pretty basic, just can't see it!!!