5 Replies Latest reply on Jul 1, 2011 1:59 AM by AdamWilden

    Help!  Outgoing emails failing after upgrade to 7.4

    Expert

      Hi,

       

      Landesk upgraded us to 7.4 today but we didn't check emails.

       

      I've just noticed that none have sent to customers since we upgraded.  SLA emails etc send OK.

       

      The others are showing as failed in the queue...

       

      Does anyone have any ideas?

       

      Many thanks - Adam.

        • 1. Re: Help!  Outgoing emails failing after upgrade to 7.4
          Expert
          Event log for OutBound email shows:
          Object reference not set to an instance of an object.
          And also for Touchpaper Services shows:
          The description for Event ID 0 from source Touchpaper Services cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
          If the event originated on another computer, the display information had to be saved with the event.
          The following information was included with the event:
          OracleException
          ORA-00001: unique constraint (LD_BTO.INDEX$TPS_USER$NAME) violated
          Stack Trace:
          at Touchpaper.Framework.Data.DataObjectContext.DoUpdates(IList listToUpdate, IList listMutualDependencies)
          at Touchpaper.Framework.Data.DataObjectContext.SaveChanges()
          at Touchpaper.Framework.Web.DataService.SaveChanges(SDataObjectContext sctxt, Boolean returnChanges)
          at Touchpaper.Framework.Web.DataService.SaveObjects(SDataObjectContext sctxt)
          the message resource is present but the message is not found in the string/message table
          • 2. Re: Help!  Outgoing emails failing after upgrade to 7.4
            karenpeacock SupportEmployee

            Hi Adam

             

            I sent you an email via a case update.  Did you get this?

             

            Thanks

            Karen

            • 3. Re: Help!  Outgoing emails failing after upgrade to 7.4
              Expert

              Hi Karen,

               

              Yes thanks.

               

              We tried update md_attribute_type set md_sub_data_type = 20 where md_guid = 'CB058B53A483564AB66FCFF5476D44E9'; but it made no difference.

               

              Still getting "Object Reference Not Set" or "Specified Cast in Invalid" errors in the Event log and all outbound non-SLA generated emails failing.

               

              Our DBAs are poring through the email tables in the hopes of spotting something.

               

              (Sorry - I replied to your email by mistake.)

              • 4. Re: Help!  Outgoing emails failing after upgrade to 7.4
                Expert

                Hi Adam,

                 

                We ran into similar problems and used this script-

                 

                Update  md_attribute_type set md_sub_data_type = '20' where md_name =  'EMailAddress' and md_database_table_guid = (select md_guid from  md_database_table where md_name ='TPS_USER');

                 

                To correct it. I think it is much the same as the one Karen probably provided but maybe the GUID value is different?

                 

                Cheers,

                Hadyn

                • 5. Re: Help!  Outgoing emails failing after upgrade to 7.4
                  Expert

                  Thanks to everyone for your help, especially Karen working unofficially when she could have been down the pub 

                   

                  Our issue seems to be resolved, although we can't see the Outbound service running at all in the event log!

                   

                  We will reboot the relevant server over the weekend.

                   

                  We know it must be running and we know it's got the correct configuration for logging.  We also know it's not running from another server.

                   

                  Very strange.

                   

                  Will post back when we find out what actually happened.

                   

                  Excellent support as always.

                   

                  Cheers.