Prev
Next
Forums Financial Management Lawson S3 Financials

tsStoreDBRec Error

 4 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
SRH
New Member
Posts: 2
New Member
10/23/2008 1:35 AM

    We just upgraded from Laswon 8.x to 9.x on both our Apps and env.  We are receiving this error meesage when we try to update our AM information:  tsStoreDBRec error is Key Change not allowed (32).  I know that this deals with the indexes because this was found in the ladb.log log files: 
    Wed Oct 22 13:15:21 2008: [c:\lsftest\law\test\obj\AM604]
    The program attempted to change the value of a field
    which is used by a 'no key change' index.
       file: AMASTMXVAL index: MXTSET2 field: MX-VALUE
       original value:  '19000101                        '
       changed value:   '20081020                       

    I can't find where to make this change.  I have verified that all 3 items in the attribute table are part of an index.  The error happens when the value of the Z-LAST-INV or USER attributes need to be changed.  If you can let me know where this change needs to be made I will make it.  Any help would be great :-)

    We are running in a Windows 2003 environment using SQL 2007.

    Thanks for the help :-)



    SRH


    John Henley
    Posts: 3353
    10/23/2008 12:40 PM
      I am moving this to the S3 Financials forum--this is not M3.
      Thanks for using the LawsonGuru.com forums!
      John
      John Henley
      Posts: 3353
      10/23/2008 1:16 PM
        Is AM604 a custom program (I've never heard of it...)? If so, you would need to change it to delete the existing AMASTMXVAL record, and add the new one. LSF9 is less forgiving of 'no key change' indexes.
        Thanks for using the LawsonGuru.com forums!
        John
        SRH
        New Member
        Posts: 2
        New Member
        10/23/2008 7:02 PM
          Yes it is a custom program. So, I need to remove the AMASTMXVAL indexes from SQLand then create new indexes with the same names?
          John Henley
          Posts: 3353
          10/23/2008 7:07 PM
            No. You need to change the program to delete the existing record and add a new record.
            Thanks for using the LawsonGuru.com forums!
            John