Import ABAP err for SAP Solman 7.1

[Former Member]

Hi,

Am getting the errors in Import ABAP phase while installing sol.mngr 7.1.

import monitor log:

ERROR: 2012-09-05 15:02:12 com.sap.inst.migmon.LoadTask run

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

Process '/usr/sap/SOL/SYS/exe/run/R3load -i SAPSSEXC.cmd -dbcodepage 4103 -l SAPSSEXC.log -stop_on_error' exited with return code 2.

For mode details see 'SAPSSEXC.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

ERROR: 2012-09-05 15:02:18 com.sap.inst.migmon.LoadTask run

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

Process '/usr/sap/SOL/SYS/exe/run/R3load -i SAPAPPL1.cmd -dbcodepage 4103 -l SAPAPPL1.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL1.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

ERROR: 2012-09-05 15:02:33 com.sap.inst.migmon.LoadTask run

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

Process '/usr/sap/SOL/SYS/exe/run/R3load -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL0.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

ERROR: 2012-09-05 15:02:51 com.sap.inst.migmon.LoadTask run

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

Process '/usr/sap/SOL/SYS/exe/run/R3load -i SAPAPPL2.cmd -dbcodepage 4103 -l SAPAPPL2.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL2.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

WARNING: 2012-09-05 15:03:12

Cannot start import of packages with views because not all import packages with tables are loaded successfully.

WARNING: 2012-09-05 15:03:12

4 error(s) during processing of packages.

INFO: 2012-09-05 15:03:12

Import Monitor is stopped.

_________________________

Tried to skip couple of tables/indexes by changing 'err' to 'ok' in the task files. But they keep on coming. If its fot 5-6 tables, we can ignore/skip but this is coming for most of them.

FYI -  i have un-installed exiting sol.mngr 7.0 with EHP1 and started to install the new version on oracle 11.2.0.3 on SUSE 11.

'work arounds' are welcome. but am definetly looking for a solution for this problem.

Regards,

Srihari

[Former Member]

Hi All,

Please let me know did you solve this issue?

I'am doing migration of our SM 7.1 from :

Windows 2003 R2 - > Windows 2012

Oracle 11.2.0.3 - > Oracle 11.2.0.4  (this version is supported for Win 2012)

I have stopped on Import ABAP step on Target system:

1. ORA-02220: "invalid MINEXTENTS storage option" -  I have solved this error with note: 1904315

but,

2. ORA-00955: name is already used by an existing object - this error is for every next table i TSK file.

Any ideas???

Thanks

[Former Member]

Are you using SWPM tool.

