Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Modeler not able to access table

  1. #1
    Join Date
    Nov 2013
    Posts
    382

    Default Modeler not able to access table

    (Unsure if this post must go to BI or here.)

    Hi,
    we have a mix of postgress and SQL Server databases that we access succesfully from Kettle doing all kinds of transformations.

    When creating a model, we can access postgress databases without any problem.

    When trying to access any of the SQL Server tables to define the source of the model, we get the list of available tables, but when selecting any of them we get the error:

    org.pentaho.agilebi.modeler.ModelerException: Failed to get the fields of the table PRODDTA."Dim_Client". Either the table does not exist, or the database may require the exact case for the table and schema name.
    at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:47)
    at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.generateDomain(ModelerSourceUtil.java:67)
    at org.pentaho.agilebi.modeler.util.TableModelerSource.generateDomain(TableModelerSource.java:50)
    at org.pentaho.agilebi.modeler.util.ModelerWorkspaceUtil.populateModelFromSource(ModelerWorkspaceUtil.java:26)
    at org.pentaho.agilebi.spoon.modeler.SpoonModelerController.editDataSource(SpoonModelerController.java:208)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:616)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
    at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1221)
    at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7044)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8304)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:616)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Couldn't get field info from [SELECT TOP 1 * FROM PRODDTA."Dim_Client"]

    Invalid object name 'PRODDTA.Dim_Client'.

    at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2330)
    at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2242)
    at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1939)
    at org.pentaho.di.core.database.Database.getTableFields(Database.java:1934)
    at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.verifyTableExistsAndMayBeQuoted(ModelerSourceUtil.java:45)
    ... 27 more
    Caused by: java.sql.SQLException: Invalid object name 'PRODDTA.Dim_Client'.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304)
    at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2303)
    ... 31 more
    Any idea?

    Unsure where the "PRODDTA." comes from ...

    Thks


    EDITED: Forget it! Solved. As I was writting the "PRODDTA" sentence I figured oout the problem. This is the default schema used when no schema is provided. Changing this one to the correct one solved the problem.
    Last edited by DepButi; 11-21-2013 at 05:46 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.