PDA

View Full Version : Import tables empty window and other problems



braian
02-12-2010, 04:59 AM
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:



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

andrea
05-09-2011, 06:48 AM
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?!

andrea
08-23-2011, 07:54 AM
Anyone has same problem? Really?!

Bronson
06-28-2012, 02:45 AM
Hi,
It looks like a bug, but it lets you if you change to a JDBC connection.