Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Visitor
MFNDX
Posts: 2
Registered: 09-29-2010
0

EBM order confirmation

Hi All,

 

Our client is using MAS90 4.3 with eBusiness. They have a number of confirmation orders that have more than 50 line items. The problem is the confirmation is broken up into 2 separate emails. They need to have the entire order show up in one email. Has anyone else had this issue? If so, how did you resolve this

 

Thanks,

 

Mark Fantasia

Moderator
SRYork
Posts: 125
Registered: 11-06-2009
0

Re: EBM order confirmation

Interesting, this sounds like a data related issue.  It would be interesting to actually see the files so I can give you a better idea / guess of what's going on.  The best insight I can give you is that these emails are stored in the IT_EMailPending table until they are sent.  If you go into DFDM you will see the key exists of:

 

NotificationCode

UserID

NotificationSeqNo

EMailTextSeqNo

 

It sounds to me like NotificationSeqNo was incremented for the subsequent pages instead of EMailTextSeqNo. These are zero filled strings so the first record is "000000" followed by "000001", etc,

If you change NotificationSeqNo to be what it is on the "first" e-mail and then increment EMailTextSeqNo to the next sequence number for the first e-mail (my guess is it would be "000001") then I think that will solve your problem for these e-mails. (Please be careful making this change so that you do not replace the first e-mail "key" with the second e-mail when you make the NotificationSeqNo change.)

 

Hint: I would recommend you fix the EMailTextSeqNo column first so you don't create a duplicate key scenario when you replace the NotificationSeqNo.

 

Of course I think this is a bug that you should report to customer support so you don't have to do this.

 

GatorGal
Switcher
SPyle
Posts: 977
Registered: 11-03-2008
0

Re: EBM order confirmation

Speaking of bugs.  I had my ebm set to email the invoice to customers.  Unfortunately, it wouldn't clear the emailpending table and would resend the invoice every 30 minutes until I dfdm'd the file and deleted the record.  A couple of "former" customers were concerned I was charging their card every 30 minutes. 

 

I had to turn off the invoiceing.  Is this how others systems work and why my reseller suggested I not use the email function?

Steve
Moderator
SRYork
Posts: 125
Registered: 11-06-2009
0

Re: EBM order confirmation

I have not heard of that issue.  There is a flag on the e-mail to indicate it has been successfully sent.  There is a "polling process" that performs various clean-up functions.  Based upon your comment, you have it set to run every 30 minutes.  As part of that process e-mails that exist that have not been flagged successfully sent are resent then removed. Why they are not getting flagged as successfully sent is your issue.  Determine that and your issue will be resolved.  I would start by checking the web error log to see if there are any e-mail related issues.  Something is aborting the process prematurely after the e-mail is sent but before the flag on the record is set and the e-mail is removed.

GatorGal
Switcher
SPyle
Posts: 977
Registered: 11-03-2008
0

Re: EBM order confirmation

Well you are right.  It is my issue.  Unfortunately it's your program.  I don't have access to the program code to figure out why it happens.  My reseller, a master developer, has reviewed the code for a few recurring errors in my log file and cannot determine the cause, nor suggest a fix.  The knowledgebase has none of my errors listed.  $250 a pop to get these problems resolved could cost me a  couple thousand to again hear "it's your issue."

 

If EBM isn't slated for some major upgrades, it will be going the way of 8-tracks, vinyl records and dial phones.

Steve
Moderator
SRYork
Posts: 125
Registered: 11-06-2009
0

Re: EBM order confirmation

I am sorry Steve, I didn't mean to imply it was only your issue. 

 

I was trying to explain how it is set up and works.  From my vantage point here, I can only 'guess' what is actually happening on your specific installation and try to point you in a direction to try and trouble shoot your issues. And, yes when you get to some levels of complicity you do need to be able to step through the code to determine the exact cause and correction needed. I do know that I have been involved with trying to resolve these kinds of issues with customer support. 

 

As for whether it makes good business sense to turn off or remove a feature and seek a different solution, that of course is a individual facts and circumstances decision that I have no way of answering.

 

Did your reseller contact support for assistance?

 

I assume you decided it did not make business sense to purchase our continuing support contract.  Otherwise, you could have contacted customer support directly to get assistance from us in determining why you are experiencing this issue and what we could propose to correct them.

GatorGal
Super Contributor
DFeller
Posts: 2,943
Registered: 10-28-2008
0

Re: EBM order confirmation

I don't see EBM being developed much.  It hasn't really been touched, other than bug fixes, since 4.10.

 

Dawn

Switcher
SPyle
Posts: 977
Registered: 11-03-2008
0

Re: EBM order confirmation

i've had support in the past and all but perhaps one case expired before a problem arose beyond my ability to correct.  Perhaps I would "get my money's worth" to get ebm functional, but I question throwing good money after bad at this point.  I know I have the traffic, I can see 3 or 4 users online at any given moment.  But when I look in the error log and see:

 

" Error #55: Cannot locate statement label"  both with and without User Logon ID's, OR:

 

"Method: %TemplateSvc'InitializeTemplate(), Error: Record 101229036660001 has been changed by another user and the changes will not be saved." 

 

and there are 10 or 12 of these a day, I have to wonder how many orders I'm losing.

 

Is this the best EBM is ever going to get, given Dawn's input?

Steve
Moderator
SRYork
Posts: 125
Registered: 11-06-2009
0

Re: EBM order confirmation

