Every night data are pulled from the OE DB via ODBC. The target is a MS SQL DB 2012, the pulling tool is SSIS (SQL Server Integration Services). It is pulling 4 tables in parallel and about 20 overall. The select statemens use are simple like "select field1, field2... from PUB.table".
In same cases the process will stop and you will see one or more of these errors:
ERROR [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Unexpected Network Error. ErrNum = 10054
ERROR [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.
ERROR [HYT00] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Timeout expired.
ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Query aborted on user request (7495)
There is no time or action (like backup) related to the problem. And some days it works good and some days not. But the days where it is not working increase in number...
We assumed a kind of timeout. We changed the settings on the query timeout in the clients ODBC settings, as said in KB article 000040525. This does not help.
We double checked all settings on DB level for connections and # of servers for 4GL and SQL.
OE is 11.2.1.
On the client side, OE is a Shared Network Installation.
Any help or ideas where to look are welcome :)
Klaus
Every night data are pulled from the OE DB via ODBC. The target is a MS SQL DB 2012, the pulling tool is SSIS (SQL Server Integration Services). It is pulling 4 tables in parallel and about 20 overall. The select statemens use are simple like "select field1, field2... from PUB.table".
In same cases the process will stop and you will see one or more of these errors:
ERROR [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Unexpected Network Error. ErrNum = 10054
ERROR [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.
ERROR [HYT00] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Timeout expired.
ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Query aborted on user request (7495)
There is no time or action (like backup) related to the problem. And some days it works good and some days not. But the days where it is not working increase in number...
We assumed a kind of timeout. We changed the settings on the query timeout in the clients ODBC settings, as said in KB article 000040525. This does not help.
We double checked all settings on DB level for connections and # of servers for 4GL and SQL.
OE is 11.2.1.
On the client side, OE is a Shared Network Installation.
Any help or ideas where to look are welcome :)
Klaus
Flag this post as spam/abuse.
Hi :)
There is no error in db lg file.
DB is startet via setup in OE Management. The process is running one day and not the other day. I did not assume a setup problem on this level.
The process is every day the exact same, so numer of rows is the same.
Where can I find the ODBC trace file or where can I activate it?
We will activate the SQL Logging for the OE DB and see, if we can find something there.
Klaus
Hi :)
There is no error in db lg file.
DB is startet via setup in OE Management. The process is running one day and not the other day. I did not assume a setup problem on this level.
The process is every day the exact same, so numer of rows is the same.
Where can I find the ODBC trace file or where can I activate it?
We will activate the SQL Logging for the OE DB and see, if we can find something there.
Klaus
Flag this post as spam/abuse.