Data sink critical failure caused by DB translator syntax

Paul,

EDIT

I found the issue and it is shockingly simple considering how much time I spent troubleshooting this… This post lead me to editing the translators in search of double quotes, but I realized that there was an option to “Enable” on the context menu. As it turns out, none of my translators were enabled for some reason. I have enabled all of them and it seems like my problem is resolved.

Viewing the logs, I’m not sure if I could have identified this issue based on the error text, and there is also no indication on the translator settings screen of the enable/disable status as there is for most other configurable items, but definitely something that should have been realized sooner. I think the clearest indicator was no options being shown when trying to select a new default translator and having no options listed in the dropdown menu (shown in original body of this reply). Hopefully this can help someone else who is banging their head against the wall with this issue in the future!

END EDIT


I filtered my logs by searching for gateway.Database and have the results below.

The warnings/error/info that all occur at 19:39:50 are all occurring as a group a couple of times a day. I think the errors at 14:35:36 occur when I disable and reenable my database connection and is followed by the TagHistoryDataSink error.

One thing that I failed to mention in my original post is that when I go to database settings and edit the MSSQL driver, there are no options in the dropdown for Default Translator as shown below.


The full contents of Unable to create default db translator resource. is…

WARN
Database

05Feb2026 19:39:50
Unable to create default db translator resource.
com.inductiveautomation.ignition.common.resourcecollection.PushConflictException: CREATE illegal, 'ResourceId{resourcePath=ignition/database-translator/POSTGRES, collectionName=core}' already exists.

at com.inductiveautomation.ignition.gateway.resourcecollection.ResourceCollectionManagerImpl$AtomicPushValidationHandler.throwIfInvalid(ResourceCollectionManagerImpl.java:739)

at com.inductiveautomation.ignition.gateway.resourcecollection.ResourceCollectionManagerImpl.push(ResourceCollectionManagerImpl.java:1149)

at com.inductiveautomation.ignition.gateway.config.ConfigurationManagerImpl.push(ConfigurationManagerImpl.java:323)

at com.inductiveautomation.ignition.gateway.resourcecollection.ResourceCollectionManager.push(ResourceCollectionManager.java:319)

at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$TranslatorHandler.createDefaultTranslator(DatasourceManagerImpl.java:1105)

at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$TranslatorHandler.lambda$getOrCreate$4(DatasourceManagerImpl.java:1088)

at java.base/java.util.Optional.orElseGet(Unknown Source)

at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$TranslatorHandler.getOrCreate(DatasourceManagerImpl.java:1088)

at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl.seedTranslatorsAndDrivers(DatasourceManagerImpl.java:702)

at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl.onStartup(DatasourceManagerImpl.java:461)

at com.inductiveautomation.ignition.common.lifecycle.AbstractLifecycle.startup(AbstractLifecycle.java:19)

at com.inductiveautomation.ignition.gateway.IgnitionGateway.startupInternal(IgnitionGateway.java:1320)

at com.inductiveautomation.ignition.gateway.redundancy.RedundancyManagerImpl.startup(RedundancyManagerImpl.java:352)

at com.inductiveautomation.ignition.gateway.IgnitionGateway.initRedundancy(IgnitionGateway.java:814)

at com.inductiveautomation.ignition.gateway.IgnitionGateway.lambda$initInternal$1(IgnitionGateway.java:736)

at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:550)

at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.base/java.util.concurrent.FutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

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

and the contents of Error seeding Oracle JDBC driver. is…

ERROR
Database

05Feb2026 19:39:50
Error seeding Oracle JDBC Driver.
com.inductiveautomation.ignition.common.resourcecollection.PushConflictException: CREATE illegal, 'ResourceId{resourcePath=ignition/database-driver/Oracle Database, collectionName=core}' already exists.

at com.inductiveautomation.ignition.gateway.resourcecollection.ResourceCollectionManagerImpl$AtomicPushValidationHandler.throwIfInvalid(ResourceCollectionManagerImpl.java:739)

at com.inductiveautomation.ignition.gateway.resourcecollection.ResourceCollectionManagerImpl.push(ResourceCollectionManagerImpl.java:1149)

at com.inductiveautomation.ignition.gateway.config.ConfigurationManagerImpl.push(ConfigurationManagerImpl.java:323)

at com.inductiveautomation.ignition.gateway.resourcecollection.ResourceCollectionManager.push(ResourceCollectionManager.java:319)

at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl.ensureDriverExists(DatasourceManagerImpl.java:755)

at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl.seedTranslatorsAndDrivers(DatasourceManagerImpl.java:719)

at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl.onStartup(DatasourceManagerImpl.java:461)

at com.inductiveautomation.ignition.common.lifecycle.AbstractLifecycle.startup(AbstractLifecycle.java:19)

at com.inductiveautomation.ignition.gateway.IgnitionGateway.startupInternal(IgnitionGateway.java:1320)

at com.inductiveautomation.ignition.gateway.redundancy.RedundancyManagerImpl.startup(RedundancyManagerImpl.java:352)

at com.inductiveautomation.ignition.gateway.IgnitionGateway.initRedundancy(IgnitionGateway.java:814)

at com.inductiveautomation.ignition.gateway.IgnitionGateway.lambda$initInternal$1(IgnitionGateway.java:736)

at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:550)

at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.base/java.util.concurrent.FutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

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