If
you have the new or upgraded Infor CRM 8.2.0 database, you may have
noticed that adding & editing picklists causes an error. This is a
defect in the system. The good news is, there’s a workaround – but don’t
try this at home, kids! The procedure requires knowledge of Microsoft
SQL Server and/or Transact SQL, so if you’re not a database
administrator, pass this along to someone who is so they can properly
implement the changes. They’ll need to back up all systems and
application databases before making any changes to the tables, just to
be safe.
Here are the steps for the workaround:
- Open the SITEKEYS table
- Locate the row where SITEKEYS.KeyType is 30
- Increment the SITEKEYS.KeyValue value for that column so it is higher than the maximum value in the PICKLIST.ItemID
- Ex: if the current value in PICKLIST.ItemID is A00014O increment SITEKEYS.KeyValue to A00114O
And voila! You should now be able to add and edit picklists. If
you’re still running into problems, contact your next level of Infor CRM
customer support. Good luck!
Posted in: