Hi,
I am trying to insert an iqd datasource in transformer. when I insert eh datasource, transformer gives an error as below. And then it creates the Datasource with just 3 fields, where as the SQL for iqd contains more than 73 fields.
TR0638 - the current SQL contains 3 columns while the columns list has 73 columns.Are you sure you want to continue.
can you please give me the possible reasons?
Thanks,
Jaspire
Cognos KB Document solution for the problem you face
Root Cause:
1.This could happen due to multiple selects in the IQD generated by Framework Manager.
2.Another reason could be use of local functions in FM.
Solution:
1. Solution for root cause # 1 - An alternative would be using csv file format for externalizing instead of IQD file format. In Framework Manager Externalize to csv instead of IQD. Then import the csv file into Transformer.
2. Solution for root cause # 2 - You may experience this error if you created calculations in Framework Manager that use local functions of the product and not of the database. Since, only Native SQL is supported in IQD generation, and not Cognos SQL. All query items referenced in the IQD should be checked to ensure that only database functions are used, and that the data source in Framework Manager has the Query Processing property set to Database only.
Thanks Gobinath,
I tried with Query processing set to database and checked for local functions, but still its not working. I will try to externalise with CSV file.
Jaspire
Unfortunately,
I was told that I can't use CSV file. I should use IQD only. Yes there are multiple selects in the SQL. I could see the data in framework manager. So how can that SQL not work in Transformer?
Can you please suggest any other possible solution?
Thanks
Multiple Selects won't work in Transformer, period. Its engine doesn't have the ability to stitch them together, like Impromptu, CRN and C8 can.
TO Fix your IQD, multiple selects indicate you are missing a required join between 2 of the tables in the Selects.