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 Error (Report as datasource)

Started by aerick911, 06 Jun 2014 12:00:07 PM

Previous topic - Next topic

aerick911

I have a report that feeds an invoiced orders cube and it runs fine on development, however, when I pushed the FM, cube and feeder report to prod, I am receiving a strange error I've never seen before.  I've attempted to copy the report spec to dev to prod, republish the FM, etc. 

The feeder report does validate and run correctly in DEV and PROD, however when I attempt to generate the cube on PROD I receive the following error in Transformer.  (googling only returns an error list, which is not a good sign...)

"RQP-DEF-0390;Relational provider cannot process a query with a non-relational query subject"

Any advice???


cognostechie

Can't say anything specific but that error contains the word 'query subject' which is a specific term used only in Framework Manager
so you might want to look into the query subjects used in FM for the cube. Any chance a DMR is being used to generate queries for the cube? DMR is OLAP over relational so it might mean non-relational in the error.