Transformer hangs while generating categories and creating the cubes

[sekharmunaga]

Hi

Problem Description

Using an IQD file as a datasource. when generating categories in the transformer 7.3, the PC hangs.There are sufficient resources to complete the processing of this model.
IQD's are created in Framework manager 8.1.
Even for few records also this is happening.

Please give the solution.


OS: Windows 2000
Database: Oracle
Framework manager 7.3
Email: chandra.munaga@tcs.com

Thanks
Chandra

[Blue]

Does the data return correctly doing a Test in FM?
Have you tried running the SQL from the IQD in a DB query tool such as SQL*Plus? 
If so does it work properly there?
If it does then maybe you need to customise the SQL in the IQD to improve performance.  The version created by FM may be inefficient.

[sekharmunaga]

Thank you very much. I have tried all the steps you have given.
I am able to test in FM and SQL plus. There is no problem with.
This table contains just 20 records with ao columns. But still i am facing the problem

Thanks

[Blue]

Is there a data type mismatch with what is defined in the Transformer data source and what's in the database?
Does the data source contain a field with a data type that Transformer can't handle?  E.g. the other day we had this problem where a column in the Oracle database was defined as CLOB (LONG) and Transformer wanted to translate it into a BLOB.  The solution was to change the data type of the column in the database to a VARCHAR2.