Hi,
One of my customer is using TOAD to connect to our DB2 Reporting Database.
When they run a SELECT query, they are getting the below error.
Because of the InnerException Message “No data exists for the row/column.” , the customer is thinking that this error is coming because of a data issue in the table.
But, when I run the same SELECT query in DB2 SPUFI, I am not getting any error.
Has anyone come across this issue before and identified the root cause. If yes, could you please share your findings.
Appreciate any help on this. Thanks.
Error Message:
DB2 Database Error: ERROR [58005] [IBM][DB2.NET] SQL0902 An unexpected exception has occurred in Process: 45924 Thread 33 AppDomain: Name:toad.exe
There are no context policies.
Function: DB2DataReader.Read()
CallStack: at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg, Exception exception, Boolean bThrow)
at IBM.Data.DB2.DB2DataReader.Read()
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
at Quest.Toad.Db.ToadDataAdapter.InternalFillBackground()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart() InnerException Message: No data exists for the row/column. Check InnerException property for more detail. SQLSTATE=58005
SQL Query:
SELECT V02.MEMBER_ID
FROM VIEW_V01 V01,
VIEW_V02 V02
WHERE V02.MEMBER_ID = V01.MEMBER_ID
AND V01.EFF_END_DATE >= ‘20180605’
AND V02.EFF_MONTH =
( SELECT MAX(EFF_MONTH)
FROM VIEW_V02
WHERE MEMBER_ID = V02.MEMBER_ID )