To be honest, eBM is not slated for any enhancements.  Of course, that can change if "enough" of the customer community request it.  Due to its specificity to ProvideX and the ProvideX web engine to create, edit and maintain the HTML templates, most are not familiar with it and have requested a more generic platform for their solutions.  As a result, the current trend is to lean toward and recommend Web Services which allows users to create their own web pages using readily available web authoring tools, then hook those pages up directly via the framework Sales Order business object to generate a sales order directly in their MAS 90 / MAS 200 database.

 

But, I want to quickly add eBM is still being actively supported. It is going to be next to impossible to trouble shoot the error messages you are getting using this forum and I am sorry you have been so frustrated in trying to trouble shoot this yourself. But just as there have been calls for a "more genenic" solution and because eBM is a unique implementation, especially when dealing with the web side of things, not all resellers and support analysts are equal in trying to trouble shoot. I am hopeful you understand.

 

I guess you have figured out I have dealt quite a bit with eBM and I do think it is still a viable solution given the requirements are not too large and complex.  When looking at the error log, these entries really only give you a hint on where to start your investigations. Unfortunately, as your frustrations illustrate, you have found out somethimes it is a tedious process. Please understand, with eBM errors it is a unique guessing game since all you have are the remnants of the results and it is anybody's guess what the user did (or did not do) to get the error.

 

I did take a quick look at your web site but I didn't go into your eBM web store pages.  I noticed you have several entry points. (I don't think this is not your problem.). It appears you are just utilizing the .store applet.  This just means returning users are identified by a cookie that has been stored on their machine.  If that cookie has expired or been removed by your customer or your customer is accessing your site from a different machine, they will not be recognized until they actually attempt to submit a shopping cart and supply the e-mail address and password they used on a previous shopping cart submission. I don't believe it is a "critical error" that we don't recover from or handle, but it may explain one of your error log entries.

 

The "Method: %TemplateSvc'InitializeTemplate(), Error: Record 101229036660001" error indicates that a problem occurred when attempting the initial display of a specific page.  To know which one you need to know / see if the log entry includes the program, line number, etc. Information when you drill down into it.

 

The Error: Record 101229036660001 is what the key of the eBM UserID record being used to attempt the page display.  It could be a new User ID on their first page being displayed or one that is being passed between pages via the cookie I spoke of previously. This is because we keep track of users as they access the eBM pages by this same cookie I spoke of earlier.

 

If you go into eBM User Maintenance you can use the key of the eBM UserID record value to display the record. Due to the length and format, I can tell this is a .store eBM UserID.  They are assigned in the format YYMMDD + time (formatted HHMMM) + sequence number (just in case 2 new customers access the .store pages at the same time) generated. If the record has a customer number on it, that means it is a returning customer that has previously submitted a shopping cart.  If not, it is a "new user looking around."

 

There is other information on the record that may be helpful if you look at it via DFDM.  Then you can tell when the record was created, when the user last logged on, etc.  That will tell you how much, if any the user accessed your pages. The greater the gap between created, last modified, last logged on the more the user has accessed your pages.

 

Since you have indicated it happens about 10 (or more) times daily, I would then try to determine if where the group of entries are similar and dissimilar. This would give me a hint as to prevalence i.e.. Is it only occurring displaying one specific page or all pages.

 

The other thing I would do is have my support contact check their issues tracking database to see if we've looked at this before.  These entries do sound familiar, especially the Error #55: Cannot locate statement label. Just a guess, does this error follow the %TemplateSvc'InitializeTemplate() entry (check the date time stamps on the error log entries).  If it does, this maybe an error displaying the error message.  At least, I think we had one in that scenario.

 

I know this really doesn't answer your main concern of "am I losing web customers because of these errors" but without this kind of analysis I really can not give you any comfort one way or the other. I can say we have looked at the error log in testing and on a couple of other customers. 

 

In fact, QA analysts (familiar with eBM) would process their test cases and not notice any issues and we still had error log entries. Was that because they were so familiar they were able recover quickly so they didn't realize an error had occurred that we needed to look into? Or, was the error non-critical and we were able to automatically recover from it?  Honestly, I do not know,  I am sure both scenarios occur.

 

From our analysis as you would expect:

-- Some of the entries we were able to determine what caused them and fix them. 

-- Some we were never able to reliably recreate.

-- Some were normal entries that should have been recorded.

 

I am sorry to be so long winded and ramble a bit, but I want you to know, we do care.  if you would like me to get into this in more detail with you to look into your specific issues, please e-mail me separately so we can discuss.

GatorGal
Regular Contributor
jatses
Posts: 52
Registered: 12-13-2010
0

Re: EBM order confirmation

"As a result, the current trend is to lean toward and recommend Web Services which allows users to create their own web pages using readily available web authoring tools, then hook those pages up directly via the framework Sales Order business object to generate a sales order directly in their MAS 90 / MAS 200 database."

 

I just started working with MAS and the e-Business Manager (eBM I assume) earlier this month. I come from a web development background and want to significantly modify the online store. I'm already changed 90% of the syntax in each template to make the site more efficient and "up-to-code" (so to say) with the latest coding standards (XHTML, HTML 5, etc.). However, I was wondering if there was a list of the available tokens that could be called and what each does. I've asked our reseller several times for these and always promises "tomorrow." I've done about all I can with the redesign until I see what my full spectrum of options are.

 

Back to what I was originally going to ask, above is a quote from a previous post, what is meant by this statement? I take it as there is a much simpler and beneficial method of redeveloping the online store interface than my current approach. If this is correct, please provide additional details. If I'm wrong, please set me straight...

 

Thank you for any assistance,

 

 

James

James
MAS 200 [4.40.0.5]