Dynamics Community Forum Thread Details

Error: An open operation on table PM_RemitTo_TEMP has an incorrect record length message

Hi,

I have a user when she selects the vendor documents in the 'Edit Payables Check Batch' indow she is getting the following error message

'An open operation on table PM_RemitTo_TEMP has an incorrect record length message'

and has to get out

ofGreat Plains and go back in to select the documents she needs. She has to do
this several times before she can proceed.

Any suggestions would be appreciated.

Deb

Hello Deborah,

Not sure if you've resolved this yet, but usually when we're looking at TEMP table errors, it has to do with corrupted or damaged temporary tables, which are held in the TEMPDB database when Dynamics GP uses them.

Normally, Dynamics GP will create temp tables and stored procedures when it's doing anything from transactions to reports and then when it's finished with these temp objects, it drops them, but sometimes they don't get dropped correctly and that can potentially cause issues.

The best way to manually drop these temp objects is to have all users log out of Dynamics GP and the SQL Sever instance, then stop and restart the SQL Service, which will drop all temp objects as well as drop all connections to SQL Server.

Once this is done, start the SQL Service again, and then have users login to Dynamics GP and verify whether they get this type of error message again or not.

Thanks,

Quick Links

Leaderboard