LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sassy1

Hello,

I have a DB Query node that hangs for days when I run it (it never completes). It isn't the amount of data because I have limited the sql to 'rownum = 1' and it still will not complete. The sql query runs clean in ToAD both with and without the 'rownum = 1' limitation.

I've asked the person who maintains Lavastorm and the server about this being a space issue, but he said the same thing was happening to him and directed me to ask this forum.

Please let me know how this issue can be resolved. This is a high visibility graph that is now in limbo.

Thanks!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: michaelslowey

Could it be that the SQL session is building an index?

Regards
Mick

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rabbott

There's an Oracle client bug that causes DBQuery and DBExecute to hang on Linux x86_64 machines. What version of the Oracle client software are you running on your LAE server?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sassy1

Thank you for the reply. Apparently Bob had informed one of our administrators of this bug, but the patch had not been applied.

The DBAs are going to apply the patch and I will let you know if this resolves the problem.

Thank you again for your help with this!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sassy1

DBA has applied the Oracle patch and the DBQuery node is now working.

Thank you again for helping us resolve this!