Hi all,
For the last week we’ve suddenly had all of the order notes on our web sales (TNew v5) automatically populate with the following: CustomerNotes: ;
If the customer adds their own order notes these will appear after the “CustomerNotes: ;” .
In some instances we have also had it appear twice in the order notes, such as: CustomerNotes: ; CustomerNotes: ;
As far as I know we haven’t changed any settings for TNew in this time. I’ve had a look through the TNew documentation and have searched through all of the TNew related system tables, but I can’t find any reference to this.
Does anyone know how this might be triggering?
Thanks,
Alison
I’d be curious to know if they can fix it. We’ve been seeing this here as well.
From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Chris Jensen Sent: Friday, April 10, 2015 9:22 AM To: Christopher Short Subject: Re: [Tessitura Web Forum] TNew auto populating order notes
Not fixed. I see these are appearing in our orders again, too. I'll be resubmitting our support ticket shortly...
From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com> Sent: 4/10/2015 12:10:19 PM
We've experienced this here, too. A known bug. Please report it via a support ticket, as I believe they can fix it now, or at least they could on 3/25.
(Interesting: could this be something that must be fixed site-by-site?)
You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
On 3/25 I reported in a "pending - dev review" support ticket that they had stopped appearing in our orders. I now see that sometime in the last week or so they've started appearing again, which I've also reported.
Thanks everyone! In our ongoing efforts to address issues reported by our users, a minor change was made that inadvertently affected the way that order notes are handled on TNEW behind the scenes. Regardless of the customer entering anything in, TNEW is saving a blank note of "CustomerNotes:" to the order notes field. This issue was introduced with our last patch, when v5.5.18.49 was pushed out to all v5.5 TNEW sites.
We have a fix in place in our internal QA environment, and will be pushing fixes out to all QA TNEW sites early next week. If you are experiencing this additional order note on your site and would like to help test the changes, please submit a TASK ticket and we will let you know as soon as the patch is ready for testing on your QA site.
We update the Release Notes section of the TN Express Web User guide as soon as a known defect has been resolved. So as soon as this fix is available, you will see it posted there.
Best,Karyn
Thanks so much!!
Carol
Hi
We are also experiencing this automatic message that populate in our customer's order (customer's notes: ;) and for some instance it shows up twice in 2 lines. Aside from this issue our patrons are receiving an sql error in their confirmation email as it shows below.
Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid Procedure Index at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at Tessitura.WebAPI.ExecuteLocalProcedureCommand.Execute() at Tessitura.WebAPI.Tessitura.ExecuteLocalProcedure(String SessionKey, Int32 LocalProcedureId, String LocalProcedureValues) at TNEW.Objects.CartEmailData.LoadData()
Is there anyone also experiencing this problem?
Thanks
Eric Lazaro
RWB - Database Administrator
Hi Eric,
The issue with your order confirmation email sounds like you may not have the current version of the TNEW Email templates. I've gone ahead and opened a TASK Support ticket on your behalf and you will receive a copy via email. Someone from our support team will be in touch to assist you shortly.
P.S. We are still reviewing the fix for the CustomerNotes: ; issue and hope to have an update for everyone later this week.
Hi Karyn
Thank you very much! :)