Move Data does not function Teradata 12

Teradata Studio
Enthusiast

Move Data does not function Teradata 12

When attempting to use the Move Data functionality after selecting a database and then selecting Move Data, nothing happens, the application freezes up and must be exited by ending the process in Windows

Looking at the logs, I found and error that states the following: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.00.00.21] [Error 3807] [SQLState 42S02] Object 'DBC.Hw_Event_Log' does not exist.

Based on this, looked at the database and it appears that there is a view in DBC called Hardware_Event_Log that attempts to select from the DBC.Hw_Event_Log, however, it is not in any of our databases or is not viewable to me.

I don't know if this is causing the issue, but wanted to get assistance if anyone might know.

Thanks,

Brett B.

Tags (1)
17 REPLIES
Teradata Employee

Re: Move Data does not function Teradata 12

In checking the Teradata 12 system I test with, the Hw_Event_log table is also not there, so I am not sure that is the problem. But can you attach the log file so I can look at the exception stack to see who is trying to access the object? 

Enthusiast

Re: Move Data does not function Teradata 12

Here is the .log in the .metadata directory:

!SESSION 2013-04-02 19:49:14.143 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-02 19:49:15.955

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-02 19:49:37.770 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-02 19:49:40.018

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-02 19:50:01.021 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-02 19:50:03.317

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-02 19:55:22.641 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-02 19:55:24.579

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 13:12:10.218 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 13:12:16.468

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 13:14:28.362 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 13:14:30.409

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 13:18:36.275 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 13:18:38.009

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 15:01:00.760 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 15:01:02.823

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 15:04:21.000 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 15:04:22.937

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 15:24:48.031 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 15:24:51.844

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 15:31:50.026 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 15:31:52.542

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 15:53:26.153 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 15:53:28.419

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 15:56:30.986 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 15:56:32.986

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 16:01:40.713 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_17

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 16:01:42.806

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 16:25:35.796 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.6.0_39

java.vendor=Sun Microsystems Inc.

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 16:25:39.093

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 16:39:46.224 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.6.0_39

java.vendor=Sun Microsystems Inc.

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 16:39:49.146

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 18:22:27.523 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.6.0_39

java.vendor=Sun Microsystems Inc.

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 18:22:29.585

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-03 18:46:36.015 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.6.0_39

java.vendor=Sun Microsystems Inc.

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-03 18:46:37.811

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-04 15:37:23.021 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.6.0_39

java.vendor=Sun Microsystems Inc.

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-04 15:37:28.912

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-04 17:43:55.590 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.6.0_39

java.vendor=Sun Microsystems Inc.

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-04 17:43:58.434

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!SESSION 2013-04-04 20:53:03.456 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.6.0_39

java.vendor=Sun Microsystems Inc.

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-04 20:53:05.065

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!ENTRY org.eclipse.equinox.security 1 0 2013-04-04 20:58:32.509

!MESSAGE New keyring password generated.

!SESSION 2013-04-04 21:18:46.329 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.6.0_39

java.vendor=Sun Microsystems Inc.

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-04 21:18:48.016

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!ENTRY org.eclipse.datatools.connectivity.sqm.core 4 4 2013-04-04 21:41:32.934

!MESSAGE com.teradata.jdbc.jdbc_4.util.JDBCException

!STACK 0

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.00.00.21] [Error 3807] [SQLState 42S02] Object 'DBC.Hw_Event_Log' does not exist.

 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:307)

 at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:102)

 at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:320)

 at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:201)

 at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:121)

 at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:112)

 at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:375)

 at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:317)

 at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:305)

 at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1072)

 at org.eclipse.datatools.connectivity.sqm.internal.core.connection.StatementAdapter.executeQuery(StatementAdapter.java:73)

 at com.teradata.datatools.dtp.catalog.TeradataCatalogView.loadColumns(TeradataCatalogView.java:377)

 at com.teradata.datatools.dtp.catalog.TeradataCatalogView.getColumns(TeradataCatalogView.java:190)

 at com.teradata.datatools.dtp.catalog.converters.TableConverter.marshal(TableConverter.java:143)

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63)

 at com.thoughtworks.xstream.converters.collections.AbstractCollectionConverter.writeItem(AbstractCollectionConverter.java:64)

 at com.thoughtworks.xstream.converters.collections.ArrayConverter.marshal(ArrayConverter.java:45)

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63)

 at com.teradata.datatools.dtp.catalog.converters.SchemaConverter.marshal(SchemaConverter.java:111)

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63)

 at com.thoughtworks.xstream.core.TreeMarshaller.start(TreeMarshaller.java:98)

 at com.thoughtworks.xstream.core.AbstractTreeMarshallingStrategy.marshal(AbstractTreeMarshallingStrategy.java:38)

 at com.thoughtworks.xstream.XStream.marshal(XStream.java:837)

 at com.teradata.datatools.dtp.catalog.converters.SchemaSerializer.serializeSchema(SchemaSerializer.java:176)

 at com.teradata.datatools.dtp.catalog.converters.SerializeSchemasJob.run(SerializeSchemasJob.java:91)

 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

