If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Transformer Could Not Open Data Source When Called from Batch File

Started by White light, 06 Apr 2020 02:14:58 PM

Previous topic - Next topic

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

White light

This issue has been addressed.

This was related to package publishing in framework manager. We were publishing package with 'Enable model versioning' checked.But the cube batch script was still pointing to original package that didn't contain newly added columns.So we published the package without model versioning and now the batch file is pointing to latest latest package and batch script runs without any issues.

Below resources helped me in addressing this.

https://www.ibm.com/support/pages/unable-build-powercube-command-line-after-updating-model-new-query-items-package-data-source

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_fm.doc/t_model_versions_and_reports.html

Although if someone can elaborate on pros and cons of model versioning, that would be helpful.

Thanks

MFGF

Quote from: White light on 29 May 2020 01:22:59 PM
This issue has been addressed.

This was related to package publishing in framework manager. We were publishing package with 'Enable model versioning' checked.But the cube batch script was still pointing to original package that didn't contain newly added columns.So we published the package without model versioning and now the batch file is pointing to latest latest package and batch script runs without any issues.

Below resources helped me in addressing this.

https://www.ibm.com/support/pages/unable-build-powercube-command-line-after-updating-model-new-query-items-package-data-source

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_fm.doc/t_model_versions_and_reports.html

Although if someone can elaborate on pros and cons of model versioning, that would be helpful.

Thanks

Hi,

Does this old post of mine help?

https://www.cognoise.com/index.php/topic,29848.msg96880.html#msg96880

Cheers!

MF.
Meep!

White light