Skip to Content
0
Former Member
Sep 06, 2006 at 04:37 AM

list cube get SQL error: 600

64 Views

Hi, experts

normally we get success when we use the Tcode: listcube, but the SQL error:600 suddenly happened today when we try to use Tcode: listcude, it gave us the error: SQL error:600

1. check SM21:

>Database error 600 requires intervention by the database administrator

>Database error 600 at FET access to table /BI0/03003

>ORA-00600: internal error code, arguments: [kkojcio], [], []

> [], [], [], [], []

2. check ST05

the following SQL statement return RC:600

INSERT INTO "/BI0/0P00000147" ( "DIMID" ,"TC003" ,"TC004" ,"TC005" ,"TC006" ,"TC

007" ) SELECT DISTINCT "D2"."DIMID" ,"S3"."CS_CHART" AS "TC003" ,"S4"."CS_ITEM"

AS "TC004" ,"S5"."CS_SITEM" AS "TC005" ,"S6"."CS_SITEMCT" AS "TC006" ,"S7"."/BIC

/CBO_GTYP" AS "TC007" FROM "/BIC/DS3IC_CFRE2" "D2" , "/BI0/SCS_CHART" "S3" , "/B

I0/SCS_ITEM" "S4" , "/BI0/SCS_SITEM" "S5" , "/BI0/SCS_SITEMCT" "S6" , "/BIC/SCBO

GTYP" "S7" WHERE "D2"."SID0CS_CHART" = "S3"."SID" AND "D2"."SID_0CS_ITEM" = "S

4"."SID" AND "D2"."SID_0CS_SITEM" = "S5"."SID" AND "D2"."SID_0CS_SITEMCT" = "S6"

."SID" AND "D2"."SID_CBO_GTYP" = "S7"."SID"

Pls help, thanks