org.teiid.retroruntime.edu.emory.mathcs.backport.java.util.concurrent.TimeoutException
equilibrium Oct 7, 2011 1:18 PMHi guys i am trying to use Teiid as my vdb to acess CSV files and using as client Kettle, but when I try to acess a datafile with 400000 rows in kettle i get this exception any clue why this is happening?
org.pentaho.di.core.exception.KettleDatabaseException:
An error occurred executing SQL:
SELECT RESULT.*
FROM (EXEC departmento.getTextFiles('REP6_6_20090508145604_1')) AS f,
TEXTTABLE(f.file COLUMNS FDN string DELIMITER ':' SKIP 7 ) RESULT
org.teiid.retroruntime.edu.emory.mathcs.backport.java.util.concurrent.TimeoutException
at org.pentaho.di.core.database.Database.openQuery(Database.java:1912)
at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:223)
at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:133)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.teiid.jdbc.TeiidSQLException: org.teiid.retroruntime.edu.emory.mathcs.backport.java.util.concurrent.TimeoutException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:563)
at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:354)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1898)
... 4 more
Caused by: org.teiid.retroruntime.edu.emory.mathcs.backport.java.util.concurrent.ExecutionException: org.teiid.retroruntime.edu.emory.mathcs.backport.java.util.concurrent.TimeoutException
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:335)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:555)
... 6 more
Caused by: org.teiid.retroruntime.edu.emory.mathcs.backport.java.util.concurrent.TimeoutException
at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:270)
at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:108)
at $Proxy16.read(Unknown Source)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:347)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:333)
... 7 more