search

tggwlcube / TG_Cube_ESM_log

0 stars 0 forks source link

Error in Reports -> Production History #67

Open pratik-ss2 opened 11 years ago

pratik-ss2 commented 11 years ago

Group Wise-> Machine Wise

production history machine wise error

Log File-> Date Time Stamp : 9/9/2013 10:46:49 AM Source of error : at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr) at System.Data.OleDb.OleDbDataReader.NextResult() at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CuBe.MeshProducSummMachineRpt.MeshProducSummMachineRpt_Load(Object sender, EventArgs e) in G:\CuBe_v2.0\CuBe\MeshProducSummMachineRpt.vb:line 46 Error Details : Invalid column name 'MTD_BATCH_ID'. Invalid column name 'MTD_BATCH_ID'. Invalid column name 'MSD_BATCH_ID'.

Solution-> 1.Replace MTD_BATCH_ID with MTD_ITEM_ID 2.Replace MSD_BATCH_ID with MSD_ITEM_ID