AnsweredAssumed Answered

Couldn't find field 'account_id' in row!

Question asked by Shailesh royyuru on May 21, 2018

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

WARN  21-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.

INFO  21-05 20:27:25,864 - Pan - Logging is at level : Basic logging

INFO  21-05 20:27:25,865 - Pan - Start of run.

INFO  21-05 20:27:26,053 - trans_load_mongo_collection - Dispatching started for transformation [trans_load_mongo_collection]

INFO  21-05 20:27:26,670 - Mysql_Table_Output - Connected to database [target_product_fha] (commit=10000)

INFO  21-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!

INFO  21-05 20:27:26,945 - Select  values - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)

INFO  21-05 20:27:26,946 - trans_load_mongo_collection - trans_load_mongo_collection

INFO  21-05 20:27:26,946 - trans_load_mongo_collection - trans_load_mongo_collection

INFO  21-05 20:27:27,105 - MongoDb_Input - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)

INFO  21-05 20:27:27,174 - Pan - Finished!

INFO  21-05 20:27:27,175 - Pan - Start=2018/05/21 20:27:25.866, Stop=2018/05/21 20:27:27.174

INFO  21-05 20:27:27,175 - Pan - Processing ended after 1 seconds.

You have mail in /var/spool/mail/pentaho

Outcomes