SAP IDES BW Installation - Infamous ABAP Import error part II

[Former Member]

After the problems i ecountered in the first part, I have started all new installation of SAP IDES NW04s

and again i have errors in ABAP Import phase.

Import_monitor.log lives me this:

..................................................................................

INFO: 2009-01-21 12:31:18

Import Monitor is started.

CONFIG: 2009-01-21 12:31:18

Application options:

dbCodepage=4103

dbType=ADA

extFiles=no

importDirs=E:\51032416_1\EXP1;E:\51032416_2\EXP2;E:\51032416_2\EXP3

installDir=C:\Program Files\sapinst_instdir\NW04S\SYSTEM\ADA\CENTRAL\AS

jobNum=3

loadArgs= -nolog -c 0

monitorTimeout=30

orderBy=

r3loadExe=E:\usr\sap\IAM\SYS\exe\uc\NTI386\R3load.exe

sapinst=

trace=all

tskFiles=yes

CONFIG: 2009-01-21 12:31:18

List of packages with table structure: 'SAP0000'.

CONFIG: 2009-01-21 12:31:18

List of packages with views: 'SAPVIEW'.

TRACE: 2009-01-21 12:31:18 com.sap.inst.migmon.imp.ImportStandardTask preCreate

Parse of 'C:\Program Files\sapinst_instdir\NW04S\SYSTEM\ADA\CENTRAL\AS\DDLADA.TPL' template file is started.

INFO: 2009-01-21 12:31:18 com.sap.inst.migmon.imp.ImportStandardTask preCreate

Parse of 'C:\Program Files\sapinst_instdir\NW04S\SYSTEM\ADA\CENTRAL\AS\DDLADA.TPL' template file is successfully completed.

Primary key creation: before load.

Index creation: after load.

INFO: 2009-01-21 12:31:18

Data codepage 4103 is determined using TOC file 'E:\51032416_1\EXP1\DATA\SAPAPPL0.TOC' for package 'SAPAPPL0'.

TRACE: 2009-01-21 12:31:18 com.sap.inst.migmon.LoadTask run

Loading of 'SAPSSEXC' import package is started.

TRACE: 2009-01-21 12:31:18 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPSSEXC' import package into database:

E:\usr\sap\IAM\SYS\exe\uc\NTI386\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -l SAPSSEXC.log -nolog -c 0

ERROR: 2009-01-21 12:31:21 com.sap.inst.migmon.LoadTask run

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

Process 'E:\usr\sap\IAM\SYS\exe\uc\NTI386\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -l SAPSSEXC.log -nolog -c 0' 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

WARNING: 2009-01-21 12:31:48

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

WARNING: 2009-01-21 12:31:48

1 error(s) during processing of packages.

INFO: 2009-01-21 12:31:48

Import Monitor is stopped.

........................................................................................

So i imagine the error this time is in SAPSSEXC.TSK ...so, i look to the SAPSSEXC.log

In SAPSSEXC.log the error is this:

-

---

E:\usr\sap\IAM\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20090121123118

E:\usr\sap\IAM\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP

E:\usr\sap\IAM\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jul 17 2007 01:28:45

E:\usr\sap\IAM\SYS\exe\uc\NTI386\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -l SAPSSEXC.log -nolog -c 0

(DB) INFO: connected to DB

(DB) INFO: The MaxDB logwriter is switched off#20090121123118

(DB) ERROR: DDL statement failed

(DROP INDEX "D010TAB~1" ON "D010TAB")

DbSlExecute: rc = 103

(SQL error -4011)

error message returned by DbSl:

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

ERROR : Execute for create index /BI0/D0COPA_C01401 on /BI0/D0COPA_C014 failed (dbrc=102).

(SQL error -955)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BI0/D0COPA_C01401" ON "/BI0/D0COPA_C014" ( "SID_0CUSTOMER" , "SID_0DISTR_CHAN" , "SID_0SALESORG" )

(DB) INFO: disconnected from DB

E:\usr\sap\IAM\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

E:\usr\sap\IAM\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20090121123121

-

---

So, has anyone an idea of how how can i continue here? How can i resolve these 2 errors

(SQL error -4011) and (SQL error -955)

Thanx

[lbreddemann · Accepted solution]

>

> (DB) ERROR: DDL statement failed

> (DROP INDEX "D010TAB~1" ON "D010TAB")

> DbSlExecute: rc = 103

> (SQL error -4011)

> error message returned by DbSl:

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

> ERROR : Execute for create index /BI0/D0COPA_C01401 on /BI0/D0COPA_C014 failed (dbrc=102).

> (SQL error -955)

> error message returned by DbSl:

> SQL-Statement: CREATE INDEX "/BI0/D0COPA_C01401" ON "/BI0/D0COPA_C014" ( "SID_0CUSTOMER" , "SID_0DISTR_CHAN" , "SID_0SALESORG" )

> (DB) INFO: disconnected from DB

> So, has anyone an idea of how how can i continue here? How can i resolve these 2 errors

> (SQL error -4011) and (SQL error -955)

Sure, just by using the MaxDB documentation [http://maxdb.sap.com/documentation] I found out the meaning of these error code:

-4011: Unknown index name

-955: Duplicate name

Therefore, the DROP INDEX failed, because there is no index with the name "D010TAB~1" and the CREATE INDEX failed, because there is already an index with the name "/BI0/D0COPA_C01401".

Maybe the import was incorrectly restarted?

You may want to drop index "/BI0/D0COPA_C01401" and rerun the import.

regards,

Lars

[Former Member · Accepted solution]

Thanx for your suggestions Lars. I'm a functional BI Consultant, i'm not on the technical side

So please, explain me as to a dummy, how could i drop the index your're suggesting? What exactly should i do?

As of incorrect estarting of ABAP IMPORTphase, well i didn't have any errors. I had some errors but after manually starting MaxDB and after merging SAPAPPL1.TSK AND SAPAPL1.TSKbck files everything went fine unitil these two errors.

Thanx and cheers!

[lbreddemann · Accepted solution]

> Thanx for your suggestions Lars. I'm a functional BI Consultant, i'm not on the technical side

In that case - don't do technical stuff...

> So please, explain me as to a dummy, how could i drop the index your're suggesting? What exactly should i do?

To drop the index, use a SQL tool like sqlcli or database studio and logon as the sap<sid> user.

Then run "DROP INDEX "/BI0/D0COPA_C01401" ON "/BI0/D0COPA_C014")

regards,

Lars

[Former Member · Accepted solution]

I wouldn't have to do it myself if it wern't my personal PC i'm trying to install IDES on.

I corrected one "err" status in SAPSSEXC.TSK file and the first error went away. Now i'll be looking for the tool you gave me and try to do what you've said.

Thanx.

[Former Member · Accepted solution]

Thank you a lot Lars, finally i could connect to my DB. I don't know why but through the tools you mentioned i couldn't log in. Then i downloaded SQL Studio and finally were able to connect and as per your advice i deleted and then created the index with duplicated names. It seems that everything went fine, but at the end of the ABAP Import phase i got message about some invalid objects. I openned the log invalid_objects.txt and it sais.

-

---

package object type action status

-

---

SAPAPPL1 ?N pkey create

SAPDFACT ?N pkey create

-

---

What does it mean, did i lose some objects along the way?

Thanx