TR1901 PowerPlay Data Server could not find a record (Category)

[tsuable]

Hi,

I'm getting this error when building the cube. Particularly when the Transformer is in the middle of commiting the cube.

I already fixed all the orphans
I already made sure there is sufficent resources
I already made sure that the anti virus does not scan the folder

We are in the health care industry and this only happens when i include the patient ID as a dimension in the model.

Any Suggestions Please...

 

[blom0344]

Check the IQD('s) on the relation between patient ID and category. any chance you include patient ID's without a matching category?

Ties Blom

 

[tsuable]

I am using Framework Manager and Report Studio.

I am only using 1 dimension and 1 count...

I almost think this is a resource or space issue... the current date range that i filter on in report studio is 2005-01-01 and 2007-07-31 (this is when i get the error)


but when i change the date range
to 2007-01-01 and 2007-12-31
or 2005-01-01 and 2006-12-31

the Cube creation goes through just fine...

TIA Ties