I exported a .CSV file of my tags from the Designer because I needed to create a second set of tags with slightly different names. So I did a search and replace for the names/folders/expressions I needed to change.
When trying to import the updated list of tags back into the Designer I received an error, at the bottom of this message, and only my original folders were created with NO tags.
I then tried to import the tag CSV file I had exported and am still receiving the error and NO tags are importing. I tried restoring a copy of the system that was working and had all the tags and now all of my tags are missing from the restored copy as well.
This was all in my DEV environment but it also removed all the tags from my demo system, I use the same DB for DEV as the demo system.
SHORT Error:
GatewayException: Gateway Error 60001: Error executing asynchronous task.
caused by ClassCastException: Cannot coerce value ‘Mon Aug 01 00:00:00 PDT 2011’ into type: class java.util.Date. Invalid date format.
Ignition v7.2.8 (b178)
Java: Sun Microsystems Inc. 1.6.0_26
FULL Error:
com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Gateway Error 60001: Error executing asynchronous task.
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:280)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:250)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:214)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.invoke(GatewayInterface.java:659)
at com.inductiveautomation.ignition.client.sqltags.impl.db.DatasourceTagManager.addTags(DatasourceTagManager.java:343)
at com.inductiveautomation.ignition.client.sqltags.impl.ClientTagManagerImpl.addTags(ClientTagManagerImpl.java:250)
at com.inductiveautomation.ignition.designer.sqltags.action.ImportTagAction$CSVTagImporter.run(ImportTagAction.java:244)
at com.inductiveautomation.ignition.client.util.gui.progress.ClientProgressManager$ClientRunningTask.run(ClientProgressManager.java:507)
at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:526)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassCastException: Cannot coerce value ‘Mon Aug 01 00:00:00 PDT 2011’ into type: class java.util.Date. Invalid date format.
at com.inductiveautomation.ignition.common.TypeUtilities.coerce(TypeUtilities.java:832)
at com.inductiveautomation.ignition.common.TypeUtilities.toDate(TypeUtilities.java:1074)
at com.inductiveautomation.ignition.gateway.sqltags.DBTagStore.addTagsDeep(DBTagStore.java:1185)
at com.inductiveautomation.ignition.gateway.sqltags.DBTagStore.addTags(DBTagStore.java:1127)
at com.inductiveautomation.ignition.gateway.sqltags.AbstractStoreBasedTagProvider$AddTagsTask.run(AbstractStoreBasedTagProvider.java:399)
at com.inductiveautomation.ignition.gateway.sqltags.execution.AbstractTagDriver.runInConfigLock(AbstractTagDriver.java:426)
at com.inductiveautomation.ignition.gateway.sqltags.AbstractStoreBasedTagProvider.addTags(AbstractStoreBasedTagProvider.java:186)
at com.inductiveautomation.ignition.gateway.sqltags.SQLTagsManagerImpl.addTags(SQLTagsManagerImpl.java:440)
at com.inductiveautomation.ignition.gateway.project.ProjectSettingsCache$ProjectDefaultTagManagerFacade.addTags(ProjectSettingsCache.java:440)
at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.SQLTags.addTags(SQLTags.java:241)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.inductiveautomation.ignition.gateway.clientcomm.progress.MethodInvokeRunnable.run(MethodInvokeRunnable.java:27)
at com.inductiveautomation.ignition.gateway.clientcomm.progress.GatewayProgressManagerImpl$GatewayProgressTask.run(GatewayProgressManagerImpl.java:215)
… 9 more
Ignition v7.2.8 (b178)
Java: Sun Microsystems Inc. 1.6.0_26
After receiving the above error I deleted the Date Values in the CSV to try and eliminate this issue and upon attempting to import I now receive this error:
GatewayException: Gateway Error 60001: Error executing asynchronous task.
caused by NullPointerException
I could not find any issues with this except from previous versions of Ignition. I am using Ignition 7.2.8 (b178).
Thanks in advance.