Developer forum

Forum » Ecommerce - Standard features » Problem with backend Online marketing

Problem with backend Online marketing

E-mail notifications
Grant Menzies
Reply
Posted on 04/03/2015 09:42:15

I have used the online marketing module previously and it has worked well.

For som reason I am now getting the following server problem.

Is there anyone that has had similar issues?

Serverfel i tillämpningsprogrammet /.

Conversion failed when converting the nvarchar value '<!--@EmailMessaging:Recipient.Id-->' to data type int.

Beskrivning: Ett undantag som inte kunde hanteras uppstod när den aktuella webbegäran kördes. Mer information om felet och var i koden det uppstod finns i stackspårningen. 

Undantagsinformation: System.Data.SqlClient.SqlException: Conversion failed when converting the nvarchar value '<!--@EmailMessaging:Recipient.Id-->' to data type int.

Källfel: 
 

Ett undantag som inte hanteras genererades vid körningen av den aktuella webbegäran. Information om undantagets ursprung och plats kan identifieras med undantagsstackspårningen nedan.


Stackspårning: 
 

[SqlException (0x80131904): Conversion failed when converting the nvarchar value '<!--@EmailMessaging:Recipient.Id-->' to data type int.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1787814
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5341674
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1693
   System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +348
   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +230
   System.Data.SqlClient.SqlDataReader.Read() +34
   System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +64
   System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +148
   System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +421
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +173
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +316
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +88
   Dynamicweb.Database.CreateDataSet(String sql, String database, IDbConnection connection, IDbTransaction transaction, Boolean withSchema) +818
   Dynamicweb.Database.CreateDataTable(String sql) +19
   Dynamicweb.Modules.EmailMarketing.Statistics.EmailStatistics.GetRecipientsStatDataSum(IEnumerable`1 recipientIds, EmailMessageType emailMessageTypeToUse) +223
   Dynamicweb.Modules.EmailMarketing.Statistics._Closure$__12._Lambda$__42(List`1 recipientIds, EmailEngagementIndex engagementIndex, EmailMessageType emailType) +28
   Dynamicweb.Modules.EmailMarketing.Statistics.EmailStatistics.GetEngagementIndexForRecipientsWhoClicked() +203
   Dynamicweb.Admin.OMC.Emails.Statistics.GetEngagementStatData(Int32 totalNumberOfClicks) +147
   Dynamicweb.Admin.OMC.Emails.Statistics.Page_Load(Object sender, EventArgs e) +3595
   System.Web.UI.Control.OnLoad(EventArgs e) +92
   System.Web.UI.Control.LoadRecursive() +54
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772

Replies

 
Anders Ebdrup
Posted on 08/03/2015 11:49:55
Reply
This post has been marked as an answer

Hi,

 

Yes, we have had the same issue and was told to upgrade our solution. Which version of Dynamicweb are you running?

 

Best regards, Anders

Votes for this answer: 1
 
Grant Menzies
Posted on 11/03/2015 08:42:19
Reply

Thanks for your reply!

We are running 8.3.1.1

For some reason the issue has solved itself. I checked the sent newsletter after a few days and the data seems to be showing properly.

I'll mark your reply as answer despite never applying the solution. Thanks!

 
Anders Ebdrup
Posted on 13/03/2015 11:31:34
Reply

Hi again,

 

I think that you will see this again in the version your are running. When using the Email marketing module I will recommend that you upgrade to 8.4.1.x

 

Best regards, Anders

 
Grant Menzies
Posted on 13/03/2015 16:06:19
Reply

Our solution is soon being updated so problem solved. Thanks!

 

You must be logged in to post in the forum