I have an agent utilizing ODBC implemented on a test server and a production server.On one server, the agent frequently crashes… Running the agent from the server copy on my local machine also crashed my local pc once…
However, running it in Debug LotusScript had no issues whatsoever… the agent had been running successfully on a test server with no problems.
The agent has run successfully a few times on the production server, but is inconsistent…
I’m thinking there could be database corruption, or perhaps the memory in the agent is not being re-used properly? I don’t know, but this is very frustrating when there are inconsistent results.
I run 3 separate queries using the same qry and result object… I have many agents that do this, that have had no issues… in this one, there have been strange results, seemingly resulting in a server crash… again, the same agent running on a test server against a test Oracle database resulted in no errors ever.
I believe the result.execute command is initiating the crash somehow, not on the initial query, but on one of the following queries… sometimes it crashes during the run of the second query, and other times it crashes on the execute of the third query…