Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: fry on 16 Jan 2016 11:14:08 AM

Title: Transformer On Linux Using SQL Server as a Data Source Command Line Execution
Post by: fry on 16 Jan 2016 11:14:08 AM
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
Title: Re: Transformer On Linux Using SQL Server as a Data Source Command Line Execution
Post by: Francis aka khayman on 22 Feb 2016 02:12:00 AM
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/
Text only | Text with Images