Import issue while DB Migration.

[Kali Prasad pani]

Hello  All,

I am in middle of a DB migration (Oracle –DB2) , OS-AIX . Trying to import JAVA stack to the target DB2 system  after dual stack splitting of a BW 7.0 system .

 .Can some body please give me some hints to resolve the below issue.

 

==================================================================================

Resuming previous execution
Trying to delete from table BC_SLD_ASSINST
BC_SLD_ASSINST deleted
Importing data into table BC_SLD_ASSINST
Rows to insert: 229380
Executing batch. Rows inserted : 5000, lob size : 5000
Importing table BC_SLD_ASSINST : 2% complete (5000 rows)
Executing batch. Rows inserted : 5000, lob size : 5000
DB Error during import of BC_SLD_ASSINST
Database access error: [jcc][t4][102][10040][3.65.77] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null (SQLState: null, ErrorCode: -4229)
Database access error: Error for batch element #1: [jcc][t4][2030][11211][3.65.77] A communication error occurred during operations on the connection's underlying socket, socket input stream,
or socket output stream.  Error location: Reply.fill() - insufficient data (-1).  Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001 (SQLState: 08001, ErrorCode: -4499)
Database access error: [jcc][103][10843][3.65.77] Non-recoverable chain-breaking exception occurred during batch processing.  The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null (SQLState: null, ErrorCode: -4225)
DB Error:
Database access error: [jcc][t4][10335][10366][3.65.77] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003 (SQLState: 08003, ErrorCode: -4470)

 

==========================================================

 

Kali Prasad

[Kavitha Rajan]

Please check if this helps.

 

http://www-01.ibm.com/support/docview.wss?uid=swg21623212

 

Thanks,
Kavitha Rajan.

--
 
---
You received this message because you are subscribed to the Google Groups "MYSAPBASIS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mysapbasis+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Kaliprasad]

Hello, 

I guess the issue is with EXPORT dump. After the dual split the JAVA stack was down while I took the EXPORT. Hence it was not imported the data for a single table, though it was exported perfectly as per the log.

so I am trying to take a fresh EXPORT while the source is up. And will try to do a fresh IMPORT .

Hope the issue may resolve. Thanks for your respond.Sure will check this link also.

Thanks

Kali Prasad

Sent from my iPad

[Kali Prasad Pani]

No luck, Its fail again with same issue, this time i suspect on the table containt.

[Rabindra Das]

Hik KaliPrasad

This is regarding OS migration

I am not sure how many of this group has performed OS migration.

you might have to deal directly with SAP support

Thanks
Rabi

Thanks 

Rabindra Das

[Kavitha Rajan]

Hi All,

 

I performed system copy of solman 7.01 dual stack on a new windows 2008 server (Old windows 2003). After CI installation, I am seeing 2 CI and 2 SCS in SAP MMC. Please let me know how to delete the duplicate entries. Attached is the screenshot. If I delete from MMC using the delete button, it is appearing back after I close and reopen MMC. Please help.

 

Tahnsk,

Kavitha Rajan.