tsStoreDBRec Error - LawsonGuru.com - LawsonGuru.com Forums -

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

SRH

New Member

Posts: 2

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: 3366

New Poster

Engaged Reader

Avid Reader

10/23/2008 12:40 PM

I am moving this to the S3 Financials forum--this is not M3.

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

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.

SRH

New Member

Posts: 2

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: 3366

New Poster

Engaged Reader

Avid Reader

10/23/2008 7:07 PM

No. You need to change the program to delete the existing record and add a new record.