Question:
We had deleted many requests (by mistake) from the ODS (which were active earlier), (as this is in development sys) except for one request. Now, we want to delete this request but we get the error:
DBIF_RSQL_SQL_ERROR
CX_SY_OPEN_SQL_DB
In manage "NEW Data", "Active Data", "Change Log" shows zero records (the same even when I go thru se11). I have seen the note 84348, which basically speaks about the Intrans and Maxtrans for an ODS. Once set, maybe it works (I've still have not tried it).
However my question is, how can I delete the request which does not have any data. Anyone, pls help.
Thanks in adv.
Answer:
Have you tried right-clicking the ODS in question and selecting "Delete Data?"
Are there any cubes that follow this ODS in the data flow? Is the 0 record request in those cubes? If you so you might want to delete that request in the cube first and then the ODS.
Answer:
Does the short dump include a similar line in the "How to correct the error" segment?
The exception must either be prevented, caught within the procedure
"RSDU_DATA_EXISTS_TABLE"
"(FUNCTION)", or declared in the procedure's RAISING clause.
To prevent the exception, note the following:
Database error text........: "ORA-01502: index 'SAPBWD./BIC/AZPM_ONT00~0' or partition of such index is in unusable state"
If so, you need to recreate the index. You can do this either by asking a DBA to recreate it for you, or through transaction SE14:
-Click on "Indexes"
-then "Delete database index"
-finally, "Create database index"
Hope this helps!
Todd