• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

F4229 Update Contstraint Error

rkaras

Member
The sales update log shows an error -- unique constraint (proddta.f4229_1) violated when it tries to do an update on the F4229 table.

This constraint is:
--CREATE UNIQUE INDEX F4229_1 ON F4229(SSAN8, SMCU, SSDCTO, SSITM, SSLNTY, SSSRP1, SSSRP2, SSRP3, SSSRP4, SSSRP5, SSFY) TABLESPACE PRODDTAI PCTFREE 10 STORAGE(INITIAL 65536 )

It looks like the update SQL is trying to set many fields, including ssfy (fiscal year). The UPDATE SQL tries to set the fiscal year to 1 but the where clause doesn't specifiy a fiscal year so it is select 4 records for this particular customer -- for fiscal year 98,99, 0, and 1.

What is going on? Shouldn't the WHERE clause have a check to see if ssfy = 01? Otherwise it is trying to update the ssfy to 01 for all 4 fiscal years. How do I resolve this?
 
Top