Archives of the TeradataForum

Message Posted: Thu, 14 Jul 2011 @ 08:21:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

We have been facing issue while executing Fastexport script . Job is being invoked through ODI tool. It is throwing error randomly -

     com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC
     12.00.00.110] [Error 1005] [SQLState HY000] Unexpected parcel kind
     received: 144 . Log is also attached for reference. Can anyone please help.

Thanks & Regards

Rishi Agarwal

     org.apache.bsf.BSFException: exception from Jython:
     Traceback (innermost last):
       File "", line 276, in ?
       File "", line 192, in snpssqlunload
     com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC
     12.00.00.110] [Error 1005] [SQLState HY000] Unexpected parcel kind received: 144
       at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:90)
       at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:65)
       at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:126)
       at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:285)
       at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:176)
       at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:108)
       at com.teradata.jdbc.jdbc_4.statemachine.PreparedStatementController.run(PreparedStatementController.java:47)
       at com.teradata.jdbc.jdbc_4.statemachine.StatementController.fetchRows(StatementController.java:330)
       at com.teradata.jdbc.jdbc_4.ResultSet.goToRow(ResultSet.java:325)
       at com.teradata.jdbc.jdbc_4.ResultSet.next(ResultSet.java:616)
       at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalResultSet.next(TeraLocalResultSet.java:136)
       at com.sunopsis.dwg.tools.SqlUnload.unloadDataDe(SqlUnload.java)
       at com.sunopsis.dwg.tools.SqlUnload.actionExecute(SqlUnload.java)
       at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java)
       at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25)
       at java.lang.reflect.Method.invoke(Method.java:592)
       at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java)
       at org.python.core.PyMethod.__call__(PyMethod.java)
       at org.python.core.PyObject.__call__(PyObject.java)
       at org.python.core.PyInstance.invoke(PyInstance.java)
       at org.python.pycode._pyx960.snpssqlunload$7(:192)
       at org.python.pycode._pyx960.call_function()
       at org.python.core.PyTableCode.call(PyTableCode.java)
       at org.python.core.PyTableCode.call(PyTableCode.java)
       at org.python.core.PyFunction.__call__(PyFunction.java)
       at org.python.pycode._pyx960.f$0(:276)
       at org.python.pycode._pyx960.call_function()
       at org.python.core.PyTableCode.call(PyTableCode.java)
       at org.python.core.PyCode.call(PyCode.java)
       at org.python.core.Py.runCode(Py.java)
       at org.python.core.Py.exec(Py.java)
       at org.python.util.PythonInterpreter.exec(PythonInterpreter.java)
       at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)
       at com.sunopsis.dwg.codeinterpretor.k.a(k.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(SnpSessTaskSql.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(SnpSessTaskSql.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
       at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
       at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
       at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java)
       at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
       at com.sunopsis.dwg.cmd.e.k(e.java)
       at com.sunopsis.dwg.cmd.h.A(h.java)
       at com.sunopsis.dwg.cmd.e.run(e.java)
       at java.lang.Thread.run(Thread.java:595)
     com.teradata.jdbc.jdbc_4.util.JDBCException:
     com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC
     12.00.00.110] [Error 1005] [SQLState HY000] Unexpected parcel kind received: 144
       at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
       at com.sunopsis.dwg.codeinterpretor.k.a(k.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(SnpSessTaskSql.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(SnpSessTaskSql.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)
       at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
       at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
       at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
       at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(DwgCommandScenario.java)
       at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
       at com.sunopsis.dwg.cmd.e.k(e.java)
       at com.sunopsis.dwg.cmd.h.A(h.java)
       at com.sunopsis.dwg.cmd.e.run(e.java)
       at java.lang.Thread.run(Thread.java:595)

	<Prev	Next>		<<First	<Prev	Next>	Last>>