!ENTRY org.eclipse.datatools.connectivity.sqm.core 4 4 2013-04-04 21:46:23.136

!MESSAGE com.teradata.jdbc.jdbc_4.util.JDBCException

!STACK 0

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 14.00.00.21] [Error 751] [SQLState HY000] executeQuery error: The statement has been canceled by another thread

 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93)

 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:63)

 at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:90)

 at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:320)

 at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:201)

 at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:121)

 at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:112)

 at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:375)

 at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:317)

 at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:305)

 at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1072)

 at org.eclipse.datatools.connectivity.sqm.internal.core.connection.StatementAdapter.executeQuery(StatementAdapter.java:73)

 at com.teradata.datatools.dtp.catalog.TeradataCatalogView.loadColumns(TeradataCatalogView.java:377)

 at com.teradata.datatools.dtp.catalog.TeradataCatalogView.getColumns(TeradataCatalogView.java:190)

 at com.teradata.datatools.dtp.catalog.converters.TableConverter.marshal(TableConverter.java:143)

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63)

 at com.thoughtworks.xstream.converters.collections.AbstractCollectionConverter.writeItem(AbstractCollectionConverter.java:64)

 at com.thoughtworks.xstream.converters.collections.ArrayConverter.marshal(ArrayConverter.java:45)

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63)

 at com.teradata.datatools.dtp.catalog.converters.SchemaConverter.marshal(SchemaConverter.java:111)

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78)

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63)

 at com.thoughtworks.xstream.core.TreeMarshaller.start(TreeMarshaller.java:98)

 at com.thoughtworks.xstream.core.AbstractTreeMarshallingStrategy.marshal(AbstractTreeMarshallingStrategy.java:38)

 at com.thoughtworks.xstream.XStream.marshal(XStream.java:837)

 at com.teradata.datatools.dtp.catalog.converters.SchemaSerializer.serializeSchema(SchemaSerializer.java:176)

 at com.teradata.datatools.dtp.catalog.converters.SerializeSchemasJob.run(SerializeSchemasJob.java:91)

 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

!ENTRY com.teradata.datatools.dtp.catalog 4 2 2013-04-04 21:46:23.418

!MESSAGE Problems occurred when invoking code from plug-in: "com.teradata.datatools.dtp.catalog".

!STACK 0

org.eclipse.core.runtime.AssertionFailedException: assertion failed: The application has not been initialized.

 at org.eclipse.core.runtime.Assert.isTrue(Assert.java:110)

 at org.eclipse.core.internal.runtime.InternalPlatform.assertInitialized(InternalPlatform.java:140)

 at org.eclipse.core.internal.runtime.InternalPlatform.getStateLocation(InternalPlatform.java:611)

 at org.eclipse.core.runtime.Plugin.getStateLocation(Plugin.java:313)

 at com.teradata.datatools.dtp.catalog.converters.ConverterUtils.getPluginLocation(ConverterUtils.java:53)

 at com.teradata.datatools.dtp.catalog.converters.ConverterUtils.getCacheFileName(ConverterUtils.java:68)

 at com.teradata.datatools.dtp.catalog.converters.SchemaSerializer.deleteSchemaCacheFiles(SchemaSerializer.java:276)

 at com.teradata.datatools.dtp.catalog.TeradataCatalogPlugin.deleteCacheFile(TeradataCatalogPlugin.java:358)

 at com.teradata.datatools.util.SchemaCacheEventHandler.fireSchemaCacheDeleteEvent(SchemaCacheEventHandler.java:44)

 at com.teradata.datatools.dtp.catalog.TeradataCatalogDatabase$1.done(TeradataCatalogDatabase.java:620)

 at org.eclipse.core.internal.jobs.JobListeners$3.notify(JobListeners.java:39)

 at org.eclipse.core.internal.jobs.JobListeners.doNotify(JobListeners.java:112)

 at org.eclipse.core.internal.jobs.JobListeners.done(JobListeners.java:152)

 at org.eclipse.core.internal.jobs.JobManager.endJob(JobManager.java:647)

 at org.eclipse.core.internal.jobs.WorkerPool.endJob(WorkerPool.java:105)

 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:71)

