Developer forum

Forum » Development » Error after creating orderfields

Error after creating orderfields

Martin Nielsen
Reply
Hey,

I've created a few custom fields in a local DW solution, but when i go to the eCommerce, i get this error:

Serverfejl i programmet '/'.

The column 'CurrencyCode' was specified multiple times for 'FilteredOrders'.

Beskrivelse: Der opstod en undtagelse, der ikke blev behandlet, under udførelse af den aktuelle webanmodning. Se staksporingen for at få flere oplysninger om fejlen, og hvor den kom fra i koden. 

Detaljer om undtagelse: System.Data.SqlClient.SqlException: The column 'CurrencyCode' was specified multiple times for 'FilteredOrders'.

Kildefejl: 

Der blev oprettet en undtagelse, der ikke blev behandlet,  under kørsel af den aktuelle webanmodning. Du kan finde oplysninger om undtagelsens oprindelse og placering ved hjælp af nedenstående staksporing af undtagelser.

Staksporing: 


[SqlException (0x80131904): The column 'CurrencyCode' was specified multiple times for 'FilteredOrders'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2073486
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064444
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +86
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   Dynamicweb.Database.CreateDataReader(String sql, String database, IDbConnection connection, Int32 commandTimeout) +596
   Dynamicweb.Admin.eComBackend.OrderList.GetOrders() +127
   Dynamicweb.Admin.eComBackend.OrderList.Page_Load(Object sender, EventArgs e) +317
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

Versionsoplysninger: Microsoft .NET Framework version:4.0.30319; ASP.NET version:4.0.30319.272
I've tried "IISRESET" but that didn't work. and i can't find anything called FilteredOrders anywhere.

Any ideas?

// Martin

Replies

 
Morten Bengtson
Reply
Did you create a custom order field with the systemname "CurrencyCode"?
I think you need to remove that custom field and also remove the column that was created on the EcomOrders table. It will cause a conflict with EcomCurrencies.CurrencyCode that is joined with EcomOrders when orders are listed in the administration.

 

You must be logged in to post in the forum