Follow these steps to resolve the issue:
**Always make a current restorable backup before doing maintenance in SQL**1. Open
SQL Server Management Studio. To do this, click Start, click All Programs, click Microsoft SQL Server, and then click SQL Server Management Studio.
2. Click on the
New Query button to open a query window and select the Company database using the drop-down list.
3. Copy in the scripts below and execute to see the highest value in each table.
Select MAX(RETIREEVENT) from FA00700
Select MAX(RETIREEVENT) from FA41700
Normally the values should be the same. If they are different, this would case the error.
4. Usually the FA41700 is lower, so the next steps will show you how to insert in a dummy row into this table to correct this problem. The insert statement would be similar to the statement below.
a. Here is the syntax for the dummy row needed for the FA41700 table: (Do not run this exact script, as it will need to be modified first.)
Insert FA41700 values (Retirement event number,’Description’,'NOTEINDX,'Date 00:00:00.000','1900-01-01 TIME,'USERID')
b. Use the Insert statement above as a base and insert in dummy values to make a valid record. Here is an example of how it should look, but you can change any of the values per your preference. After modifying it, run this script against the company database.
Insert FA41700 values (XXX,’RETIREMENT RECORD','0.00000','2013-01-01 00:00:00.000','1900-01-01 09:56:28.000','sa')
--First, insert in the MAX event number you need from the FA00700 for the XXX placeholder.
5. Run the scripts in step 3 above again to make sure the maximum event number is now the same between the tables.
6. Log back into Microsoft Dynamics GP and see if the error still occurs.
7. If the error still occurs, ensure all users are out of Microsoft Dynamics GP and run these script to delete the system temp files: (Please make sure all users exit Microsoft Dynamics GP properly through the front-end, so you don't damage any work they may be in the middle of.)
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE DYNAMICS..ACTIVITY
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
8. It is also recommended to delete the contents of the two Fixed Asset temporary tables. Execute these scripts:
DELETE FA01500
DELETE FAINDEX
9. Log back into Microsoft Dynamics GP and see if you can retire without the error now.