Dynamics Community Forum Thread Details

Damaged SQL database causing Bank Transfer error message

I am recovering a GP database after a hard drive crash and the one remaining issue is this message when posting a bank transfer. This happens when closing the screen. A ledger entry is created. I have corrected the CM2020 table and the CM00100 tables. What other tables are involved in this process?

Categories:

Microsoft Dynamics GP

Hi Richard,

I see this error can be caused by a number of things. Some issues I am seeing on prior cases are 'memory' issues, or indexes damaged or missing on tables (See #4 below). You may need to make dexsql.log or SQL trace of the error happening to see what table it last looked at before the error, in order to know what table to focus on.

I see you had another post on this same issue, so am copying in my reply to that one below as well:

Here are some troubleshooting steps you can try and test in-between: (make a current backup first please.) (steps in no particular order).

1. Stop and restart the SQL server. (refresh the temp tables)

2. Check activity tables. When all users are logged out of GP, all of these tables should be empty: (maybe something locked in the tempdb dex tables)

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_LOCK

SELECT * FROM TEMPDB..DEX_SESSION

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

**Make a current backup before doing the next steps or do in a test company first (if the issue can be recreated):

3. In GP, go to Microsoft Dynamics GP/Maintenance/ Check links. Under Financial, insert over 'CM Setup' and 'CM Transaction' and click OK. Test again.

4. In GP, go to Microsoft Dynamics GP/Maintenance / SQL. Select the company database. Find 'CM Transaction'. click the bottom two options to drop/recreate the auto procedures. Repeat for the 'CM Transfer' table. If this doesn't work, you can do all 6 options on the right, but you must have backups of these tables so you can insert the data back in when you are done as the data is lost in these tables, or use the PSTL Tookit to recreate these tables, as this tool has the option to 'recreate data for selected table' so you don't lose the data. Using the GP/SQL option, you will have to insert the data back in. You need to have all users out of GP when doing either option.

If any questions or this doesn't work, it would be best to open a support case (installation) with Microsoft to get additional assistance.

Thanks,

Cheryl W.

Microsoft Support - Applications

Quick Links