Problem: System Message 501 Could not find stored procedure ‘frx_insert_acct_code when trying to close General Ledger. User is no longer using FRx.
Cause: The listed stored procedure is missing and is being referenced by an FRx trigger.
Resolution: Since FRx is no longer being used, remove the FRx triggers.
--Run against every Application Database
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'frx_insert_acct_code' AND type = 'P')
DROP PROC frx_insert_acct_code
GO
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'frx_initial_glx_build' AND type = 'P')
DROP PROC frx_initial_glx_build
GO
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'frx_account_update' AND type = 'TR')
DROP TRIGGER frx_account_update
GO
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'frx_accthist_insert' AND type = 'TR')
DROP TRIGGER frx_accthist_insert
GO
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'frx_gltran_insert' AND type = 'TR')
DROP TRIGGER frx_gltran_insert
GO
--Run against the System Database
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'frx_acctsub_update' AND type = 'TR')
DROP TRIGGER frx_acctsub_update
GO