SY_Message corrupted during upgrades to v2021.1

SOLVED

I see this on two new upgrades to v2021.1 Standard (both on SPC, but that may just be a co-incidence).

Edit a Role and I get this prompt when saving: (SY_RoleApply.Y2)

But this is what I "should" see:

Similarly, with the Document Date warning feature enabled, the user sees this: (SY_DocDateWarn-B.Y2)

When they should see something like this:

Poking around (comparing files with a pre-upgrade folder copy) I can clearly see records missing from the post-migration system.

Questions:

  • Is it safe to copy this file from backup into the Live system?
  • Are there any other files I need to consider as part of this fix?
  • Do I have to be concerned with Enhancements potentially writing custom messages to this table?
  • Can this be documented / fixed?

(Let me know if I need to create a case... at this point I am surprised there is not already a KB article).

Parents
  • 0

    - I missed this earlier.  Yes please create a case for this (if you haven't already).  The message library itself (SY_Message.M4T) could be swapped out from the old system, but may be missing any NEW messages that may have been created.  Depending on the enhancement, a developer modificaiton may also include messages as well.  Sounds like this table did not get merged properly as part of the installation.  

    Also, let me know when you have a case# and I'll chase it down from my side.

    Elliott

  • 0 in reply to jepritch

    Thanks Elliott.  Case created for one of the affected customers.  I just linked it to this thread instead of explaining things again in the case notes.

    (8008872193).

  • 0 in reply to Kevin M

      - This looks like it's isolated to SPC installations.  Do your affected customers have any developer mods?  If not, I'll look at getting you a new message library table and reach out to you.

    Elliott

  • 0 in reply to jepritch

    That is odd.  Why would SPC migration programming be different from normal Sage 100?  Expressionless

    Looking at our v2020 SPC customers and it seems fine there, so just v2021 then.

    I checked and we have at least one more customer affected.  The first two have no enhancements, and the third has DSD Multi-currency (a few modules).

    There is a fourth upgrade to SPC in process, which is a bit of a weird one, with the source system not having enhancements, but they are adding PM, which could add rows to the table I assume.

  • 0 in reply to Kevin M

    G'day

    There are specific SPC modifications made in the Hot Fix applied to the site.

Reply Children