SAPview.tsk table issue while new installtion of SOLUTION MANAGER 7.1

[Former Member]

  Dear Experts,

We are  getting below error while fresh installing of sol. manager 7.1 on oracle 11g2. We tried to follow below SDN link & change all the status to err in SAPVIEW.TSK and retry with the import. but no success?????

      http://scn.sap.com/thread/2084581

Excerpts from error-> 

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file /sapdumps/51042607_SR1Export_2/DATA_UNITS/EXP4/DB/SQLFiles.LST

(SQL) INFO: /sapdumps/51042607_SR1Export_2/DATA_UNITS/EXP4/DB/SQLFiles.LST not found

(SQL) INFO: Searching for SQL file .SQL

(SQL) INFO: .SQL not found

(SQL) INFO: Searching for SQL file /sapdumps/51042607_SR1Export_2/DATA_UNITS/EXP4/DB/ORA/.SQL

(SQL) INFO: /sapdumps/51042607_SR1Export_2/DATA_UNITS/EXP4/DB/ORA/.SQL not found

(DB) INFO: /MAP/M_D_FIF_NSD created #20120905003633

(DB) ERROR: DDL statement failed

(CREATE VIEW "/MAP/M_D_KYF" ( "KYFNM"  ) AS SELECT T0001."KYFNM" FROM "RSDKYF" T0001 WHERE T0001."OBJVERS" = 'A' AND ( T0001."KYFTP" = 'AMO' OR T0001."KYFTP" = 'QUA' OR T0001."KYFTP" = 'NUM' ) AND T0001."NCUMFL" = ' ')

DbSlExecute: rc = 103

  (SQL error 942)

  error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

/usr/sap/<SID>/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/<SID>/SYS/exe/run/R3load: END OF LOG: 20120905003633

/usr/sap/<SID>/SYS/exe/run/R3load: START OF LOG: 20120905003723

/usr/sap/<SID>/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP

/usr/sap/<SID>/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]

Compiled Dec  1 2011 20:22:48

/usr/sap/<SID>/SYS/exe/run/R3load -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -stop_on_error

  Please help????

[former_member189725 · Accepted solution]

Can you check if the table RSDKYF exists in the database ?

Regards

Ratnajit

[Former Member · Accepted solution]

   Hi,

  Below is output, when check for table existence

SQL> select table_name from dba_all_tables where table_name='RSDKYF'

  2  ;

no rows selected

There thousands of views as error in SAPVIEW.TSK, not only one view

[nicholas_chang · Accepted solution]

Besides, are you using the latest TP and R3trans and kernel?

ALso, ensure the file system where you placed the Export Dump is accessible, especially if it is a NFS.

[Former Member · Accepted solution]

  Dear All,

Issue Resolved. We have updated:

1. R3trans, R3load, Tp up to latest patch level.

  2. Apply Latest opatch & mopatch

3. Then, delete all temporary logs/files from /tmp folder. Restart from scratch.

   Thanks a lot Ratnajit & nicholas