!SESSION 2013-04-05 13:15:27.728 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.6.0_39

java.vendor=Sun Microsystems Inc.

BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US

Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2013-04-05 13:15:33.447

!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

Enthusiast

Re: Move Data does not function Teradata 12

And the teradata.log

2013-04-02 19:46:02,758 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-02 19:49:20,030 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-02 19:49:43,750 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-02 19:50:07,127 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-02 19:55:28,391 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 13:12:24,828 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 13:14:33,503 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 13:18:42,009 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 13:19:15,869 Teradata Datatools [Worker-1] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 14:48:39,554 Teradata Datatools [main] ERROR com.teradata.datatools.dtp.sqltools - Unexpected database version 0.x, using latest version's parser

2013-04-03 14:56:08,784 Teradata Datatools [main] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 14:56:33,675 Teradata Datatools [Worker-20] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 15:01:07,526 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 15:01:38,980 Teradata Datatools [Worker-1] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 15:04:27,000 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 15:04:57,141 Teradata Datatools [Worker-3] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 15:24:57,688 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 15:25:50,798 Teradata Datatools [Worker-1] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 15:31:56,964 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 15:53:33,310 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 15:54:04,764 Teradata Datatools [Worker-3] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 15:56:37,502 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 16:01:47,432 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 16:02:05,573 Teradata Datatools [Worker-4] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 16:25:43,922 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 16:26:36,548 Teradata Datatools [Worker-1] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 16:39:53,396 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 17:10:06,443 Teradata Datatools [Worker-4] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 18:22:33,710 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 18:22:56,898 Teradata Datatools [Worker-1] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 18:46:42,265 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-03 19:42:13,894 Teradata Datatools [Worker-3] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-03 19:56:33,806 Teradata Datatools [main] ERROR c.teradata.datatools.dependencies.ui - DTS0170: Could not create Interdependencies Editor

com.teradata.datatools.dependencies.TeradataInterdependenciesException: User name has not been set in the Dependencies Preferences

 at com.teradata.datatools.dependencies.mdsimpl.TeradataInterdependencies.<init>(TeradataInterdependencies.java:110) ~[na:na]

 at com.teradata.datatools.dependencies.TeradataInterdependencies.getTeradataInterdependencies(TeradataInterdependencies.java:33) ~[com.teradata.datatools.dependencies_14.1.0.201302060329.jar:na]

 at com.teradata.datatools.dependencies.ui.ShowInterdependencies.showInInterdepencencyBrowser(ShowInterdependencies.java:186) [com.teradata.datatools.dependencies.ui_14.1.0.201302060329.jar:na]

 at com.teradata.datatools.dependencies.ui.ShowInterdependencies.showInInterdepencencyBrowser(ShowInterdependencies.java:150) [com.teradata.datatools.dependencies.ui_14.1.0.201302060329.jar:na]

 at com.teradata.datatools.dependencies.ui.teradataview.DependenciesViewActions.doAction(DependenciesViewActions.java:92) [com.teradata.datatools.dependencies.ui_14.1.0.201302060329.jar:na]

 at com.teradata.datatools.dtp.teradataview.view.ViewContainer.doAction(ViewContainer.java:817) [com.teradata.datatools.dtp.teradataview_14.2.0.201302060329.jar:na]

 at com.teradata.datatools.dtp.teradataview.view.TeradataView$7.run(TeradataView.java:929) [com.teradata.datatools.dtp.teradataview_14.2.0.201302060329.jar:na]

 at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) [org.eclipse.jface_3.7.0.v20110928-1505.jar:na]

 at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584) [org.eclipse.jface_3.7.0.v20110928-1505.jar:na]

 at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501) [org.eclipse.jface_3.7.0.v20110928-1505.jar:na]

 at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452) [org.eclipse.jface_3.7.0.v20110928-1505.jar:na]

 at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) [org.eclipse.swt.win32.win32.x86_3.7.2.v3740f.jar:na]

 at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053) [org.eclipse.swt.win32.win32.x86_3.7.2.v3740f.jar:na]

 at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165) [org.eclipse.swt.win32.win32.x86_3.7.2.v3740f.jar:na]

 at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754) [org.eclipse.swt.win32.win32.x86_3.7.2.v3740f.jar:na]

 at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701) [org.eclipse.ui.workbench_3.7.1.v20120104-1859.jar:na]

 at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665) [org.eclipse.ui.workbench_3.7.1.v20120104-1859.jar:na]

 at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499) [org.eclipse.ui.workbench_3.7.1.v20120104-1859.jar:na]

 at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679) [org.eclipse.ui.workbench_3.7.1.v20120104-1859.jar:na]

 at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) [org.eclipse.core.databinding.observable_1.4.0.I20110222-0800.jar:na]

 at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668) [org.eclipse.ui.workbench_3.7.1.v20120104-1859.jar:na]

 at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) [org.eclipse.ui.workbench_3.7.1.v20120104-1859.jar:na]

 at com.teradata.studio.StudioApplication.start(StudioApplication.java:33) [com.teradata.studiobase_14.2.0.201302060329.jar:na]

 at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) [org.eclipse.equinox.app_1.3.100.v20110321.jar:na]

 at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]

 at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]

 at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]

 at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) [org.eclipse.osgi_3.7.2.v20120110-1415.jar:na]

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_39]

 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_39]

 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_39]

 at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_39]

 at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622) [org.eclipse.equinox.launcher_1.2.0.v20110502.jar:na]

 at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577) [org.eclipse.equinox.launcher_1.2.0.v20110502.jar:na]

 at org.eclipse.equinox.launcher.Main.run(Main.java:1410) [org.eclipse.equinox.launcher_1.2.0.v20110502.jar:na]

