Developer forum

Forum » Development » Invalid column name 'RmaReplacementOrderId'.

Invalid column name 'RmaReplacementOrderId'.

E-mail notifications
Alec Stubbs
Reply
Posted on 10/10/2012 17:41:49

I upgraded DW from 8.0.2.2 to 8.1.2.1 and now get the following error when i go to ecom

 

Server Error in '/' Application.

Invalid column name 'RmaReplacementOrderId'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'RmaReplacementOrderId'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[SqlException (0x80131904): Invalid column name 'RmaReplacementOrderId'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +388
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +688
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4403
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +82
   System.Data.SqlClient.SqlDataReader.get_MetaData() +135
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6665229
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) +6667096
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +577
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +107
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +288
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +180
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +21
   Dynamicweb.Database.CreateDataReader(String sql, String database, IDbConnection connection, Int32 commandTimeout) +955
   Dynamicweb.Admin.eComBackend.OrderList.GetOrders() +557
   Dynamicweb.Admin.eComBackend.OrderList.Page_Load(Object sender, EventArgs e) +449
   System.Web.UI.Control.LoadRecursive() +71
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17929

 

 

 

Anyone have any ideas how to fix this?

 

Cheers,

Alec


Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 10/10/2012 17:46:31
Reply

Hi Alec,

Take a look at step 12 at the bottom of this page: http://devierkoeden.com/articles/custom-modules-part-1-introduction.aspx

Cheers,

 

Imar

 
Alec Stubbs
Posted on 11/10/2012 14:16:28
Reply
This post has been marked as an answer

Thanks Imar,

 

I tried using the UpdateVersion_ecom.xml but this didn't fix the problem. Luckily I'd got another site on the same version of DW that had Ecommerce and RMA working and was able to see that the table called EcomRmas had different columns names in the site with RMA working compared to the one that wasn't working.

Something must not have been updated properly when I switched to the newer version of DW. To fix it I deleted all the EcomRma tables and switched the UpdateVersion_ecom.xml back to 10 and restarted. It rebuilt the tables, this time with the correct columns.

 

I'm not sure how recommended doing this is though!

 

Anyway, just thought I share it with everyone.

 

Cheers,

Alec

Votes for this answer: 1
 
Morten Snedker
Posted on 11/10/2012 15:01:01
Reply

Just out of curiosity: was it a beta database or otherwise a release candidate? Or was it a "plain" and official release?

 

Regards /Snedker

 
Alec Stubbs
Posted on 11/10/2012 16:17:05
Reply 
Hi Morten,

The database is the one hosted in the "Downloads" section of this site (DefaultEmptyData8SQL.zip)
Unfortunately I can't remember what versions of DW8 I've used with it. 
I know that I used 8.0.2.2 to start with but I had some bugs in the News module so upgraded to a newer version but I can't remember which one. I'm currently on 8.1.2.1

Cheers,
Alec

 

 

You must be logged in to post in the forum