The stack itself is rarely the problem, sql scripts and triggers in these kind of systems as op says is not properly version controlled or documented. In a refactor or revamp these are discovered along the way