SAPVIEW Import Package - SAP Installation Error during Import ABAP phase

[joo_migueldimas]

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

[Former Member]

Hi,

The below thread discusses error similar to yours:

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:

Regards,

Srikishan

[joo_migueldimas]

Hello Srikishan D,

Ok... this error is solved!

In fact, this error was related to another one, an error that occurred earlier, in a previous task - SAPAPPL2.tsk. I had an error during the task SAPAPPL2.tsk (which is the task that is responsible in create tables on database). This error was related with some user permissions problems during the process of tables record.

The post that describe the error in SAPAPPL2 task, is in the following SDN link/post:

So this error had nothing to do with this task (SAPVIEW.tsk) but in fact with the previous task (SAPAPPL2.tsk)!

But thank you anyway for your help Srikishan.

Kind regards,

João Dimas - Portugal

[Former Member]

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