> Hi,
> i do trace and this is from trace log for failed statement
> this two fields are boolean "UMOWA_ZLECFAKT_AUTOMAT","UMOWA_ZLECFAKT_KUMUL"
> INSERT INTO "AUDIT_UMOWA"
> ("AUDIT_DT","AUDIT_OPERACJA","AUDIT_USER","UMOWA_ID","DYR_ID","UMOWA_ID_SEQ","INSP_ID","PRAC_ID","KONT_ID","TYP_UMOWY_ID","RODZ_UMOWY_ID","STATUS_UMOWY_ID","UMOWA_DATA_ZAWARCIA","UMOWA_DATA_WYPOWIEDZENIA","UMOWA_DATA_OD","UMOWA_DATA_DO","PRZYCZ_ID","UMOWA_DZIALANIA","UMOWA_ID_STARA","UMOWA_POSTANOWIENIA","UMOWA_TYTUL_IMPREZY","UMOWA_ZLECFAKT_AUTOMAT","UMOWA_ZLECFAKT_KUMUL","UMOWA_ZLECFAKT_PLATNA_ID","UMOWA_ZLECFAKT_OKRES_ID","TERMIN_PLATNOSCI","KONTO_PLATNIKA")
> VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
> 0 ms
> 2013-10-30T09:46:08.1990 (1724:01B63730) ERROR AT JStatement::execute
> C:\FIREBIRDDB\TESTOWA.TEST (ATT_8, SYSDBA:NONE, NONE, TCPv4:192.168.16.1)
> P:\RidoToFB\Win32\Debug\RIDO_To_FB.exe:9200
> 335544569 : Dynamic SQL Error
> 335544436 : SQL error code = -303
> 335544334 : conversion error from string "0"
> 2013-10-30T09:46:08.2190 (1724:01B649F0) ERROR AT JResultSet::freeEngineData
> C:\FIREBIRDDB\TESTOWA.TEST (ATT_10, SYSDBA:NONE, NONE, TCPv4:192.168.16.1)
> P:\RidoToFB\Win32\Debug\RIDO_To_FB.exe:9200
> 335544569 : Dynamic SQL Error
> 335544436 : SQL error code = -501
> 335544577 : Attempt to reclose a closed cursor
> 2013-10-30T09:46:08.2190 (1724:01B649F0) ERROR AT JResultSet::freeEngineData
> C:\FIREBIRDDB\TESTOWA.TEST (ATT_10, SYSDBA:NONE, NONE, TCPv4:192.168.16.1)
> P:\RidoToFB\Win32\Debug\RIDO_To_FB.exe:9200
> 335544569 : Dynamic SQL Error
> 335544436 : SQL error code = -501
> 335544577 : Attempt to reclose a closed cursor
> 2013-10-30T09:46:08.2290 (1724:01B649F0) TRACE_FINI
> SESSION_1 Firebird Audit
> 2013-10-30T09:46:10.6320 (1724:01B63730) ERROR AT JResultSet::freeEngineData
> C:\FIREBIRDDB\TESTOWA.TEST (ATT_8, SYSDBA:NONE, NONE, TCPv4:192.168.16.1)
> P:\RidoToFB\Win32\Debug\RIDO_To_FB.exe:9200
> 335544569 : Dynamic SQL Error
> 335544436 : SQL error code = -501
> 335544577 : Attempt to reclose a closed cursor
> 2013-10-30T09:46:10.6320 (1724:01B63730) TRACE_FINI
> SESSION_1 Firebird Audit
> 2013-10-30T09:46:10.6320 (1724:01B681F8) TRACE_FINI
> SESSION_1 Firebird Audit
> now i am not sure if this is ODBC problem or FB?

I'm not sure either, because I don't have the ODBC driver in use, but
with the Trace API you should also get the parameter values when
executing a prepared statement, which should give you a clue on what
parameter is failing.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.