back to forum.

Topic: Error when opening certain analysis files

Topic by
chiaochi

2011-04-15
21:00

Error when opening certain analysis files

Hi Kasper,

I'm getting the following errors when opening certain analysis files. I've even tried to recreate the analysis using DC 2.1 but still got the same error.

Thank you!

George

----


Unexpected error!


Message:
java.lang.IllegalStateException: No such column: dbo.FinalWarmLeadsMtM.LegacyTrackerID
Level:
SEVERE
Stack Trace:
No such column: dbo.FinalWarmLeadsMtM.LegacyTrackerID
org.eobjects.analyzer.job.JaxbJobReader.create(JaxbJobReader.java:339)
org.eobjects.analyzer.job.JaxbJobReader.create(JaxbJobReader.java:229)
org.eobjects.analyzer.job.JaxbJobReader.create(JaxbJobReader.java:222)
org.eobjects.datacleaner.actions.OpenAnalysisJobActionListener.openFile(OpenAnalysisJobActionListener.java:85)
org.eobjects.datacleaner.actions.OpenAnalysisJobActionListener.actionPerformed(OpenAnalysisJobActionListener.java:75)
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.setPressed(Unknown Source)
javax.swing.AbstractButton.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
java.awt.Component.processMouseEvent(Unknown Source)
javax.swing.JComponent.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Unknown Source)
java.awt.Container.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Window.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.EventQueue.dispatchEvent(Unknown Source)
java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.run(Unknown Source)

Reply by
kasper

2011-04-16
10:47
Did you check if the column mentioned still exists? This error message simply says that a column defined in the job file is not available in the datastore, so maybe there have been a structure change?

You might try to open the job file as a template instead - then you can map the old column path to a new column path.

Reply by
chiaochi

2011-04-19
19:02
Kasper,

None of the columns changed. I also tried to recreate the analysis from scratch, but got the same error after closing and reopening the file right after.

As a workaround now, I'm opening these files using template.

Should you need more information, please let me know. Thank you!

George

Reply by
kasper

2011-04-19
19:49
Hi George,

That sounds weird... Hmm... Can you send me a copy of your analysis.xml file to my email, then I will give it a look? Or alternatively just paste in the <source> part of it on the forum.

Reply by
chiaochi

2011-04-19
19:58
Sent to you via email. Thanks for the prompt reply!

Reply by
kasper

2011-04-29
15:16
Hi George,

Having trouble figuring out what this is about. I can't see anything weird about that column from looking at the job file.

Can you, for experiments sake, try creating a very simple job based on just that column? It could be eg. a simple String analyzer applied just to that column. Then save it and check if you can still open it.

You need to be logged in to participate

In order to post your own comments on this topic, you need to be logged in.

Username:

Log in by clicking the login link at the top of the screen

 

Go back to forum.