Skip to Content
0
Jul 30, 2023 at 09:09 AM

Info package loading issue from SQL server

47 Views

Dear experts I faced a problem while receiving data by info package to PSA from SQL server.

Our SQL server are not very stable so sometimes info package loading «freezе» with «yellow status» and gives message

«SQL error "10054" with message: "TCP Provider: An existing connection was forcibly, message type E, message class RSDS_ACCESS, message number 23»

image.png

So if delete this request manually this step in chain becomes red and after i restart info package it loads successfully and chain goes on.

But the problem is that in this case info package just freeze and I can only see the problem after long period (I see process chain working too long).

How can I manage info package loading to break the process chain to red status? (not just freeze with error)

Attachments

image.png (152.6 kB)