2013-04-04 15:37:38,631 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-04 16:04:27,187 Teradata Datatools [Worker-5] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [New Teradata Database]- Kanji Enabled = false

2013-04-04 17:39:34,271 Teradata Datatools [Worker-10] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-04 17:39:46,553 Teradata Datatools [main] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata PreProduction]- Kanji Enabled = false

2013-04-04 17:41:13,180 Teradata Datatools [main] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata PreProduction]- Kanji Enabled = false

2013-04-04 17:41:19,555 Teradata Datatools [main] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata PreProduction]- Kanji Enabled = false

2013-04-04 17:44:03,606 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-04 19:49:05,721 Teradata Datatools [Worker-10] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Development]- Kanji Enabled = false

2013-04-04 19:50:26,098 Teradata Datatools [Worker-9] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-04 19:53:00,040 Teradata Datatools [Worker-14] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Development]- Kanji Enabled = false

2013-04-04 20:53:09,112 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-04 20:54:01,285 Teradata Datatools [Worker-1] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-04 21:18:51,751 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-04 21:35:57,829 Teradata Datatools [Worker-8] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production]- Kanji Enabled = false

2013-04-04 21:36:00,329 Teradata Datatools [Worker-8] INFO  com.teradata.datatools.dtp.catalog - DTS0021: File Not Found - F:/GCSSUsers/Brett.Bates/workspace-studio/.metadata/.plugins/com.teradata.datatools.dtp.catalog\teradataCache\Teradata ProductionSchema-67461.xml

2013-04-04 21:41:32,950 Teradata Datatools [Worker-6] ERROR com.teradata.datatools.dtp.catalog - [Teradata Database] [TeraJDBC 14.00.00.21] [Error 3807] [SQLState 42S02] Object 'DBC.Hw_Event_Log' does not exist.

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.00.00.21] [Error 3807] [SQLState 42S02] Object 'DBC.Hw_Event_Log' does not exist.

 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:307) ~[na:na]

 at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:102) ~[na:na]

 at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:320) ~[na:na]

 at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:201) ~[na:na]

 at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:121) ~[na:na]

 at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:112) ~[na:na]

 at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:375) ~[na:na]

 at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:317) ~[na:na]

 at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:305) ~[na:na]

 at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1072) ~[na:na]

 at org.eclipse.datatools.connectivity.sqm.internal.core.connection.StatementAdapter.executeQuery(StatementAdapter.java:73) ~[org.eclipse.datatools.connectivity.sqm.core_1.2.5.v201205240353.jar:na]

 at com.teradata.datatools.dtp.catalog.TeradataCatalogView.loadColumns(TeradataCatalogView.java:377) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at com.teradata.datatools.dtp.catalog.TeradataCatalogView.getColumns(TeradataCatalogView.java:190) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at com.teradata.datatools.dtp.catalog.converters.TableConverter.marshal(TableConverter.java:143) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63) [xstream.jar:na]

 at com.thoughtworks.xstream.converters.collections.AbstractCollectionConverter.writeItem(AbstractCollectionConverter.java:64) [xstream.jar:na]

 at com.thoughtworks.xstream.converters.collections.ArrayConverter.marshal(ArrayConverter.java:45) [xstream.jar:na]

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63) [xstream.jar:na]

 at com.teradata.datatools.dtp.catalog.converters.SchemaConverter.marshal(SchemaConverter.java:111) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.start(TreeMarshaller.java:98) [xstream.jar:na]

 at com.thoughtworks.xstream.core.AbstractTreeMarshallingStrategy.marshal(AbstractTreeMarshallingStrategy.java:38) [xstream.jar:na]

 at com.thoughtworks.xstream.XStream.marshal(XStream.java:837) [xstream.jar:na]

 at com.teradata.datatools.dtp.catalog.converters.SchemaSerializer.serializeSchema(SchemaSerializer.java:176) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at com.teradata.datatools.dtp.catalog.converters.SerializeSchemasJob.run(SerializeSchemasJob.java:91) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) [org.eclipse.core.jobs_3.5.101.v20120113-1953.jar:na]

