C
Chandra Sekhar
Guest
Hi, Is there any information/error in database.lg file when 7495 error occurred? Can you send us the database.lg file? How did you start your database? Do you have a .pf file? Is there any data size (number of rows in 4 table) difference between working and not working day? Other thing to look at is ODBC trace file. This trace file may give some information. Thanks and Regards, Chandu From: ke@iap.de [mailto:bounce-keiapde@community.progress.com] Sent: 27 November 2014 PM 06:54 To: TU.OE.RDBMS@community.progress.com Subject: [Technical Users - OE RDBMS] Getting data via ODBC stops with Errors Getting data via ODBC stops with Errors Thread created by ke@iap.de 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 Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Klaus Stop receiving emails on this subject. Flag this post as spam/abuse.Continue reading...