#64769 Incident ID:15575 - *MRP Failure

open
nobody
None
5
2011-08-31
2011-08-31
omfgppc
No

Description:

Mfg 3.73. Setup items in bom's. Run bom->mass replace for an item. This "expires" the original item, and adds the new item. Run MRP - see error:
ERROR: stack depth limit exceeded
HINT: Increase the configuration parameter "max_stack_depth", after ensuring
the platform's stack depth limit is adequate.
CONTEXT: SQL statement "SELECT bomLevelByItem( $1 ) + 1"
PL/pgSQL function "bomlevelbyitem" line 13 at SQL statement

Steps to Reproduce:
To correct you must edit each affected bom - show expired components - right click on the expired components and delete it - after warnings it will delete, once the expired items are actually deleted, MRP runs correctly.

Additional information

For the entire bug information, please visit

http://www.xtuple.org/xtincident/view/bugs/15575

Discussion