Skip to Content
0
Former Member
Dec 05, 2006 at 10:23 PM

Error while copy query between infocubes

46 Views

I was trying to copy a query between infocubes and ended with error message.

Query copied from Infocube A to Infocube B. Infocube B has an additional dimension with 2 char's when compared to infocube A.

Using transaction RSZC, I tried to copy the query, but ended up with following error..

1.Program error in class COPY_QRY_TO_CUBE method : UNCAUGHT_EXCEPTION

2.An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RAISING clause

3.The system tried to insert a data record, even though a data record with the same primary key already exists

I also tried using function module RSZ_I_COPY_QRY_TO_CUBE, which was of no help. I get the following message with the function module...

1. Program error in class RS_TESTFRAME_CALL method : UNCAUGHT_EXCEPTION

2. An exception with the type CX_SY_OPEN_SQL_DB occurred, but was neither handled locally, nor declared in a RAISING clause

3. The system tried to insert a data record, even though a data record with the same primary key already exists

I have also tried a solution in BW expert by using debugging mode of the above function module, again this was of no help..

I am BI 7.0 SP09...

Any ideas, Please....

Thanks,

RR

Message was edited by:

Ray R