back to forum.

Topic: error opening data profile configuration

Topic by
fschie

2011-01-10
13:01

error opening data profile configuration

I get following error when I want to open a previously saved profiler configuration (.dpc):


Error opening file
 

Message:
    dk.eobjects.metamodel.MetaModelException: com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name. 
Level:
    SEVERE
Stack Trace:
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name.
    dk.eobjects.metamodel.JdbcDataContextStrategy.getSchemaNames(JdbcDataContextStrategy.java:785)
    dk.eobjects.metamodel.DataContext.getSchemaNames(DataContext.java:90)
    dk.eobjects.datacleaner.gui.widgets.SchemaTree.updateTree(SchemaTree.java:80)
    dk.eobjects.datacleaner.gui.widgets.SchemaTree.<init>(SchemaTree.java:70)
    dk.eobjects.datacleaner.gui.windows.ProfilerWindow.<init>(ProfilerWindow.java:183)
    dk.eobjects.datacleaner.gui.windows.ProfilerWindow.deserialize(ProfilerWindow.java:266)
    dk.eobjects.datacleaner.gui.widgets.OpenFileActionListener.actionPerformed(OpenFileActionListener.java:60)
    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)
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name.
    com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
    com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)
    com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
    com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(Unknown Source)
    com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(Unknown Source)
    dk.eobjects.metamodel.JdbcDataContextStrategy.getSchemaSQLServerNames(JdbcDataContextStrategy.java:801)
    dk.eobjects.metamodel.JdbcDataContextStrategy.getSchemaNames(JdbcDataContextStrategy.java:756)
    dk.eobjects.metamodel.DataContext.getSchemaNames(DataContext.java:90)
    dk.eobjects.datacleaner.gui.widgets.SchemaTree.updateTree(SchemaTree.java:80)
    dk.eobjects.datacleaner.gui.widgets.SchemaTree.<init>(SchemaTree.java:70)
    dk.eobjects.datacleaner.gui.windows.ProfilerWindow.<init>(ProfilerWindow.java:183)
    dk.eobjects.datacleaner.gui.windows.ProfilerWindow.deserialize(ProfilerWindow.java:266)
    dk.eobjects.datacleaner.gui.widgets.OpenFileActionListener.actionPerformed(OpenFileActionListener.java:60)
    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)

How can I save profiler configurations and open them again?

Reply by
kasper

2011-01-10
13:12
Hi,

Tell me, can you open the database in a new job? It looks as if it is running into some problem when fetching the metadata (specifically the schema names) from the DB and that probably has nothing to do with the saved job but more a connection (authentication maybe?) problem in general.

Reply by
fschie

2011-01-10
13:16
i can run the profile once I have defined it. Good to know is that I am profiling a SQL Server db using integrated security. Connection is set up as such by adding integratedSecurity=true; to the connection string.

Reply by
fschie

2011-01-10
13:22
I found a workaround. Since I am working with integrated security I have not filled in user, password and catalog. This shows as follows in the configuration file:
<property name="catalog"/>
<property name="password"/>
<property name="username"/>.
Removing those lines from the config file, make it work.

Reply by
kasper

2011-01-10
13:23
Ok that's interesting.

Can you try opening the .dcp file in an editor (notepad or such) and see if there's a <property> element with the name "catalog"? Try removing it, it might be influencing the way the connection is made.

/Kasper

Reply by
kasper

2011-01-10
13:25
Ah that's great knowledge! I will make sure to get a fix to this issue into the upcoming DataCleaner 2.0.

Reply by
fschie

2011-01-10
13:26
Only removing catalog makes it also work.

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.