Skip to Content

SAPVIEW Import Package - SAP Installation Error during Import ABAP phase

Hello,

During a sap installation (OS/400+DB2) on the last phase of Import ABAP, I´m facing with an error! When I checked the log files sapinst_dev.log, sapinst.log, import_monitor.log I see in there one error related to SAPVIEW import package which is also the last Import Monitor job in phase Import ABAP.

In import_monitor.log logfile I see this:

TRACE: 2011-08-23 15:51:52 com.sap.inst.migmon.LoadTask run
Loading of 'SAPVIEW' import package is started.

TRACE: 2011-08-23 15:51:52 com.sap.inst.migmon.LoadTask processPackage
Loading of 'SAPVIEW' import package into database:
/usr/sap/DEV/SYS/exe/run/R3load -i SAPVIEW.cmd -dbcodepage 4102 -l SAPVIEW.log -nojournal

ERROR: 2011-08-23 15:52:03 com.sap.inst.migmon.LoadTask run
Loading of 'SAPVIEW' import package is interrupted with R3load error.
Process '/usr/sap/DEV/SYS/exe/run/R3load -i SAPVIEW.cmd -dbcodepage 4102 -l SAPVIEW.log -nojournal' 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

INFO: 2011-08-23 15:52:20
All import packages are processed.

WARNING: 2011-08-23 15:52:20
1 error(s) during processing of packages.

INFO: 2011-08-23 15:52:20
Import Monitor is stopped.

The following lines is from SAPVIEW.log file:

...
WRFV_TYPDIMVAL3E in *LIBL type *FILE not found. MSGID= Job=003898/SAPADM/QJVAEXEC
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) ERROR: DDL statement failed
 (CREATE VIEW "WRFV_TYPDIMVAL3E" ( "MANDT" , "ASSORTYP" , "VTEXTT" , "ASSORDIM3" , "VTEXTD" , "ASSORDIMVAL" , "VTEXT" , "SPRAS"  ) AS SELECT T0001."MANDT", T0001."ASSORTYP", T0002."VTEXT", T0001."ASSORDIM3", T0004."VTEXT",  T0005."ASSORDIMVAL", T0006."VTEXT", T0002."SPRAS" FROM "WRFST_TYP" T0001, "WRFST_TYPT" T0002, "WRFST_DIM" T0003, "WRFST_DIMT" T0004, "WRFST_DIMVAL" T0005 , "WRFST_DIMVALT" T0006 WHERE T0001."MANDT" = T0002."MANDT" AND T0001."MANDT" = T0005."MANDT" AND T0001."MANDT" = T0003."MANDT" AND T0005."MANDT" = T0006."MANDT" AND T0003."MANDT" = T0004."MANDT" AND T0001."ASSORTYP" = T0002."ASSORTYP" AND T0001."ASSORDIM3" = T0005."ASSORDIM" AND T0001."ASSORDIM3" = T0003."ASSORDIM" AND T0005."ASSORDIM" = T0006."ASSORDIM" AND T0005."ASSORDIMVAL" = T0006."ASSORDIMVAL" AND T0003."ASSORDIM" = T0004."ASSORDIM" AND T0002."SPRAS" = T0004."SPRAS" AND T0004."SPRAS" = T0006."SPRAS")
 DbSlExecute: rc = 103
  (SQL error 204)
  error message returned by DbSl:
WRFST_TYP in *LIBL type *FILE not found. MSGID= Job=003898/SAPADM/QJVAEXEC
(DB) ERROR: DDL statement failed
 (DROP VIEW "WRFV_WLMVT")
 DbSlExecute: rc = 103
  (SQL error 204)
  error message returned by DbSl:
