cancel
Showing results for 
Search instead for 
Did you mean: 

Error while installing IDES 6.0 in the phase Import ABAP

Former Member
0 Kudos

Hi,

We are installing IDES 6.0 in windows on 64bit with database maxdb.We are getting the Error in Import ABAP.There were total 112 to be imported and out of this we have completed 111.In last one we have got the Error.

I am Attaching All log file where it is showing Error Detail.

Please Check and help us on how to proceed with the installation.

Regards,

Rableen

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

In the import_monitor.log, the error details are:

ERROR: 2012-08-07 14:33:44 com.sap.inst.migmon.LoadTask run

Loading of 'SAPVIEW' import package is interrupted with R3load error.

Process 'D:\usr\sap\ES2\SYS\exe\uc\NTAMD64\R3load.exe -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -nolog -c 10000' exited with return code 2.

For mode details see 'SAPVIEW.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

Please check the SAPVIEW.log for errors.

Regards,

Srikishan

Former Member
0 Kudos

Hi Srikishan,

Thanks for your quick reply... I sending you the last few line of SAPVIEW.log.

please check and help us on the issue.

++++++++++++++++++++++++++++++++++++++++++++++++

(CREATE VIEW "V_USR_NAME" ( "MANDT" , "BNAME" , "NAME_FIRST" , "NAME_LAST" , "NAME_TEXT"  ) AS SELECT T0001."MANDT", T0001."BNAME", T0002."NAME_FIRST", T0002."NAME_LAST", T0002."NAME_TEXT" FROM "USR21" T0001, "ADRP" T0002 WHERE T0001."PERSNUMBER" = T0002."PERSNUMBER" AND T0001."MANDT" = T0002."CLIENT")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "V_VGNOA")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "V_VGNOA" ( "MANDT" , "AUFNR" , "AUTYP" , "VORNR" , "LTXA1"  ) AS SELECT T0001."MANDT", T0001."AUFNR", T0001."AUTYP", T0003."VORNR", T0003."LTXA1" FROM "AUFK" T0001, "AFKO" T0002, "AFVC" T0003 WHERE T0001."MANDT" = T0002."MANDT" AND T0001."MANDT" = T0003."MANDT" AND T0001."AUFNR" = T0002."AUFNR" AND T0002."AUFPL" = T0003."AUFPL")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "V_VPKAD01DLI")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "V_VPKAD01DLI" ( "MANDT" , "DLINR" , "OBJNR" , "POPER" , "TWAER" , "MEINH" , "MANUAL" , "KSTAR" , "KOSTL" , "LSTAR" , "MATNR" , "STAGR" , "FIPOS" , "WRTTP" , "VERSN" , "WERKS" , "PRODU" , "FAKTF" , "BEMOT" , "BELNR" , "BUZEI" , "ARBPL" , "AWERK" , "PRZNR" , "ASNUM" , "PERNR" , "Z_OBJNR2" , "/CBAD/ORIG_OBJNR" , "/CBAD/BILL_WBS" , "ORDERED_PROD" , "CATEGORY_ID" , "AWSYS" , "SERV_AGENT_ID" , "REF_OBJECT_ID" , "REF_OBJECT_ITEM" , "ORIG_OBJNR" , "FAREA" , "RGRANT_NBR" , "WBS_ELEMENT" , "ORDERID" , "FUNDS_CTR" , "FUND" , "SPONSORED_PROG" , "SPONSORED_CLASS" , "GL_SIRID" , "REFDOCNR" , "REFDOCLN" , "SGTXT" , "GM_VALUETYPE" , "ASSETMAINO" , "ASSETSUBNO" , "DLISRC" , "PROFNR" , "TIMESTMP" , "VPKID" , "POSNR" , "VWAER" , "MATNR_SD" , "SO_WTGBTR" , "SO_WOGBTR" , "SO_WKGBTR" , "SO_MEGBTR" , "IN_WTGBTR" , "IN_WOGBTR" , "IN_WKGBTR" , "IN_MEGBTR" , "NO_WTGBTR" , "NO_WOGBTR" , "NO_WKGBTR" , "NO_MEGBTR" , "NETVALUE"  ) AS SELECT T0001."MANDT", T0001."DLINR", T0001."OBJNR", T0001."POPER", T0001."TWAER",  T0001."MEINH", T0001."MANUAL", T0001."KSTAR", T0001."KOSTL", T0001."LSTAR", T0001."MATNR", T0001."STAGR", T0001."FIPOS", T0001."WRTTP", T0001."VERSN", T0001."WERKS", T0001."PRODU", T0001."FAKTF", T0001."BEMOT", T0001."BELNR", T0001."BUZEI", T0001."ARBPL", T0001."AWERK", T0001."PRZNR", T0001."ASNUM", T0001."PERNR", T0001."Z_OBJNR2", T0001."/CBAD/ORIG_OBJNR", T0001."/CBAD/BILL_WBS", T0001."ORDERED_PROD", T0001."CATEGORY_ID", T0001."AWSYS", T0001."SERV_AGENT_ID", T0001."REF_OBJECT_ID", T0001."REF_OBJECT_ITEM", T0001."ORIG_OBJNR", T0001."FAREA", T0001."RGRANT_NBR", T0001."WBS_ELEMENT", T0001."ORDERID", T0001."FUNDS_CTR", T0001."FUND", T0001."SPONSORED_PROG", T0001."SPONSORED_CLASS", T0001."GL_SIRID", T0001."REFDOCNR", T0001."REFDOCLN", T0001."SGTXT", T0001."GM_VALUETYPE", T0001."ASSETMAINO", T0001."ASSETSUBNO", T0001."DLISRC", T0001."PROFNR", T0001."TIMESTMP", T0002."VPKID", T0002."POSNR", T0002."VWAER", T0002."MATNR_SD", T0002."SO_WTGBTR", T0002."SO_WOGBTR", T0002."SO_WKGBTR", T0002."SO_MEGBTR", T0002."IN_WTGBTR", T0002."IN_WOGBTR", T0002."IN_WKGBTR", T0002."IN_MEGBTR", T0002."NO_WTGBTR", T0002."NO_WOGBTR", T0002."NO_WKGBTR", T0002."NO_MEGBTR", T0002."NETVALUE" FROM "AD01DLI" T0001, "VPKDLI" T0002 WHERE T0001."MANDT" = T0002."MANDT" AND T0001."DLINR" = T0002."DLINR")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "V_XCJPTAXOFFICE")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "V_XCJPTAXOFFICE" ( "MANDT" , "TAXOFFICE" , "NAME_ORG1" , "NAME_ORG2" , "NAME_ORG3" , "NAME_ORG4"  ) AS SELECT T0001."MANDT", T0001."TAXOFFICE", T0002."NAME_ORG1", T0002."NAME_ORG2", T0002."NAME_ORG3",  T0002."NAME_ORG4" FROM "TIVXCJPTAXOFFICE" T0001, "BUT000" T0002 WHERE T0002."CLIENT" = T0001."MANDT" AND T0002."PARTNER" = T0001."TAXOFFICE")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "WFAEXV_AGTORG_BP")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "WFAEXV_AGTORG_BP" ( "CLIENT" , "PARTNER" , "ORG_PLVAR" , "ORG_OTYPE" , "ORG_OBJID" , "START_DATE" , "END_DATE" , "TYPE" , "BPKIND" , "BU_GROUP" , "BPEXT" , "BU_SORT1" , "BU_SORT2" , "NAME_LAST" , "NAME_FIRST" , "NAME_LST2" , "NAME_LAST2" , "PERSNUMBER" , "BIRTHDT" , "PERNO" , "TEMP_FLAG" , "PAYCLASS_LOC" , "PAYCLASS_ID" , "BREAKRULE_LOC" , "BREAKRULESETID" , "DFTSET_GRP_LOC" , "DFTSET_GRP_ID" , "RELUCTANCE_LOC" , "RELUCTANCE_ID" , "AGE_QUAL_ID"  ) AS SELECT T0001."CLIENT", T0001."PARTNER", T0002."ORG_PLVAR", T0002."ORG_OTYPE", T0002."ORG_OBJID",  T0002."START_DATE", T0002."END_DATE", T0001."TYPE", T0001."BPKIND", T0001."BU_GROUP", T0001."BPEXT", T0001."BU_SORT1", T0001."BU_SORT2", T0001."NAME_LAST", T0001."NAME_FIRST", T0001."NAME_LST2", T0001."NAME_LAST2", T0001."PERSNUMBER", T0001."BIRTHDT", T0001."PERNO", T0002."TEMP_FLAG", T0002."PAYCLASS_LOC", T0002."PAYCLASS_ID", T0002."BREAKRULE_LOC", T0002."BREAKRULESETID", T0002."DFTSET_GRP_LOC", T0002."DFTSET_GRP_ID", T0002."RELUCTANCE_LOC", T0002."RELUCTANCE_ID", T0002."AGE_QUAL_ID" FROM "BUT000" T0001, "WFA_AGT_ORG" T0002 WHERE T0001."CLIENT" = T0002."MANDT" AND T0001."PARTNER" = T0002."PARTNER")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "WFDBPV_SEARCH")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "WFDBPV_SEARCH" ( "CLIENT" , "PARTNER_NUMBER" , "SET_ID" , "RESUID" , "SIMID" , "TYPE" , "AUGRP" , "BPKIND" , "BPEXT" , "MC_NAME1" , "MC_NAME2" , "PARTNER_ID" , "EXTERNAL_KEY" , "RES_TYPE" , "AWTYP" , "LOGSYS" , "DESCRIPTION" , "CAPACITY_CALC" , "CREATED_BY" , "CREATED" , "CHANGED_BY" , "CHANGED" , "XDELE" , "XBLCK"  ) AS SELECT T0001."CLIENT", T0001."PARTNER", T0002."SET_ID", T0003."RESUID", T0003."SIMID",  T0001."TYPE", T0001."AUGRP", T0001."BPKIND", T0001."BPEXT", T0001."MC_NAME1", T0001."MC_NAME2", T0001."PARTNER_GUID", T0002."EXTERNAL_KEY", T0003."RES_TYPE", T0003."AWTYP", T0003."LOGSYS", T0003."NAME", T0003."CAPA_INPUT_TYPE", T0003."CREATED_BY", T0003."CREATED", T0003."CHANGED_BY", T0003."CHANGED", T0001."XDELE", T0001."XBLCK" FROM "BUT000" T0001, "WFD_ATS_000" T0002, "/SAPAPO/LRPRESO" T0003 WHERE T0001."PARTNER_GUID" = T0002."PARTNER_ID" AND T0001."CLIENT" = T0002."MANDT" AND T0002."SET_ID_22" = T0003."RESUID" AND T0002."MANDT" = T0003."MANDT")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "WFMEXV_AGTORG_BP")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "WFMEXV_AGTORG_BP" ( "CLIENT" , "PARTNER" , "ORG_PLVAR" , "ORG_OTYPE" , "ORG_OBJID" , "START_DATE" , "END_DATE" , "TYPE" , "BPKIND" , "BU_GROUP" , "BPEXT" , "BU_SORT1" , "BU_SORT2" , "NAME_LAST" , "NAME_FIRST" , "NAME_LST2" , "NAME_LAST2" , "PERSNUMBER" , "BIRTHDT" , "PERNO" , "TEMP_FLAG" , "PAYCLASS_LOC" , "PAYCLASS_ID" , "BREAKRULE_LOC" , "BREAKRULESETID" , "DFTSET_GRP_LOC" , "DFTSET_GRP_ID" , "RELUCTANCE_LOC" , "RELUCTANCE_ID" , "AGE_QUAL_ID"  ) AS SELECT T0001."CLIENT", T0001."PARTNER", T0002."ORG_PLVAR", T0002."ORG_OTYPE", T0002."ORG_OBJID",  T0002."START_DATE", T0002."END_DATE", T0001."TYPE", T0001."BPKIND", T0001."BU_GROUP", T0001."BPEXT", T0001."BU_SORT1", T0001."BU_SORT2", T0001."NAME_LAST", T0001."NAME_FIRST", T0001."NAME_LST2", T0001."NAME_LAST2", T0001."PERSNUMBER", T0001."BIRTHDT", T0001."PERNO", T0002."TEMP_FLAG", T0002."PAYCLASS_LOC", T0002."PAYCLASS_ID", T0002."BREAKRULE_LOC", T0002."BREAKRULESETID", T0002."DFTSET_GRP_LOC", T0002."DFTSET_GRP_ID", T0002."RELUCTANCE_LOC", T0002."RELUCTANCE_ID", T0002."AGE_QUAL_ID" FROM "BUT000" T0001, "WFMCAS_AGT_ORG" T0002 WHERE T0001."CLIENT" = T0002."MANDT" AND T0001."PARTNER" = T0002."PARTNER")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "WTY_MCOUNTERST")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "WTY_MCOUNTERST" ( "MANDT" , "ATNAM" , "SPRAS" , "ATBEZ"  ) AS SELECT T0003."MANDT", T0002."ATNAM", T0003."SPRAS", T0003."ATBEZ" FROM "BGMZ" T0001, "CABN" T0002, "CABNT" T0003 WHERE T0002."MANDT" = T0001."MANDT" AND T0002."ATINN" = T0001."GAZAL" AND T0002."ADZHL" = T0003."ADZHL" AND T0002."MANDT" = T0003."MANDT" AND T0002."ATINN" = T0003."ATINN")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "YIV_INFOB_ASS")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "YIV_INFOB_ASS" ( "KEY_EXT1" , "KEY_EXT2" , "KEY_EXT3" , "KEY_EXT4" , "KEY_INT1" , "KEY_INT2" , "KEY_INT3" , "KEY_ADD2" , "LANGU" , "STEXT"  ) AS SELECT T0001."MANDT", T0001."BUKRS", T0001."ANLN1", T0003."KEY_EXT4", T0003."KEY_INT1",  T0003."KEY_INT2", T0003."KEY_INT3", T0003."KEY_ADD2", T0002."LANGU", T0001."ANLHTXT" FROM "ANLH" T0001, "YIT_LANGUAGES" T0002, "YIT_INITIAL" T0003 WHERE T0003."KEY_EXT1" = ' ')

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "YIV_INFOB_ASS_R")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "YIV_INFOB_ASS_R" ( "UTYP" , "INUM" , "KEY_EXT1" , "KEY_EXT2" , "KEY_EXT3" , "KEY_EXT4" , "KEY_INT1" , "KEY_INT2" , "KEY_INT3" , "LANGU" , "STEXT"  ) AS SELECT T0004."UTYP", T0004."INUM", T0004."KEY_EXT1", T0004."KEY_EXT2", T0004."KEY_EXT3",  T0003."KEY_EXT4", T0003."KEY_INT1", T0003."KEY_INT2", T0003."KEY_INT3", T0002."LANGU", T0001."ANLHTXT" FROM "ANLH" T0001, "YIT_LANGUAGES" T0002, "YIT_INITIAL" T0003, "YIT_INFOBASE_XD" T0004 WHERE T0004."KEY_EXT1" = T0001."MANDT" AND T0004."KEY_EXT2" = T0001."BUKRS" AND T0004."KEY_EXT3" = T0001."ANLN1" AND T0003."KEY_EXT1" = ' ')

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "YIV_INFOB_BNK")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "YIV_INFOB_BNK" ( "KEY_EXT1" , "KEY_EXT2" , "KEY_EXT3" , "KEY_EXT4" , "KEY_INT1" , "KEY_INT2" , "KEY_INT3" , "KEY_ADD2" , "LANGU" , "STEXT"  ) AS SELECT T0001."MANDT", T0001."BANKS", T0001."BANKL", T0003."KEY_EXT4", T0003."KEY_INT1",  T0003."KEY_INT2", T0003."KEY_INT3", T0003."KEY_ADD2", T0002."LANGU", T0001."BANKA" FROM "BNKA" T0001, "YIT_LANGUAGES" T0002, "YIT_INITIAL" T0003 WHERE T0003."KEY_EXT1" = ' ')

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "YIV_INFOB_BNK_R")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "YIV_INFOB_BNK_R" ( "UTYP" , "INUM" , "KEY_EXT1" , "KEY_EXT2" , "KEY_EXT3" , "KEY_EXT4" , "KEY_INT1" , "KEY_INT2" , "KEY_INT3" , "KEY_ADD2" , "LANGU" , "STEXT"  ) AS SELECT T0004."UTYP", T0004."INUM", T0004."KEY_EXT1", T0004."KEY_EXT2", T0004."KEY_EXT3",  T0003."KEY_EXT4", T0003."KEY_INT1", T0003."KEY_INT2", T0003."KEY_INT3", T0003."KEY_ADD2", T0002."LANGU", T0001."BANKA" FROM "BNKA" T0001, "YIT_LANGUAGES" T0002, "YIT_INITIAL" T0003, "YIT_INFOBASE_XD" T0004 WHERE T0004."KEY_EXT1" = T0001."MANDT" AND T0004."KEY_EXT2" = T0001."BANKS" AND T0004."KEY_EXT3" = T0001."BANKL" AND T0004."DATYP" = 'BNK' AND T0003."KEY_EXT1" = ' ')

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "YIV_INFOB_NET")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "YIV_INFOB_NET" ( "KEY_EXT1" , "KEY_EXT2" , "LANGU" , "STEXT"  ) AS SELECT T0001."MANDT", T0001."AUFNR", T0002."LANGU", T0001."KTEXT" FROM "AUFK" T0001, "YIT_LANGUAGES" T0002 WHERE T0001."AUTYP" = '20')

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "YIV_INFOB_ORD")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "YIV_INFOB_ORD" ( "KEY_EXT1" , "KEY_EXT2" , "LANGU" , "STEXT"  ) AS SELECT T0001."MANDT", T0001."AUFNR", T0002."LANGU", T0001."KTEXT" FROM "AUFK" T0001, "YIT_LANGUAGES" T0002 WHERE T0001."AUTYP" <> '20')

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "ZIDES_USER_ADDR")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "ZIDES_USER_ADDR" ( "MANDT" , "BNAME" , "NAME_FIRST" , "NAME_LAST" , "NAME_TEXTC" , "TEL_EXTENS" , "NAME1" , "CITY1" , "POST_CODE1" , "SMTP_ADDR"  ) AS SELECT T0001."MANDT", T0001."BNAME", T0003."NAME_FIRST", T0003."NAME_LAST", T0003."NAME_TEXT",  T0004."TEL_EXTENS", T0002."NAME1", T0002."CITY1", T0002."POST_CODE1", T0005."SMTP_ADDR" FROM "USR21" T0001, "ADRC" T0002, "ADRP" T0003, "ADCP" T0004, "ADR6" T0005 WHERE T0002."CLIENT" = T0001."MANDT" AND T0002."ADDRNUMBER" = T0001."ADDRNUMBER" AND T0003."CLIENT" = T0001."MANDT" AND T0003."PERSNUMBER" = T0001."PERSNUMBER" AND T0004."CLIENT" = T0001."MANDT" AND T0004."ADDRNUMBER" = T0001."ADDRNUMBER" AND T0004."PERSNUMBER" = T0001."PERSNUMBER" AND T0005."CLIENT" = T0001."MANDT" AND T0005."ADDRNUMBER" = T0001."ADDRNUMBER" AND T0005."PERSNUMBER" = T0001."PERSNUMBER")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "ZSPRJ_ESLL4")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "ZSPRJ_ESLL4" ( "MANDT" , "PACKNO" , "SRVPOS" , "SPRAS" , "ASKTX"  ) AS SELECT T0001."MANDT", T0001."PACKNO", T0001."SRVPOS", T0002."SPRAS", T0002."ASKTX" FROM "ESLL" T0001, "ASMDT" T0002 WHERE T0002."MANDT" = T0001."MANDT" AND T0002."ASNUM" = T0001."SRVPOS" AND T0001."PACKAGE" <> 'X' AND T0001."SRVPOS" <> '' AND ( T0002."SPRAS" = 'J' OR T0002."SPRAS" = 'E' ))

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) ERROR: DDL statement failed

