Hello,
I am trying to use a Historical Transaction group to write OPC data from Tags into an Oracle database connection. I setup the transaction group to automatically create a table (with its own index). However, when running the transacation group, the table is being created but no data is being written to it. Instead, the data is quarantined in store and forward with the error message: "java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("IGNITION"."OPC_TAGS"."opc_tags_ndx") ORA-01400 - Database Error Messages".
When attempting to enable the "Bypass Store and Forward system" option is the Transaction group options, it would say "Errored" and would not run.
When I tried writing to an SQLite database connection, the transaction group is functioning as intended.
Any ideas why this error is happening only with the Oracle database?