Import package SAPVIEW failed sql error 955

[Former Member]

Hi all,

we are in process of Installing ERP 6.0 during import load

out of 38 one load failed , i found the error is from SAPVIEW import package.

To avoid sql 955 we have to drop the object, but i am unable to trace the object name ... plz help me in identifying the object_name from the below error log.

Thanks,

Subhash.G

(CREATE VIEW "/1CN/APASAP00001" ( "CLIENT" , "PDD_ENT_PRODUCT" , "KSCHL" , "OBJECT_ID" , "TIMESTAMP_TO" , "RELEASE_STATUS" , "KOPOS" , "CREATED_ON" , "VARNUMH" , "TIMESTAMP_FROM" , "KSCHL_SUPP" , "COND_GROUP_ID" , "MAINT_STATUS" , "CREATED_BY" , "SUPP_EXIST" , "SCALE_DIM" , "PDD_SUB_PRODUCT" , "PDD_SUB_QTY_UNIT" , "PDD_SUB_REASON" , "PDD_MRP_IND" , "PDD_DELI_CONTROL" ) AS SELECT T0001."CLIENT", T0001."PDD_ENT_PRODUCT", T0001."KSCHL", T0001."OBJECT_ID", T0001."TIMESTAMP_TO", T0001."RELEASE_STATUS", T0001."KOPOS", T0001."CREATED_ON", T0001."VARNUMH", T0001."TIMESTAMP_FROM", T0001."KSCHL_SUPP", T0001."COND_GROUP_ID", T0001."MAINT_STATUS", T0001."CREATED_BY", T0001."SUPP_EXIST", T0001."SCALE_DIM", T0001."PDD_SUB_PRODUCT", T0001."PDD_SUB_QTY_UNIT", T0001."PDD_SUB_REASON", T0001."PDD_MRP_IND", T0001."PDD_DELI_CONTROL" FROM "/1CN/CPASAP00001" T0001)

DbSlExecute: rc = 102

(SQL error 955)

Edited by: subhash gadde on Apr 5, 2008 6:09 PM

[Former Member]

`Thanks

[Former Member]

Hi subhash gadde. Can you provide full log ?

The OS , DB you use are? Provide more information.

Why you think "To avoid sql 955 we have to drop the object" ?

SQL 955 error can arise for the different reasons.

Regards.

[Former Member]

Hi ,

I have solved the issue... i have started the Installtion again... it went smooth...

Thanks,

Subhash.G