search

tggwlcube / TG_Cube_ESM_log

0 stars 0 forks source link

Error in Reports -> Production History #69

Open pratik-ss2 opened 11 years ago

pratik-ss2 commented 11 years ago

Group Wise -> Machine and Product Wise production history machine and product wise error

Log File-> Date Time Stamp : 9/9/2013 10:53: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.WtProducedSummMCnProdWiseRpt.CryWtprodwise_Load(Object sender, EventArgs e) in G:\CuBe_v2.0\CuBe\WtProducedSummMCnProdWiseRpt.vb:line 88 Error Details : Invalid column name 'MSR_BATCH_ID'. Invalid column name 'MSR_BATCH_ID'.

Solution->

1.Replace MSR_BATCH_ID with MSR_ITEM_ID