Connection reset by peers; Socket write error

[Former Member]

hi all,

we are facing some issue on quality server. We have connected remote SQL database. But sometimes getting error

"FATAL SQL error occurred on connection [remote server name], code 0, state='08S01' message='Connection reset by peer, socket write error"

and due to this connection get lost between MII and remote database. We need to restart application resource every time to work it again. after restarting it works properly.

I think its issue with net packet size and default packet size of remote database. may be network_packet_size is greater than default_packet_size?? Is that the reason?? If yes how to change that setting?

Please help me. Thanks in advance.

Regards,

mahesh

[hemanth2]

Dear mahesh ,

Hope you are doing good.

This error could be related to DB inconsistencies and therefore I would like to ask you to perform a DB Consistency Check as explained in the attached note 142731. Also try to delete the SQL packages from the system as per note 1109573, then attempt to recreate the error.

Thank you and have a nice day :).

_____________
Kind Regards,
Hemanth

[Former Member]

Thanks hemanth,

regards,

mahesh

[hemanth2]

no problem mahesh; let us know how it goes