Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you try to print the Historical Aged Trial Balance report in Microsoft Dynamics GP: "Unable to close table; DBMS: 208, dynamics: 0"

Error message when you try to print the Historical Aged Trial Balance report in Microsoft Dynamics GP: "Unable to close table; DBMS: 208, dynamics: 0"

View products that this article applies to.

SYMPTOMS

When you try to print the Historical Aged Trial Balance report in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains, you receive the following error message:

Unable to close table; DBMS: 208, Dynamics: 0

This problem occurs even after you re-create the reports dictionary (reports.dic) and delete the DEX_LOCK table and the DEX_SESSION table from the tempdb database in SQL Query Analyzer.

Additionally, the following error message may be logged in the Dexsql.log file:

You cannot run SELECT INTO in this database. The DBO would have to run sb_dboption to enable this options.

↑ Back to the top

CAUSE

This problem occurs if the options for the tempdb database properties are set incorrectly.

↑ Back to the top

RESOLUTION

To resolve this problem, modify the tempdb database properties. To do this, follow these steps:
1. Start SQL Enterprise Manager. To do this, click Start , point to All Programs , point to Microsoft SQL Server , and then click Enterprise Manager .
2. Expand the server that is running Microsoft SQL Server, expand Databases , right-click the tempdb database, and then click Properties .
3. Click the Options tab.
4.

Follow the appropriate step:

• In Microsoft SQL Server 7.0, make sure that the Select Into/Bulk Copy check box is selected, and then click OK .
• In Microsoft SQL Server 2000, make sure that Simple is selected in the Model list in the Recovery area. Then, click OK .



     
5. Print the Historical Aged Trial Balance report.

↑ Back to the top

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE. 

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS. 

↑ Back to the top

Keywords: kbFreshness2007, kbEntireNet, kbExpertiseBeginner, BemisKB850017, kbMBSPartner, kbtshoot, kbprb, kbMBSgp10, kberrmsg, kbnosurvey, kb, kbMBSMigrate

↑ Back to the top

Article Info
Article ID : 850017
Revision : 2
Created on : 3/9/2017
Published on : 3/9/2017
Exists online : False
Views : 288