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???
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.