Skip to Content
0
Former Member
Mar 05, 2009 at 05:51 PM

No Template Body found for TemplateCode

7 Views

Hi,

I have installed SP1P1 on my web server and have upgraded my test instance/test copy of my database.

My live site I have left running patch 11.

However, I noticed that no emails were being sent by the email service post upgrade. The upgrade has obviously replaced the messaging service, and this was not working at all against the p11 db at all. I uninstalled that service, installed patch 11 (installer), and registered the mail service manually. It would now seem that the messaging sevice is working only for shipments, I haven't seen any order confirmations, and the forgot password etc is definitely not working. These are some of the error messages in the log:

<event>

<messagetype>I</messagetype>

<date>2009-03-05 16:59:45.54</date>

<synchmodule>MailerContactLog</synchmodule>

<message>No Template Body found for TemplateCode 'forgotpassword' </message>

<synchmethod>SendContactLog()</synchmethod>

<objecttype>npcontactlog</objecttype>

<objectid>2036</objectid>

</event>

<event>

<messagetype>E</messagetype>

<date>2009-03-05 16:59:45.39</date>

<synchmodule>Sender</synchmodule>

<message>Completed send of Order Documents with error:Invalid column name 'WeightTotalUnitCode'.</message>

<synchmethod>SendOrderDocuments()</synchmethod>

<objecttype />

<objectid />

</event>

I have checked and the mail template does exist for the forgot password and matches with the contactslog table record.

Any idea what the problem could be?, it is my understanding that I have the p11 messaging service running against a p11 database.

Thanks.

Martin.