Hi everyone,
We are using WinCC OA 3.11 and we are facing a strange behaviour on Windows 64bit machines: after the login the first times we try connect to the Oracle database the queries seems to fail. Debugging the code we found that the code get stuck in the function rdbOpen() (into the library rdb.ctl), in particular into the instruction dbOpenConnection().
We found out that the function returns after about 2.5 minutes and then the query is executed correctly.
In the log file we get the WARNING: Unexpected state, long running sql-statement!
After the first time the function succeed opening the connection, all the next queries work correctly.
We get this behaviour only for client running on Windows 64 bit, everything is ok on Windows 32 bit.
In the Windows 64 bit machine we installed Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64)
Any advice about what to check would be appreciated!
Thanks
Riccardo
PROBLEM OPENING DB CONNECTION FROM WINDOWS 64 BIT CLIENT
- riccardo.crociani
- Posts:34
- Joined: Tue Mar 31, 2015 12:52 pm
PROBLEM OPENING DB CONNECTION FROM WINDOWS 64 BIT CLIENT
- riccardo.crociani
- Posts:34
- Joined: Tue Mar 31, 2015 12:52 pm
Re: PROBLEM OPENING DB CONNECTION FROM WINDOWS 64 BIT CLIENT
Ok,
today we found the cause... there was a bug into our query :unsure: .
Riccardo
today we found the cause... there was a bug into our query :unsure: .
Riccardo