Transformer On Linux Using SQL Server as a Data Source Command Line Execution

[fry]

Hello

I have a Transformer model (mdl) that runs successfully on my windows laptop, pointing to a Linux dispatcher using Report Studio reports sourcing SQL Server as a database (GOSALES).

Everything is good until I transfer the .mdl (model) to the linux server and try and run it ./cogtr -c -m /root/Transformer/Models/Orders_Cube.mdl.

The log says it is reading the first query (report studio) and fails. QE-DEF-0285 The logon failed. Unable to access the GOSALES database.

Keeping mind that all works well from transformer on my windows machine ?  :-[

Thanks
Frank

[Francis aka khayman]

when you are running from windows, are you using command line or through Transformer?

anyway from what i can gather, try to use a sign-on.

check this out:

http://cognosm.fm3online.com/tips-and-tricks/refresh-transformer-cube-from-windows-command-line/
http://cognosm.fm3online.com/tips-and-tricks/refresh-transformer-cube-from-unix/