SECS/GEM module creates PostgreSQL schema it cannot itself work with

General Discussion
1

Ignition 8.3.8
SECS/GEM module 5.3.8
PostgreSQL 17.10, freshly installed on the same Debian host purely for Ignition.
Fresh installation, not an upgrade/update.
SECS/GEM module creates tables with column names in UPPERCASE, apparently quoting them. Then immediately when querying those tables it uses column names without quoting, generating jdbc errors like



java.sql.SQLException: Could not insert/update or query SECSGEM_EquipmentInfo database table for this Equipment Connection.

at com.inductiveautomation.secsgem.EquipmentConnectionDBTablesSetup.setupDatabaseTables(EquipmentConnectionDBTablesSetup.java:103)

at com.inductiveautomation.secsgem.equipment.EquipmentConnection.initialize(EquipmentConnection.java:355)

at com.inductiveautomation.secsgem.equipment.EquipmentConnection$1.mainLoop(EquipmentConnection.java:117)

at com.inductiveautomation.secsgem.equipment.EquipmentConnection$1.run(EquipmentConnection.java:101)

at java.base/java.lang.Thread.run(Unknown Source)

Caused by: org.postgresql.util.PSQLException: ERROR: column "prefix" does not exist Position: 8

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)

Is there a place to report bugs? I have not found one.

2

You can submit a ticket here. https://support.inductiveautomation.com/hc/en-us

3

Created https://support.inductiveautomation.com/hc/en-us/requests/194908

No bug reporting there, just "requests".
Thanks Andrew

4

"Requests" include bug reports. This forum is not official support, and relies on a few IA employees eyeballs. The support site is full time IA staffed.