4 Replies Latest reply on Oct 10, 2011 5:51 AM by Hugo Pais

    org.teiid.retroruntime.edu.emory.mathcs.backport.java.util.concurrent.TimeoutException

    Hugo Pais Newbie

      Hi 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