(DROP VIEW "ZXFT_LS_CHMV01")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "ZXFT_LS_CHMV01" ( "MANDT" , "REC_ID" , "MATNR" , "AENNR" , "INITIATOR" , "TRADE_NAME" , "CHANGE_TYPE_ID" , "FORMULATION" , "DOSE" , "LATEST_IMPL_AT" , "CH_APPL_01" , "CH_APPL_02" , "CH_APPL_03" , "CH_APPL_04" , "CH_APPL_05" , "CH_APPL_06" , "CH_APPL_07" , "APPROVAL_COUNTER" , "REASON_OF_CHANGE" , "TRADE_NAME_UPPER" , "CREATED_AT" , "CREATED_BY" , "CHANGED_AT" , "CHANGED_BY" , "LATEST_START" , "REQUIRED_END" , "STATE_SYST" , "STATE_APPL"  ) AS SELECT T0001."MANDT", T0001."REC_ID", T0001."MATNR", T0001."AENNR", T0001."INITIATOR",  T0001."TRADE_NAME", T0001."CHANGE_TYPE_ID", T0001."FORMULATION", T0001."DOSE", T0001."LATEST_IMPL_AT", T0001."CH_APPL_01", T0001."CH_APPL_02", T0001."CH_APPL_03", T0001."CH_APPL_04", T0001."CH_APPL_05", T0001."CH_APPL_06", T0001."CH_APPL_07", T0001."APPROVAL_COUNTER", T0001."REASON_OF_CHANGE", T0001."TRADE_NAME_UPPER", T0002."CREATED_AT", T0002."CREATED_BY", T0002."CHANGED_AT", T0002."CHANGED_BY", T0002."LATEST_START", T0002."REQUIRED_END", T0002."STATE_SYST", T0002."STATE_APPL" FROM "ZXFT_LS_CHMT01" T0001, "/XFT/SRM_REC02" T0002 WHERE T0001."MANDT" = T0002."MANDT" AND T0001."REC_ID" = T0002."REC_ID")

DbSlExecute: rc = 103

  (SQL error -942)

  error message returned by DbSl:

(DB) INFO: disconnected from DB

D:\usr\sap\ES2\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1158 error(s)

D:\usr\sap\ES2\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20120807150851

++++++++++++++++++++++++++++++++++++++++++++++++

Regards,

Rableen

former_member189725
Active Contributor
0 Kudos

Refer this SAP note

Note 709389 - Problems during load of SAPVIEW

I believe some packages are there which are still not imported correctly .

Can you paste the content of import_state.properties file.

If every other  package has been imported successfully except for SAPVIEW, I suggest you update the R3load and DBSL patch level .

Regards

Ratnajit