Java System Copy Error

[kyubong_jun]

Hi all. I am trying System Copy.

During the Database Load I became the following Error

"An error occurred while processing service SAP NetWeaver'04 Support Release1> Java System> MS SQL Server> Migration - Target System Installation."

jload.log is:

info: trying to create table IMS_SYNCINXVIEW

com.sap.inst.jload.Jload dbImport

info: table IMS_SYNCINXVIEW created

com.sap.inst.jload.Jload dbImport

warning: DB Error during import of IMS_SYNCINXVIEW

com.sap.inst.jload.Jload printSQLException

warning: Message: The SQL statement "INSERT INTO "IMS_SYNCINXVIEW" ("ACTIVITYID","RESOURCEID","DOCUMENTTYPE","FORMATVERSION") VALUES (?,?,?,?)" contains the semantics error[s]: table "IMS_SYNCINXVIEW" unknown

com.sap.inst.jload.Jload printSQLException

warning: SQLState: SAP06

com.sap.inst.jload.Jload printSQLException

warning: ErrorCode: 1001123

com.sap.inst.jload.Jload dbImport

info: trying to create table J2EE_CONFIG

com.sap.inst.jload.Jload logStackTrace

warning: java.nio.BufferUnderflowException

at java.nio.Buffer.nextGetIndex(Buffer.java:404)

at java.nio.HeapByteBuffer.getChar(HeapByteBuffer.java:234)

at com.sap.inst.jload.io.DataFileEntry.<init>(DataFileEntry.java:52)

at com.sap.inst.jload.io.DataFile.getNextEntry(DataFile.java:354)

at com.sap.inst.jload.io.DataFile.findDataEntry(DataFile.java:397)

at com.sap.inst.jload.db.DBTable.create(DBTable.java:77)

at com.sap.inst.jload.Jload.dbImport(Jload.java:278)

at com.sap.inst.jload.Jload.executeJob(Jload.java:397)

at com.sap.inst.jload.Jload.main(Jload.java:621)

com.sap.inst.jload.db.DBConnection disconnect

info: disconnected

[Former Member]

Hi,

I have also faced the same error during system copy, the tables IMS_SYNCINXVIEW, PVC_ACTVERSVIEW, PVC_OBJVERSVIEW which are related to Development Infrastructure. These are bad tables and hence it has to be removed.

I found a file called negativTableListForJload.xml in C:\Program File

sapinst_instdir\NW04S\LM\COPY\MSS\SYSTEM\CENTRAL\AS-JAVA\install\sltools\

The import could be continued after removing the line

<object name="IMS_SYNCINXVIEW" action="insert"/>

(and of course the corresponding entries for all the other views) from

the file IMPORT.XML

So the steps u have to perform are

Please cancel the Installation by pressing the cancel button and then stop the sapinst and edit these files and again continue the old installation.

1) go to C:\Program File

sapinst_instdir\NW04S\LM\COPY\MSS\SYSTEM\CENTRAL\AS-JAVA

EDIT the IMPORT.XML i.e. delete the line

<object name="IMS_SYNCINXVIEW" action="insert"/>

2) now again got to C:\Program File

sapinst_instdir\NW04S\LM\COPY\MSS\SYSTEM\CENTRAL\AS-JAVA\install\sltools\

edit the negativTableListForJload.xml file. i.e. delete the lines which has the entry for these tables.

3) Restart the installation. Donot retry.

Reward point if u feel so.

cheers

Naveen.H

[Former Member]

Hello,

I had a similar problem...

Here's something else that I had to do - Also modify the entry for the above tables in IMPORT.sta file.

Change the "ERR" to an "OK" for each of these tables.

Eg: T:PVC_ACTVERSVIEW:DATA INSERT OK