WRFV_WLMVT in *LIBL type *FILE not found. MSGID= Job=003898/SAPADM/QJVAEXEC
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) ERROR: DDL statement failed
 (CREATE VIEW "WRFV_WLMVT" ( "MANDT" , "LAYGR" , "LAYMOD_VER" , "SPRAS" , "LTEXT" , "TISTP"  ) AS SELECT T0001."MANDT", T0001."LAYGR", T0001."LAYMOD_VER", T0004."SPRAS", T0004."LTEXT",  T0001."TISTP" FROM "WLMV" T0001, "WRS1" T0002, "TWML" T0003, "TWMLT" T0004 WHERE T0001."MANDT" = T0002."MANDT" AND T0002."MANDT" = T0003."MANDT" AND T0003."MANDT" = T0004."MANDT" AND T0002."ASORT" = T0001."LAYGR" AND T0002."ASORT" = T0003."LAYGR" AND T0001."LAYGR" = T0003."LAYGR" AND T0004."LAYGR" = T0003."LAYGR" AND T0004."LAYGR" = T0001."LAYGR" AND T0004."LAYGR" = T0002."ASORT")
 DbSlExecute: rc = 103
  (SQL error 204)
  error message returned by DbSl:
TWML in *LIBL type *FILE not found. MSGID= Job=003898/SAPADM/QJVAEXEC
(DB) ERROR: DDL statement failed
 (DROP VIEW "WSI_ENTITY_V")
 DbSlExecute: rc = 103
  (SQL error 204)
  error message returned by DbSl:
WSI_ENTITY_V in *LIBL type *FILE not found. MSGID= Job=003898/SAPADM/QJVAEXEC
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) ERROR: DDL statement failed
 (CREATE VIEW "WSI_ENTITY_V" ( "MANDT" , "SERVICE_ID" , "OCI_DETAIL" , "OCI_VALIDATE" , "OCI_SOURCING" , "OCI_BG_SEARCH" , "OPI_DETAIL" , "USE_HTTP_GET" , "ICON_PATH" , "SERVICE_DESCRIPT" , "SPRAS"  ) AS SELECT T0001."MANDT", T0001."SERVICE_ID", T0001."OCI_DETAIL", T0001."OCI_VALIDATE", T0001."OCI_SOURCING",  T0001."OCI_BG_SEARCH", T0001."OPI_DETAIL", T0001."USE_HTTP_GET", T0001."ICON_PATH", T0002."SERVICE_DESCRIPT", T0002."SPRAS" FROM "WSI_ENTITY" T0001, "WSI_DESCRIPTION" T0002 WHERE T0001."MANDT" = T0002."MANDT" AND T0001."SERVICE_ID" = T0002."SERVICE_ID")
 DbSlExecute: rc = 103
  (SQL error 204)
  error message returned by DbSl:
WSI_ENTITY in *LIBL type *FILE not found. MSGID= Job=003898/SAPADM/QJVAEXEC
(DB) INFO: disconnected from DB

/usr/sap/DEV/SYS/exe/run/R3load: job finished with 799 error(s)
/usr/sap/DEV/SYS/exe/run/R3load: END OF LOG: 20110823155203

Can you help me please? I found the sap note 709389 but I don´t know how to solve it!

JDimas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 24, 2011 at 04:24 AM

    Hi,

    The below thread discusses error similar to yours:

    License Error after system copy

    Maybe a RCLSTG *DBXREF command could be of help.

    Also incase above does not resolve, would suggest posting the question at the SAP DB4 forum:

    SAP on IBM i

    Regards,

    Srikishan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member João Dimas

      HI Jao Dimas,

      How did you resolve this issue? I am also getting same error when i am installing NW 7.31 on windows.

      DbSlExecute: rc = 103

        (SQL error 3701)

        error message returned by DbSl:

      [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the view 'V_S_TABLE', because it does not exist or you do not have permission.

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

      (DB) ERROR: DDL statement failed

      (CREATE VIEW [V_S_TABLE] ( [EXIT_NAME] , [IMP_NAME] , [APPNAME] , [TABNAME]  ) AS SELECT T0001."EXIT_NAME", T0002."IMP_NAME", T0002."APPNAME", T0001."TABNAME" FROM "SXS_TABLE" T0001, "SXC_TABLE" T0002 WHERE T0001."TABNAME" = T0002."TABNAME")

      DbSlExecute: rc = 103

        (SQL error 208)

        error message returned by DbSl:

      [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'SXC_TABLE'.

      (DB) INFO: disconnected from DB

      how to find which *.tsk file is responsible for creating these views. Kindly suggest.

      Thanks,

      Krishna