2013-04-04 21:41:32,950 Teradata Datatools [Worker-6] ERROR com.teradata.datatools.dtp.catalog - Could not display exception dialog for message: {0}

2013-04-04 21:46:23,136 Teradata Datatools [Worker-6] ERROR com.teradata.datatools.dtp.catalog - [Teradata JDBC Driver] [TeraJDBC 14.00.00.21] [Error 751] [SQLState HY000] executeQuery error: The statement has been canceled by another thread

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 14.00.00.21] [Error 751] [SQLState HY000] executeQuery error: The statement has been canceled by another thread

 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93) ~[na:na]

 at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:63) ~[na:na]

 at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:90) ~[na:na]

 at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:320) ~[na:na]

 at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:201) ~[na:na]

 at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:121) ~[na:na]

 at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:112) ~[na:na]

 at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:375) ~[na:na]

 at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:317) ~[na:na]

 at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:305) ~[na:na]

 at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1072) ~[na:na]

 at org.eclipse.datatools.connectivity.sqm.internal.core.connection.StatementAdapter.executeQuery(StatementAdapter.java:73) ~[org.eclipse.datatools.connectivity.sqm.core_1.2.5.v201205240353.jar:na]

 at com.teradata.datatools.dtp.catalog.TeradataCatalogView.loadColumns(TeradataCatalogView.java:377) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at com.teradata.datatools.dtp.catalog.TeradataCatalogView.getColumns(TeradataCatalogView.java:190) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at com.teradata.datatools.dtp.catalog.converters.TableConverter.marshal(TableConverter.java:143) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63) [xstream.jar:na]

 at com.thoughtworks.xstream.converters.collections.AbstractCollectionConverter.writeItem(AbstractCollectionConverter.java:64) [xstream.jar:na]

 at com.thoughtworks.xstream.converters.collections.ArrayConverter.marshal(ArrayConverter.java:45) [xstream.jar:na]

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63) [xstream.jar:na]

 at com.teradata.datatools.dtp.catalog.converters.SchemaConverter.marshal(SchemaConverter.java:111) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at com.thoughtworks.xstream.core.AbstractReferenceMarshaller.convert(AbstractReferenceMarshaller.java:68) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:78) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:63) [xstream.jar:na]

 at com.thoughtworks.xstream.core.TreeMarshaller.start(TreeMarshaller.java:98) [xstream.jar:na]

 at com.thoughtworks.xstream.core.AbstractTreeMarshallingStrategy.marshal(AbstractTreeMarshallingStrategy.java:38) [xstream.jar:na]

 at com.thoughtworks.xstream.XStream.marshal(XStream.java:837) [xstream.jar:na]

 at com.teradata.datatools.dtp.catalog.converters.SchemaSerializer.serializeSchema(SchemaSerializer.java:176) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at com.teradata.datatools.dtp.catalog.converters.SerializeSchemasJob.run(SerializeSchemasJob.java:91) [com.teradata.datatools.dtp.catalog_14.2.0.201302060329.jar:na]

 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) [org.eclipse.core.jobs_3.5.101.v20120113-1953.jar:na]

2013-04-04 21:46:23,136 Teradata Datatools [Worker-6] ERROR com.teradata.datatools.dtp.catalog - Could not display exception dialog for message: {0}

2013-04-04 21:46:23,418 Teradata Datatools [Worker-6] ERROR com.teradata.datatools.dtp.catalog - Schema Cache Serialization Canceled

