I am receiving the error below when I run the query shown below. I have disabled polling on the table component which the insert query is updating. Any help would be greatly appreciated.
Thanks
Error:
Traceback (most recent call last):
File "<event:actionPerformed>", line 4, in <module>
File "<custom-function insertDB>", line 111, in insertDB
File "<custom-function insertDB>", line 111, in insertDB
File "<custom-function insertDB>", line 111, in insertDB
File "<custom-function insertDB>", line 111, in insertDB
com.inductiveautomation.ignition.client.gateway_interface.GatewayException: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: java.sql.SQLException: ORA-01002: fetch out of sequence
caused by GatewayException: java.sql.SQLException: ORA-01002: fetch out of sequence
caused by Exception: java.sql.SQLException: ORA-01002: fetch out of sequence
Ignition v8.1.35 (b2023120517)
Java: Azul Systems, Inc. 17.0.8
Query being ran:
INSERT INTO RMEDGER_ADDER
(BASE_ALLOY,
INGOT_SUPPLIER,
INGOT_THICKNESS_COLD,
INGOT_WIDTH_COLD,
LAST_UPDATE,
LAST_UPDATE_USERNAME,
THRESHOLD,
TARGET_CURRENT,
EDGER_ADDER,
SPECIAL_CODE,
OFFSET_01,
OFFSET_02,
OFFSET_03,
OFFSET_04,
OFFSET_05,
OFFSET_06,
OFFSET_07,
OFFSET_08,
OFFSET_09,
OFFSET_10,
OFFSET_11,
OFFSET_12,
OFFSET_13,
OFFSET_14,
OFFSET_15,
OFFSET_16,
OFFSET_17,
OFFSET_18,
OFFSET_19,
OFFSET_20,
OFFSET_21,
OFFSET_22,
OFFSET_23,
OFFSET_24,
OFFSET_25,
OFFSET_26,
OFFSET_27,
OFFSET_28,
OFFSET_29,
OFFSET_30,
OFFSET_31)
VALUES
(:Alloy,
:Supplier,
:Ingot_Thickness,
:Ingot_Width,
TO_DATE(:Last_Update_Time, 'YYYY-MM-DD HH24:MI:SS'),
:Last_Update_User,
:Threshold,
:Target_Current,
:Edger_Adder,
:Special_Code,
:Pass1,
:Pass2,
:Pass3,
:Pass4,
:Pass5,
:Pass6,
:Pass7,
:Pass8,
:Pass9,
:Pass10,
:Pass11,
:Pass12,
:Pass13,
:Pass14,
:Pass15,
:Pass16,
:Pass17,
:Pass18,
:Pass19,
:Pass20,
:Pass21,
:Pass22,
:Pass23,
:Pass24,
:Pass25,
:Pass26,
:Pass27,
:Pass28,
:Pass29,
:Pass30,
:Pass31)