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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on 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 a 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.