Identify Infinite Recursion in Product Structure

From KeystoneIntranet
Revision as of 00:01, 10 January 2017 by Intra>User (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Product Cost Rollup will report an infinite recursion error when a compenent code is the same as an assembly code.

Identify:

select * from artprstr
where assy_product_code=comp_product_code

Aggressive fix:

DELETE from artprstr
where assy_product_code=comp_product_code