Cognos Transformer error TR0109

[koengi01]

Hello,

When I run a cube I'll recieve the error TR0109 "Couldn't read source date" I'm using a iqd file and an Access table.
When I run the cube with 100.000 records, there's no problem, if I run it with more records, this error message appears. Anyone got an idea??

Thx
Koengi

 

[MacintoshF16]

In Cognos
If u use Access Database, U will not able access morethan 100000 records. This specification has given by cognos.

And on morething , if u try to export 100000 record file to excel from powerplay , it wont supprt, will get the error, export error.

Thats it.. U have to spilt the database as two tables.


Macintosh

 

[koengi01]

Thx for your reply.
A bit strange cause 2 weeks ago I created one of 129.000 rec's from Access. If I split it into 2 tables, can I still create one cube????

Regards Koengi

 

[MacintoshF16]

koengi
Yes, u can create a one cube . I will work good. Be sure that u have to spilt the table into two.

Macintosh

 

[koengi01]

Macintosh,

Ok, but please tell me how 2 do it.
The easy part is dividing one table into 2 tables.
But how do I setup Impromptu????

regards Koengi