Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Import tables empty window and other problems

  1. #1
    Join Date
    Sep 2008
    Posts
    21

    Default Import tables empty window and other problems

    Hi, I have some problems using Pentaho Metadata Editor.

    1) I have estabilished a connection to an Oracle 10g Server. If I try to import tables clicking with the right mouse button over the connection's icon -->> import tables, a window is open BUT IS FULL EMPTY.

    2) If I try to import tables using "Import from Explorer" i can imprt ONLY ONE TABLE: if I want to import many tables I must reopen "Import from Explorer" and import another table.

    3)I have estabilished another connection to a DB2 LUW v9 server. I'd like again to import many tables in a single step. If I use "Import tables" on this connection a window is open and I see all tables but, if I try to import some of these an error is occurred:

    Couldn't get field info from [SELECT * FROM TEST_TABLE]

    DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: TEST_USER.TEST_TABLE

    I suppose that the table owner isn't inserted in the executed query (SELECT * FROM TEST_TABLE).

    This is the stack:

    Code:
    at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2418)
        at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2335)
        at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1872)
        at org.pentaho.di.core.database.Database.getTableFields(Database.java:1867)
        at org.pentaho.pms.ui.MetaEditor.importTableDefinition(MetaEditor.java:3381)
        at org.pentaho.pms.ui.MetaEditor.importMultipleTables(MetaEditor.java:3331)
        at org.pentaho.pms.ui.MetaEditor$54.handleEvent(MetaEditor.java:1729)
        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.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:847)
        at org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3582)
    Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB6A.TACT12_MES
        at com.ibm.db2.jcc.c.qh.c(qh.java:1671)
        at com.ibm.db2.jcc.c.qh.d(qh.java:1659)
        at com.ibm.db2.jcc.c.qh.a(qh.java:1216)
        at com.ibm.db2.jcc.a.db.g(db.java:139)
        at com.ibm.db2.jcc.a.db.a(db.java:39)
        at com.ibm.db2.jcc.a.t.a(t.java:34)
        at com.ibm.db2.jcc.a.sb.f(sb.java:142)
        at com.ibm.db2.jcc.c.qh.m(qh.java:1187)
        at com.ibm.db2.jcc.c.qh.a(qh.java:1891)
        at com.ibm.db2.jcc.c.qh.a(qh.java:478)
        at com.ibm.db2.jcc.c.qh.executeQuery(qh.java:462)
        at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2391)
        ... 12 more
    Can you help me to solve these problems?
    Thank you

  2. #2

    Default

    Quote Originally Posted by braian View Post
    Hi, I have some problems using Pentaho Metadata Editor.
    1) I have estabilished a connection to an Oracle 10g Server. If I try to import tables clicking with the right mouse button over the connection's icon -->> import tables, a window is open BUT IS FULL EMPTY.

    2) If I try to import tables using "Import from Explorer" i can imprt ONLY ONE TABLE: if I want to import many tables I must reopen "Import from Explorer" and import another table.
    i have the same problem... with a JNDI connection on a ORACLE 11g db ...why?!

  3. #3

    Default

    Anyone has same problem? Really?!

  4. #4
    Join Date
    Sep 2010
    Posts
    100

    Default

    Hi,
    It looks like a bug, but it lets you if you change to a JDBC connection.

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.