PDA

View Full Version : I run kitchen.sh or pan.sh in AIX5.0,but error,pls help, tks



wangwg
06-23-2008, 02:57 AM
INFO 23-06 14:37:04,229 (LogWriter.javarintln:406) -Pan - Start of run.
INFO 23-06 14:37:06,621 (LogWriter.javarintln:406) -crd_s_dic - Dispatching started for transformation [crd_s_dic]
INFO 23-06 14:37:06,622 (LogWriter.javarintln:406) -crd_s_dic - Nr of arguments detected:0
INFO 23-06 14:37:06,623 (LogWriter.javarintln:406) -crd_s_dic - This is not a replay transformation
INFO 23-06 14:37:06,641 (LogWriter.javarintln:406) -crd_s_dic - This transformation can be replayed with replay date: 2008/06/23 14:37:06
INFO 23-06 14:37:06,642 (LogWriter.javarintln:406) -crd_s_dic - Initialising 3 steps...
INFO 23-06 14:37:07,145 (LogWriter.javarintln:406) -???.0 - Connected to database [informix_report] (commit=100)
INFO 23-06 14:37:07,167 (LogWriter.javarintln:406) -???.0 - Starting to run...
INFO 23-06 14:37:07,167 (LogWriter.javarintln:406) -??SQL??.0 - Starting to run...
INFO 23-06 14:37:07,168 (LogWriter.javarintln:406) -???.0 - Starting to run...
INFO 23-06 14:37:07,174 (LogWriter.javarintln:406) -??SQL??.0 - Finished reading query, closing connection.
INFO 23-06 14:37:07,176 (LogWriter.javarintln:406) -??SQL??.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
ERROR 23-06 14:37:07,250 (LogWriter.javarintln:403) -???.0 - Unexpected error :
ERROR 23-06 14:37:07,263 (LogWriter.javarintln:403) -???.0 - org.pentaho.di.core.exception.KettleDatabaseException:
An error occurred executing SQL:
SELECT
pk1
, cnname
, enname
, type1
, property
, memo
, flag
FROM s_dic
The specified table (s_dic) is not in the database.
at org.pentaho.di.core.database.Database.openQuery(Database.java:1740)
at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:200)
at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:119)
at org.pentaho.di.trans.steps.tableinput.TableInput.run(TableInput.java:326)
Caused by: java.sql.SQLException: The specified table (s_dic) is not in the database.
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3204)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2353)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2269)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1153)
at com.informix.jdbc.IfxPreparedStatement.e(IfxPreparedStatement.java:318)
at com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java:298)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:168)
at com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:5909)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:2096)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1678)
... 3 more
INFO 23-06 14:37:07,265 (LogWriter.javarintln:406) -???.0 - Finished reading query, closing connection.
ERROR 23-06 14:37:07,272 (LogWriter.javarintln:403) -crd_s_dic - Errors detected!
INFO 23-06 14:37:07,283 (LogWriter.javarintln:406) -???.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
INFO 23-06 14:37:07,284 (LogWriter.javarintln:406) -???.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
INFO 23-06 14:37:07,326 (LogWriter.javarintln:406) -crd_s_dic - Transformation detected 1 steps with errors!
INFO 23-06 14:37:07,327 (LogWriter.javarintln:406) -crd_s_dic - Transformation is killing the other steps!
INFO 23-06 14:37:07,327 (LogWriter.javarintln:406) -crd_s_dic - Looking at step: ???
INFO 23-06 14:37:07,328 (LogWriter.javarintln:406) -crd_s_dic - Looking at step: ???
INFO 23-06 14:37:07,329 (LogWriter.javarintln:406) -crd_s_dic - Looking at step: ??SQL??
INFO 23-06 14:37:07,329 (LogWriter.javarintln:406) -Pan - Finished!
INFO 23-06 14:37:07,330 (LogWriter.javarintln:406) -Pan - Start=2008/06/23 14:37:06.468, Stop=2008/06/23 14:37:07.330
INFO 23-06 14:37:07,331 (LogWriter.javarintln:406) -Pan - Processing ended after 0 seconds.

sboden
06-23-2008, 03:02 AM
The specified table (s_dic) is not in the database.
The specified table (s_dic) is not in the database.
The specified table (s_dic) is not in the database.
The specified table (s_dic) is not in the database.

Run the query in the log file with the same id as you filled in in PDI (but with a isql e.g.)

:D

wangwg
06-23-2008, 03:04 AM
but the table s_dic in my db easymis, and some time the transaction can successfully run.