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.

CAUSE

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

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.

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. 

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×