Check note [541538 - FAQ: Reorganization|https://service.sap.com/sap/support/notes/541538]

Thanks

Asim

[mario_bisonti2]

Hallo.

I use SWPM 1.0 to migrate Solution Manager 7.1 , from :

windows 2003 oracle 11.2.0.3

to

windows 2008 R2 oracle 11.2.0.4

I executed SMIGR_CREATE_DDL on the source system, I executed the export from SWPM->Solman 7.1 SR1 - >...

After I import in the target but I obtain for may indexes I have the error:

ORA-00955: name is already used by an existing object

I think that it could be a problem on the script generated by SMIGR_CREATE_DDL

It seems a problem related to some IOTs table script

Could you help me?

Thanks a lot

Mario

[JPReyes]

Have you read the SAPAPPL*.log's ?, Please post errors on the logs here.

Also,  updating the kernel specially R3load is a good idea.

Regards, Juan

[Former Member]

Hi Juan,

please find the SAPAPPL0 log:

/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20120905151905

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

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

Compiled Dec 1 2011 20:22:48

/usr/sap/SOL/SYS/exe/run/R3load -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_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_1/DATA_UNITS/EXP2/DB/SQLFiles.LST

(SQL) INFO: /sapdumps/51042607_SR1Export_1/DATA_UNITS/EXP2/DB/SQLFiles.LST not found

(SQL) INFO: Searching for SQL file APPL0.SQL

(SQL) INFO: APPL0.SQL not found

(SQL) INFO: Searching for SQL file /sapdumps/51042607_SR1Export_1/DATA_UNITS/EXP2/DB/ORA/APPL0.SQL

(SQL) INFO: /sapdumps/51042607_SR1Export_1/DATA_UNITS/EXP2/DB/ORA/APPL0.SQL not found

(DB) INFO: /1CN/C3DSAP00006~0 dropped #20120905151925

(DB) INFO: /1CN/C3DSAP00006~0 created #20120905151925

(DB) ERROR: DDL statement failed

(CREATE INDEX "/1CN/C3DSAP00006SC" ON "/1CN/C3DSAP00006" ( "CLIENT" , "BEF_APPL" , "ITEM_CATEGORY" , "KSCHL" , "OBJECT_ID" , "TIMESTAMP_TO" , "CREATED_ON" , "KOPOS" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000016K NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 102

(SQL error 955)

error message returned by DbSl:

ORA-00955: name is already used by an existing object

(DB) INFO: disconnected from DB

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

/usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20120905151925

_____________

I find the similar 'ORA-1403 when accessing table SAPUSER' errors for SAPAPPL1, SAPAPPL2 and SAPSSEXC.

I have just updated R3trans and tp. will update R3Load and try.

Regards,

Srihari

[JPReyes]

Update R3load, and try it again.

Regards, Juan

[Former Member]

I have updated R3Load and the result is same.

Am suspicious about the ORA-00955. Has the older DB not uninstalled properly? I have used "Uninstall" option and after that i have manually deleted some existing old data. If this is the case, must I go for complete recreation of File system?

Regards,

Srihari

[JPReyes]

SQLFiles.LST not found

Did you run report SMIGR_CREATE_DDL in the source system?... Or this is a clean install?

Regards, Juan

[Former Member]

No, i have not run the report. This is just a plaininstallation .. not a migration.

Regards,

Srihari

[JPReyes]

Am suspicious about the ORA-00955. Has the older DB not uninstalled properly? I have used "Uninstall" option and after that i have manually deleted some existing old data. If this is the case, must I go for complete recreation of File system?

This shouldn't be an issue, You should run the Oracle uninstall and clean your datafiles/logs from the  oracle filesystems and that should be enough.

Regards, Juan

[Former Member]

Hi Juan,

I shall keep the uninstallation option as a last resort. But, is there anyway to come out of this phase without stopping the current installation process?

Regards,

Srihari

[former_member189725]

Drop the Oracle database as below

shutdown abort;

startup mount exclusive restrict;

drop database;

Delete the contents of the SAPINST installation directory.

Then start the SAPINST again  , it should not take much time to reach the phase you are in .

Your database software is already installed. So sapinst will not stop for installation of Oracle software.

Regards

Ratnajit

[JPReyes]

I shall keep the uninstallation option as a last resort

I did not ask you to uninstall, I was answering your previous question.

anyway to come out of this phase without stopping the current installation process?

What version of oracle are you on?, did you install the SBP's?, What kernel are you using?, I would update the whole kernel, usually Kernel DVD's have very out of date ones.

Regards, Juan

[Former Member]

Hi Ratnajit,

Before starting this installation, i faced similar error. After dropping the DB, i have started the current one and am again facing the same issue. Probably i have not done the cleanup well. Let me check and come back.

Aside Juan,

OPatch Version: 11.2.0.1.8

SQL*Plus: Release 11.2.0.3.0 Production

is this the culprit?!!

Regards,

Srihari

[JPReyes]

I cant tell for sure, but you should apply the SBP (SAP Bundle Patch) directly after the Oracle install as a norm.

Regards, Juan

[Former Member]

Hello,

What do you mean by old DB ? You said it is new installation. Further when you deleted your database did you clean up the data files ?

Anyways first please explain  the old DB thing.

Regards.

Ruchit.