We are retrieving the records from a Oracle database(8.0.5)using ODBC intelligent adapter.
We are using oracle ODBC driver for Oracle(Version:8.01.07.00)
We are getting Invalid row id error while fetching the records.
webMethods version is 4.5
Here is the log
date DAT_MAJ = “03/02/2004 16:06:02.859”;
unicode_string COD_TABLE = “ORDRE”;
unicode_string TYP_ORDRE1 = “CDEC”;
unicode_string ETAT_DISP = “AUCU”;
};
16:06:02 GMT.937 [Debug] 0 LogysManageSalesOrder println exec SQL SELECT
t1.COD_TABLE,t1.NUM_CLE,t1.NUM_ORDRE,t1.ETAT,t1.ETAT_DISP,t1.EMP,t1.DAT_MAJ,t2.NUM_ORD
RE,t2.STYP_MVT_ORDRE,t2.TYP_ORDRE,t2.NUM_ORDRE,t2.RELIQUAT,t2.COD_FOURN,t2.NUM_ORDRE_RGP,
t2.NUM_ORDRE_PERE,t2.INC_ORDRE_PERE,t2.NUM_ORDRE_PREP,t2.EMP,t2.COD_PAYS,t2.COD_LANG,t2.N
UM_ORDRE_RGP,t2.EMP,t2.DAT_PREP_PREV_MIN,t2.DAT_PREP_PREV_MAX,t2.DAT_EXP_PREV,t2.DAT_LIV_
PREV_MIN,t2.DAT_LIV_PREV_MAX,t2.DAT_MAJ,t2.ETAT_ORDRE,t2.ETAT_ORDRE,t2.ETAT_STAT,t2.ETAT_
HIST FROM EFUL.TRACE_ORDRE t1, EFUL.ORDRE t2 WHERE (t1.NUM_ORDRE = t2.NUM_ORDRE AND t1.ET
AT = t2.ETAT_ORDRE) AND ( (( t1.DAT_MAJ > ? ) AND ( t1.COD_TABLE = ? ) AND ( t1.ETAT_
DISP = ? ) AND ( t2.TYP_ORDRE = ? )))
16:06:46 GMT.437 [Debug] T-2 received Adapter::lookup #vclient125-250
16:09:46 GMT.437 [Debug] T-2 received Adapter::lookup #vclient125-250
16:11:19 GMT.328 [Debug] 0 LogysManageSalesOrder println exec SQL ROLLBACK
16:11:19 GMT.375 [Debug] 0 LogysManageSalesOrder error (059) Could not process request document of type “Sales::Trigger::Trigger”
(108) Could not invoke script “LogysManageSalesOrder”
(108) Could not invoke script “SelectHeaderRecords”
(353) Could not execute SQL statement "SELECT t1.COD_TABLE,t1.NUM_CLE,t1.NUM_ORDRE,t
1.ETAT,t1.ETAT_DISP,t1.EMP,t1.DAT_MAJ,t2.NUM_ORDRE,t2.STYP_MVT_ORDRE,t2.TYP_ORDRE,t2.NUM_O
RDRE,t2.RELIQUAT,t2.COD_FOURN,t2.NUM_ORDRE_RGP,t2.NUM_ORDRE_PERE,t2.INC_ORDRE_PERE,t2.NUM_
ORDRE_PREP,t2.EMP,t2.COD_PAYS,t2.COD_LANG,t2.NUM_ORDRE_RGP,t2.EMP,t2.DAT_PREP_PREV_MIN,t2.
DAT_PREP_PREV_MAX,t2.DAT_EXP_PREV,t2.DAT_LIV_PREV_MIN,t2.DAT_LIV_PREV_MAX,t2.DAT_MAJ,t2.ET
AT_ORDRE,t2.ETAT_ORDRE,t2.ETAT_STAT,t2.ETAT_HIST FROM EFUL.TRACE_ORDRE t1, EFUL.ORDRE t2
WHERE (t1.NUM_ORDRE = t2.NUM_ORDRE AND t1.ETAT = t2.ETAT_ORDRE) AND ( (( t1.DAT_MAJ > ?
) AND ( t1.COD_TABLE = ? ) AND ( t1.ETAT_DISP = ? ) AND ( t2.TYP_ORDRE = ? ))) ":
(1410) Error: (S1000) [Oracle][ODBC][Ora]ORA-01410: invalid ROWID
COM.activesw.adapter.database.DBException: (1410) Error: (S1000) [Oracle][ODBC][Ora]ORA-01410: invalid ROWID