Transaction Groups - writing OPC data to Oracle Database

Ignition
1

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?

2

Ignition expects DBs to have some form of auto-index column type for a primary key. Oracle apparently is choking on this. You might have to set up a sequence as the default value for that column manually.

2 Likes
3

When looking at the table that the transaction group created automatically, it seems that the index is already set as the primary key:

image
image1868×340 24.5 KB

4

Just being a primary key doesn't mean it will auto-populate. It needs a dynamic default value for that part to work.