Skip to Content
0
Jun 14, 2016 at 01:54 PM

Client import : sql error 30046 performing INS on table BSEG, Connection to the server has been lost

825 Views

Hello,

I am doing a client import on SAP ECC EHP6, Windows 2008, and Sybase 15.7 131.

The database size is quite small : 250 GB, but i could not perfrom the client import becasue of diverse sybase issues.

Over the past years, I have perfomed similar client copy activities on other datbases, never faced that kind of issues.

Right now, the issues we are dealing with is ASE ODBC Driver disconnection when trying to import table BSEG.

While trying to import this table, 99% of the memory is used ton the PAS Application server !

Free SWAP is then significantly reduced o nthe SAP Primary application server

And the import fails :

4 ETW000 [ dev trc,00000] ERROR: -1 in function ExeNormalModify (execute) [line 25387]
4 ETW000 [ dev trc,00000] (30046) [08S01] [SAP][ASE ODBC Driver]Connection to the server has been lost. Connection died wh
4 ETW000 [ dev trc,00000] ile writing to socket. Socket returned error code 10055. Check the server to det
4 ETW000 [ dev trc,00000] ermine the status of any open transactions.
4 ETW000 [ dev trc,00000] syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART
4 ETW000 [ dev trc,00000] statement id is ==> [3 BSEG 268435456 20150324205840]
4 ETW000 [ dev trc,00000] ERROR: -1 in function GetTranState (SQLAllocStmt failed) [line 38062]
4 ETW000 [ dev trc,00000] evaluation of transaction state failed.
4 ETW000 [ dev trc,00000] Mon Jun 13 22:05:27 2016
4 ETW000 [ dbtrtab ,00000] ***LOG BY4=>sql error 30046 performing INS on table BSEG
4 ETW000 [ dbtrtab ,00000] ***LOG BY0=>[ASE Error SQL30046:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost. Connection died while writing to socket. Socket returned error code 10055. Check the server to determine the status of any open transactions.
2EETW000 sap_dext called with msgnr "1":
2EETW000 ---- db call info ----
2EETW000 function: db_xrtab
2EETW000 fcode: RT_MI_LOAD
2EETW000 tabname: BSEG
2EETW000 len (char): 1830
2EETW000 key: 400110060001833712015002 0000000000000000 50S H
2EETW000 retcode: 1
2EETW000 sql error: 30046 [ASE Error SQL30046:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost. Connection died while writing to socket. Socket returned error code 10055. Check the server to determine
2EETW125 SQL error "30046" during "" access: "[ASE Error SQL30046:08S01][SAP][ASE ODBC Driver]Connection to the server has been lost. Connection died while writing to socket. Socket returned error code 10055. Check the server to determine the status of any open transactions."



SAP has released the note 1912732 - Client Copy performance with SYBASE database which basically tells you to patch everything, and points to dozens of sap notes ...

I have patched the ODBC Driver, didnt help

I could not find anything about what seems to be a memory leak issue on R3trans.

Any advice, help would be higky appreciated.

Thanks

Attachments

insane.png (36.4 kB)
freememory.png (77.5 kB)