http://forums.method.me/cs/forums/18.aspxLet us know about bugs, error messages, annoyances and ways we can make the app lovable!enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/21466.aspxWed, 02 Apr 2014 15:46:51 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:21466Method_Adam0http://forums.method.me/cs/forums/thread/21466.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=18&PostID=21466<p><span id="mce_0_start" style="overflow:hidden;">Mike,</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span>I sent you an email in regards to the case we created for this. &nbsp;For anyone else, the <span id="mce_2_start" style="overflow:hidden;"></span>PriceLevelPerItemRetList table is not a table that can accept inserts.<span id="mce_4_start" style="overflow:hidden;"> It is a read only table in Method.</span></p> <p>- Adam</p>http://forums.method.me/cs/forums/thread/21438.aspxMon, 31 Mar 2014 18:57:21 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:21438MikeH0http://forums.method.me/cs/forums/thread/21438.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=18&PostID=21438<p><span id="mce_0_start" style="overflow:hidden;">Hi, I&#39;m trying to insert records from one table into another and I keep receiving an error that the column &#39;ServerTimeModified&#39; is invalid. This is not a field name in these tables so it sounds like a bug in the system. <span id="mce_3_start" style="overflow:hidden;"></span>Here is the error:</span></p> <p></p> <p>FROM actInsertRecordsIntoTable - Values<br />TableaccPriceLevelPerItemRetList<br />RecordID96631<br />MessageInvalid column name &#39;ServerTimeModified&#39;.<br />StackTrace at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.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(DataTable[ dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Com.Method.MethodData.DataAccess.ExecuteQuery(SqlConnection sqlConn, String commandText, SqlTransaction transaction, SqlParameter[ parameters) at Com.Method.MethodData.MethodDatabase.ExecuteQuery(String commandText, SqlParameter[ parameters) at Com.Method.Shared.AccountingCleanUp.fnSetAccounting_CleanUp(MethodDatabase&amp; _MethodDatabase, String sTableName, Int32 intRecordID, Int32 intSecurityID) Please verify this field exists in the table or remove this field from the insertion action.<span id="mce_2_start" style="overflow:hidden;"></span></p>