Transformer could not find data source when called from batch file

[qvixote]

Hello!

I have a cube that works builds perfectly when using the Transformer UI, but when try to create it from batch file, it fails. This is the log file it generates:

Transformer(10.2.1003.25)  Tue Jul 22 10:47:10 2014

LogFileDirectory=C:\Users\Administrador\Documents\Transformer\Logs\
ModelSaveDirectory=C:\Users\Administrador\Documents\Transformer\Models\
DataSourceDirectory=..\data\
CubeSaveDirectory=C:\Users\Administrador\Documents\Transformer\PowerCubes\
DataWorkDirectory=..\temp\
ModelWorkDirectory=..\temp\
MaxTransactionNum=500000
Product locale: English (en)
Run locale: Spanish (Chile) (es-cl)
Codepage: windows-1252

mar 22 jul 2014 10:47:11   4   00000000   Start cube update.
mar 22 jul 2014 10:47:11   4   00000000   Initializing categories.
mar 22 jul 2014 10:47:11   4   00000000   Timing, INITIALIZING CATEGORIES,00:00:00
mar 22 jul 2014 10:47:11   4   00000000   Start processing data source 'DM_CAUSA'.
mar 22 jul 2014 10:47:11   4   00000000   Reading source data.
mar 22 jul 2014 10:47:14   4   00000000   Timing, OPEN DATA SOURCE,00:00:03
mar 22 jul 2014 10:47:14   4   00000000   End processing 29 records from data source 'DM_CAUSA'.
mar 22 jul 2014 10:47:14   4   00000000   Timing, READ DATA SOURCE,00:00:03
mar 22 jul 2014 10:47:14   4   00000000   Marking categories used.
mar 22 jul 2014 10:47:14   4   00000000   Timing, MARKING CATEGORIES USED,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Initializing categories.
mar 22 jul 2014 10:47:14   4   00000000   Timing, INITIALIZING CATEGORIES,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Marking categories used.
mar 22 jul 2014 10:47:14   4   00000000   Timing, MARKING CATEGORIES USED,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Initializing categories.
mar 22 jul 2014 10:47:14   4   00000000   Timing, INITIALIZING CATEGORIES,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Marking categories used.
mar 22 jul 2014 10:47:14   4   00000000   Timing, MARKING CATEGORIES USED,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Initializing categories.
mar 22 jul 2014 10:47:14   4   00000000   Timing, INITIALIZING CATEGORIES,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Marking categories used.
mar 22 jul 2014 10:47:14   4   00000000   Timing, MARKING CATEGORIES USED,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Initializing categories.
mar 22 jul 2014 10:47:14   4   00000000   Timing, INITIALIZING CATEGORIES,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Marking categories used.
mar 22 jul 2014 10:47:14   4   00000000   Timing, MARKING CATEGORIES USED,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Initializing categories.
mar 22 jul 2014 10:47:14   4   00000000   Timing, INITIALIZING CATEGORIES,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Marking categories used.
mar 22 jul 2014 10:47:14   4   00000000   Timing, MARKING CATEGORIES USED,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Initializing categories.
mar 22 jul 2014 10:47:14   4   00000000   Timing, INITIALIZING CATEGORIES,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Marking categories used.
mar 22 jul 2014 10:47:14   4   00000000   Timing, MARKING CATEGORIES USED,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Initializing categories.
mar 22 jul 2014 10:47:14   4   00000000   Timing, INITIALIZING CATEGORIES,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Marking categories used.
mar 22 jul 2014 10:47:14   4   00000000   Timing, MARKING CATEGORIES USED,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Initializing categories.
mar 22 jul 2014 10:47:14   4   00000000   Timing, INITIALIZING CATEGORIES,00:00:00
mar 22 jul 2014 10:47:14   4   00000000   Start processing data source 'FT_ATENCION_URGENCIA'.
mar 22 jul 2014 10:47:14   4   00000000   Reading source data.
mar 22 jul 2014 10:47:14   2   00000000   QE-DEF-0030 Expression parsing error.
mar 22 jul 2014 10:47:14   2   00000000   QE-DEF-0359 The query contains a reference to at least one object '[PRESENTACION].[FT_ATENCION_URGENCIA].[SEMANA_ESTADISTICA_INT]' that does not exist.
mar 22 jul 2014 10:47:14   4   00000000   End processing 0 records from data source 'FT_ATENCION_URGENCIA'.
mar 22 jul 2014 10:47:14   4   00000000   Timing, READ DATA SOURCE,00:00:00
mar 22 jul 2014 10:47:15   4   00000000   End cube update.
mar 22 jul 2014 10:47:15   4   00000000   Timing, TOTAL TIME (CREATE CUBE),00:00:04
mar 22 jul 2014 10:47:15   2   00000000   (TR0168) Transformer could not open the data source [FT_ATENCION_URGENCIA].  [->OK]
Transformer  Tue Jul 22 10:47:15 2014

The element '[PRESENTACION].[FT_ATENCION_URGENCIA].[SEMANA_ESTADISTICA_INT]' is present in the data source: I've checked the data source, and the cube builds fine when using UI. What can be causing that Transformer can't see this element when called from a batch file? The command in the batch file looks like this:

