There is a transaction that gets called whenever xml is sent via http post. The transaction calls a query template. That transaction gets called multiple times throughout the day.
The query template takes in xml data and calls an oracle procedure. The oracle procedure inserts data into a table.
This whole procedure is successful 99% of the time. But occasionally like once or twice a day, it’ll fail. I know the failing isn’t due to the data, cause I can reprocess the same xml data and it’ll work.
I get the error message “Error processing command for template ....". I also get the message like "SQL error has occurred on query No more data to read from socket". Does anyone know what may cause a query to work 99% of the time and fail occasionally 1% of the time? I can confirm this is happening while our database is up.