COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: Dev1975 on 18 Jun 2014 04:52:07 AM

Title: TR3001 and TR0116 with batch cube builds
Post by: Dev1975 on 18 Jun 2014 04:52:07 AM
Hello everyone,

Have a question, hope someone here can point me in the right direction....

Customer has a number of cube builds running via batch scheduled tasks. Some of the builds have run, however a few have failed. The errors seen in those cases run as follows:

Wed 18 Jun 2014 10:17:00   0   00000000   (TR3001) The IBM Cognos gateway is unable to connect to the IBM Cognos BI server. The server may be unavailable or the gateway may not be correctly configured. Try again or contact your administrator.
Wed 18 Jun 2014 10:17:00   2   00000000   (TR0116) Transformer can't open the file "<<filename>>".   [->OK]

I've checked the signon information in the PYJ files and have noticed that the ones that work don't have the domain pre-fixed to the user account. The failing ones are fully qualified (domain\username) or do not have any signon associated to it. However, according to IBM Technote 1404931, one of the possible causes is NOT having the domain pre-fixed to the signon details.

I'm going to test by removing the domain pre-fix and re-scheduling the failing tasks, in the meantime has anyone come across this issue before and can provide some pointers?

Many thanks,
Dev
Title: Re: TR3001 and TR0116 with batch cube builds
Post by: Dev1975 on 18 Jun 2014 05:33:09 AM
Forgot to mention that the source files for these are Cognos reports.
Title: Re: TR3001 and TR0116 with batch cube builds
Post by: michal on 21 Jul 2014 02:16:46 PM
seen same behavior in a newly installed 10.2.1 fixpack 3? iirc

one thing i can suggest is ensuring you have exactly the same version of patches/fixpacks everywhere.
in my case, portal (which was in 64 bit / different folders) was slightly ahead of the 32 bit transformer install (which did not have fix pack installed)
Title: Re: TR3001 and TR0116 with batch cube builds
Post by: Dev1975 on 04 Aug 2014 03:21:53 AM
Thanks for the response. I amended the configuration so that the reference was to the user rather than domain/user. Saved and set the schedules and all is working fine now.

FYI, the environment was all patched to the same level across the board.