We are getting this error once in a while with a FIND GE operation against a db2 table.
DF 18.2.
Code:
Clear TLgrCondutorTransp
Move TLgrCondutor.iRn_Condutor to TLgrCondutorTransp.iRn_Condutor
Find ge TLgrCondutorTransp by 3
...
Error:
Code:
Erro genérico 42601 (-104)--[IBM][CLI Driver][DB2/NT64] SQL0104N An unexpected token ")RDER BY "IRN_CONDUTOR" ASC,"IRN_CONDUTOR" was found following "ONDUTORTRANSP" > ?))". Expected tokens may include: "<space>". SQLSTATE=42601
Table = TLGRCONDUTORTRANSP (128), Source = DB2_DRV.Find
MSG_ERROR_REPORT (433) - oWebAppError (4) - at address 5837
MSG_ERROR_REPORT (433) - oErrorHandler (23) - at address 16000
MSG_ONSETCALCULATEDVALUE (6021) - oColTransportadora (1928) - at address 47107
MSG_REFRESH (454) - oColTransportadora (1928) - at address 18161
GET_FINDBYROWIDEX (1761) - oTLgrCondutor_Lista_DD (1910) - in native code
GET_FINDBYROWIDEX (1761) - oTLgrCondutor_Lista_DD (1910) - at address 4873
MSG_CLOSEPROMPTLIST (6802) - oPromptList (1924) - at address 26571
MSG_OK (152) - oPromptList (1924) - at address 26614
MSG_ONCLICK (6324) - oOkButton (1930) - at address 47140
GET_HANDLEACTION (5703) - oOkButton (1930) - at address 14700
GET_CALLACTION (6203) - oWebApp (20) - at address 20517
GET_CALLACTION (6203) - oWebServiceDispatcher (36) - at address 20212
GET_DOCALL (1284) - oCallInterface (37) - in native code
GET_DOCALL (1284) - oWebServiceDispatcher (36) - at address 10018
MSG_ONDFFUNC (5001) - oVDFInetSession (26) - at address 8588
MSG_STARTWEBAPP (5789) - oWebApp (20) - at address 15862
[start] - at address 234975
Erro número: 12289 linha: 47107.
when it happens, it keeps happening until you restart the webapp..
please note that the ORDER BY clause get's truncated in the final statement.
WHERE ( ...ONDUTORTRANSP" > ?)))RDER BY ...
Index 3 definition is pretty simple 2 keys segment.. (col + id)
IRN_CONDUTOR ASC, IRN_CONDUTORTRANSP ASC
Has anyone seen this before ?
DAW, any know issue at previous driver releases that might have been already fixed in most recent ones ?