Cognos Transformer error TR0109

[MarkWilliamson]

While trying to generate a cube in transformer I receive the following error message :

TR0109 - Transformer couldn't read the data source. I am using oracle and the DB is fine and the table can be read. The process bombs out at the 6th layer of the data source.

Anyone experience a similar problem ?

Thanks in advance to all who reply !

 

[drlex]

Mark,
In transformer, if you click on the data source viewer, can you preview the data from the data source in the preview window?


soi la, soi carré

 

[wolves]

Have had this error several times, but for several different reasons. Once I was out of space, once I my data fields in the db did not match my fields in the Transformer.
Like drlex said, check the datasource viewer to see the code. Also, list the entire error message after the 'TR0109 - Transformer couldn't read the data source', it may help with looking up the info.