cogtr.exe -n2 -c -ju -r4 -lcso=myuser/mypassword -p"E:\Transformer\projects\AU\DBAU_LinealGeneral.pyj"

Any ideas?

[Grim]

In your batch file are you changing to the Cognos\bin directory prior to running the build?

Code Select Expand

C:\
cd progra~1\ibm\cognos\bin
cogtr.exe -n2 -c -ju -lcso=myuser/mypassword -p"E:\Transformer\projects\AU\DBAU_LinealGeneral.pyj"

'-r4' is not needed in the command as this is the default log level.

[qvixote]

Thanks for your reply, Grim.

Yes, my batch file have these lines. And I'm trying directly from the command line too, placed in that directory, with the same result. I'll remove the '-r4', thanks.

Initialiy I thought it was a problem with the package, because if I remove the [PRESENTACION].[FT_ATENCION_URGENCIA].[SEMANA_ESTADISTICA_INT] element from the query in Transformer, it builds correctly, so I made a new project using the same package and I have the same problem. But the strange thing is that I have others previous projects wich use the same package as source and they are not presenting any problem when building from command line.

[Grim]

Did a quick google search on the error...

Do you have a Fix Pack installed on the server that might not be installed on the Transformer install?

Some other possible notes/solutions:
http://www-01.ibm.com/support/docview.wss?uid=swg1PK99005

http://www-01.ibm.com/support/docview.wss?uid=swg21341288

http://www-01.ibm.com/support/docview.wss?uid=swg21468208

[qvixote]

Thanks for your raply, Grim!

I don't know if I have a fix pack installed. When I first came to work here, the server was already installed and I haven't installed anything more. How can I check this?

I did a google search in first place before recurring to the forum, and I did found these results. I've hace discarded these three solutions because they do not apply to my case, for these reasons (respectively):

- In my case I'm not using a report as datasource: I'm using a framework manager package.
- This case is about the error appearing in reports using a cube as data source. In my case the error appear building the cube.
- I'm not having troubles with spanish special characters.

Many thanks!

[bdbits]

This is a bit of a stab in the dark but... I've sometimes seen odd things caused when an underlying data item changes or is deleted, but a category saved into the cube file remains behind and seems to get "stuck" and not properly updated/removed by Transformer. You could try something drastic like a "clean house" under the Tools menu, with the caveat that you should back up the cube first as this can result in changed MUNs for existing categories, potentially breaking reports. But if it does not take long to build, this at least that would tell you if it is related to the saved categories. You can then restore the saved model and try to find the problematic category.

Also, I would make sure all of your temp/work folders are cleaned out, with no files left behind from failed builds.

[prikala]

In the 8.4 version, when cube datasource package contained also a reference to the cube being built (same model used as cube datasource and for cube package publishing), strange things happened. 
Unfortunately I don't remember the exact errors. The solution was to edit datasource package configuration so that cube was excluded.

And this was in version 8.4, no idea if this applies to 10.2.1.

[qvixote]

Thanks you all for the replys. Finally I didn't find out what is happening, but I'm able to build the cubes from command line (and so from batch files) replacing the "-n2" option with "-n". It execute transformer in "interactive" mode instead of "batch", making a empty transformer window appear, but that way there are no errors. Strange thing.

[White light]

We added two new measures to the cubes in Transformer. The cube refreshes with no issues when done manually in Transformer. But when run with batch file, the below error appears relating to newly added measures.

lun. 06 avr. 2020 03:00:13 2 00000000 QE-DEF-0030 Expression parsing error.

lun. 06 avr. 2020 03:00:13 2 00000000 QE-DEF-0359 The query contains a reference to at least one object '[Presentation Layer].[Combined Fact].[MH Adjustment - 9L Cases]' that does not exist.

lun. 06 avr. 2020 03:00:13 2 00000000 QE-DEF-0030 Expression parsing error.

lun. 06 avr. 2020 03:00:13 2 00000000 QE-DEF-0359 The query contains a reference to at least one object '[Presentation Layer].[Combined Fact].[MH Adjustment - Actual Cases]' that does not exist.

lun. 06 avr. 2020 03:00:13 4 00000000 End processing 0 records from data source 'Combined Depletion Fact'.

lun. 06 avr. 2020 03:00:13 4 00000000 Timing, READ DATA SOURCE,00:00:01

lun. 06 avr. 2020 03:00:14 4 00000000 End cube update.

lun. 06 avr. 2020 03:00:14 4 00000000 Timing, TOTAL TIME (CREATE CUBE),00:00:11

lun. 06 avr. 2020 03:00:14 2 00000000 (TR0168) Transformer could not open the data source [Combined Fact]. [->OK]

Has anyone encountered this issue? What can be the possible reason for this?

Using Cognos 10.2.2, sign on to database and Windows sign on is included. Data source is FM package.

Tried republishing the FM package.

Below is the batch file script.

"E:\Program Files (x86)\ibm\cognos\c10_1022\bin\cogtr.exe" -n1 -ksignon=userid/password -g -m"E:\Transformer Models\1 - LATEST MODELS\Depletions Combined Measures\Depletions Combined Measures.pyj"

Thanks