2013-04-05 13:15:43,040 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

Teradata Employee

Re: Move Data does not function Teradata 12

Brett, It looks like you have caching turned on. Can you delete the cache files (option on the connection properties wizard) and turn off caching and see if that allows the Move Space dialog to come up? Thanks.

Enthusiast

Re: Move Data does not function Teradata 12

Hey Francine; I actually started with caching off and turned it on to see if it may resolve the issue, but no go. I went ahead and turned off caching for the database and still no go. I thought it may be a DNS issues, so created a new connection using the IP address directly, but still, does not function.

Prior to doing this, I cleared out the logs and the logs show no errors as follows:

2013-04-05 15:43:27,861 Teradata Datatools [main] INFO  com.teradata.studio - Teradata Studio Framework Version 14.2.0.201302060329

2013-04-05 15:44:29,425 Teradata Datatools [Worker-4] INFO  com.teradata.datatools.dtp.catalog - DTS0001: Profile [Teradata Production (IP)]- Kanji Enabled = false

Teradata Employee

Re: Move Data does not function Teradata 12

Brett, So to recap, you are on Windows 32-bit with JRE 1.6. You can bring up Teradata Studio and connect to your Teradata Database, but it hangs when you try the Move Space dialog. Can you browse the objects in the Data Source Explorer, open the Schema folder and its Tables and Views folder for the schema you want to add space to? Can you display those objects in the Teradata View? Can you run any of the other dialogs, like Create Table or Generate DDL on a table in the schema? I am just trying to get a sense of what is causing it to hang. The SQL that is executed for the Move Space is the same SQL we execute for the Data Source Explorer as you open objects. 

Enthusiast

Re: Move Data does not function Teradata 12

Correct. Windows 32 on JRE 1.6. I did find another function that does not operate successfully. If I select a schema and then right-click and select Teradata -> Grant Revoke -> Privileges, I get the same exact response where it just times out on me and I have to exit out. Everything else seems to work as I can browse schemas, look at tables and views and click on the various tabs within the schemas that have been selected. I can also create, drop and generate DDL for a table without issue.

Teradata Employee

Re: Move Data does not function Teradata 12

Brett, Another thought is to point your Teradata Studio to a clean workspace. You will have to create the connection profile again. Create a new workspace folder and call it tempworkspace. Then, exit Teradata Studio and bring up again with the -data option and provide the path to the new workspace folder. For example, -data C:\temp\tempworkspace.  Let me know if that helps.

Enthusiast

Re: Move Data does not function Teradata 12

Hi Francine;

Ok, I attempted repoint to a new workspace and recreated the datasource and attempted to run the Move Space function with the same result.

To troubleshoot, I created a new user in the database with the same privileges and then output the queries that hit the database from the querylog as shown below. The only one I had an issue with running was the fourth query down where it is looking for a parameter "?"; I replaced the parameter with a value and it works.

SQL_TEXT

- select * from DBC.Database_Default_JournalsV (22 Rows)

- HELP SESSION (1 Row)

- SELECT DatabaseName FROM dbc.DatabasesV ORDER BY 1 (27,727 Rows)

- Lock DBC.DiskSpaceV for Access SELECT TRIM(TRAILING FROM DataBaseName) AS Name, SUM(CurrentPerm) AS CurrentPerm, SUM(MaxPerm) AS MaxPerm, SUM(PeakPerm) AS PeakPerm FROM DBC.DiskSpaceV WHERE DataBaseName = ? GROUP BY DataBaseName ORDER BY DataBaseName

- SELECT TRIM(InfoData) as InfoData FROM DBC.DBCInfo WHERE InfoKey = 'LANGUAGE SUPPORT MODE' (1 Row)

- Lock DBC.DiskSpaceV for Access SELECT TRIM(TRAILING FROM DataBaseName) AS Name, SUM(CurrentPerm) AS CurrentPerm, SUM(MaxPerm) AS MaxPerm, SUM(PeakPerm) AS PeakPerm FROM DBC.DiskSpaceV WHERE DataBaseName = 'USERNAME2' GROUP BY DataBaseName ORDER BY DataBaseName (1 Row)

- SELECT DatabaseName, TRIM (CommentString) AS CommentString, TRIM(TRAILING FROM DBKind) AS DBKind, CreatorName, AccessCount, LastAccessTimeStamp, OwnerName, AccountName, ProtectionType, PermSpace, TempSpace, SpoolSpace, JournalFlag FROM DBC.DATABASESV  ORDER BY DatabaseName (27,727 Rows)