Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Jun 2008
    Posts
    4

    Post I run kitchen.sh or pan.sh in AIX5.0,but error,pls help, tks

    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.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    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.)


  3. #3
    Join Date
    Jun 2008
    Posts
    4

    Post

    but the table s_dic in my db easymis, and some time the transaction can successfully run.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.