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

Query Subject Definition Errors - FM

Started by jkrack, 09 Mar 2021 03:04:44 PM

Previous topic - Next topic

jkrack

I am getting some SQL errors when trying to add a SQL table as a Data Source in my project. The table is a fact table and isn't joined to anything. Querying the table doesn't give any errors.

I am able to select the table but when it validates I get these errors:

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-239'.
UDA-SQL-0519 An unexpected error occurred attempting to retrieve column metadata for the table or view "Fact_Sales".
UDA-SQL-0205 An unexpected error has occurred during the PREPARE operation.

I have imported other tables from the same database/schema before and after getting these errors.

Any help would be much appreciated!

MFGF

Quote from: jkrack on 09 Mar 2021 03:04:44 PM
I am getting some SQL errors when trying to add a SQL table as a Data Source in my project. The table is a fact table and isn't joined to anything. Querying the table doesn't give any errors.

I am able to select the table but when it validates I get these errors:

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-239'.
UDA-SQL-0519 An unexpected error occurred attempting to retrieve column metadata for the table or view "Fact_Sales".
UDA-SQL-0205 An unexpected error has occurred during the PREPARE operation.

I have imported other tables from the same database/schema before and after getting these errors.

Any help would be much appreciated!

Hi,

I don't really have much information to base an answer on, so I'm guessing here. If you look at the data types of the columns in the table, are there any columns with unusual types? You didn't state what type of database you are connecting to, but maybe you have something like a BLOB or CLOB in the table? It's interesting that querying the table doesn't give you errors. Is that querying the entire table or just a subset of columns?

Cheers!

MF.
Meep!