Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Couldn't find field 'account_id' in row!

  1. #1
    Join Date
    Apr 2014
    Posts
    18

    Default Couldn't find field 'account_id' in row!

    I am having issues when running a transformation which includes Mongodb input on a DEV server.
    The same transformation runs in production without any issues.
    Error says that the field cant be found. But the field is available in the collection. Please help!!!!!!


    DEBUG: Using PENTAHO_JAVA_HOME
    DEBUG: _PENTAHO_JAVA_HOME=/usr/java/jdk8
    DEBUG: _PENTAHO_JAVA=/usr/java/jdk8/bin/java
    DEBUG: PENTAHO_INSTALLED_LICENSE_PATH=/home/pentaho/.pentaho/.installedLicenses.xml
    WARN21-05 20:27:25,854 - Unable to load Hadoop Configuration from "file:///pentaho/data-integration/plugins/pentaho-big-data-plugin/hadoop-configurations/mapr". For more information enable debug logging.
    INFO21-05 20:27:25,864 - Pan - Logging is at level : Basic logging
    INFO21-05 20:27:25,865 - Pan - Start of run.
    INFO21-05 20:27:26,053 - trans_load_mongo_collection - Dispatching started for transformation [trans_load_mongo_collection]
    INFO21-05 20:27:26,670 - Mysql_Table_Output - Connected to database [target_product_fha] (commit=10000)
    INFO21-05 20:27:26,675 - Mysql_Table_Output - Connected to database [target_product_fha] (commit=10000)
    ERROR 21-05 20:27:26,944 - Select values - Couldn't find field 'account_id' in row!
    INFO21-05 20:27:26,945 - Select values - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
    INFO21-05 20:27:26,946 - trans_load_mongo_collection - trans_load_mongo_collection
    INFO21-05 20:27:26,946 - trans_load_mongo_collection - trans_load_mongo_collection
    INFO21-05 20:27:27,105 - MongoDb_Input - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
    INFO21-05 20:27:27,174 - Pan - Finished!
    INFO21-05 20:27:27,175 - Pan - Start=2018/05/21 20:27:25.866, Stop=2018/05/21 20:27:27.174
    INFO21-05 20:27:27,175 - Pan - Processing ended after 1 seconds.
    You have mail in /var/spool/mail/pentaho
    Last edited by shailesh10; 05-21-2018 at 07:27 PM.

Tags for this Thread

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.