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 occurs when you print the Print 1099s report in Microsoft Dynamics GP Payables Management: "Another User is Printing or Calculating 1099s"

Error message occurs when you print the Print 1099s report in Microsoft Dynamics GP Payables Management: "Another User is Printing or Calculating 1099s"

SYMPTOMS

When you try to print the Print 1099s report in Microsoft Dynamics GP, you may receive the following error message:

Another user is printing or calculating 1099s.

This issue occurs even though there is no one else logged in Microsoft Dynamics GP.

↑ Back to the top

CAUSE

This issue may occur if records are stuck in the following tables:

• In the DYNAMICS database:  ACTIVITY, SY00800, SY00801


• In the TEMPDB database:  DEX_LOCK, DEX_SESSION

↑ Back to the top

RESOLUTION

Note The following steps will require you to run update scripts through the Microsoft SQL Server query tool. We recommend that you create a backup of your data before you follow these steps.
1. Have all users exit Microsoft Dynamics GP.
2. Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.

Method 1: For SQL Server Desktop Engine

If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, click Start , point to All Programs , point to Microsoft Administrator Console , and then click Support Administrator Console .

Method 2: For SQL Server 2000

If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start , point to All Programs , point to Microsoft SQL Server , and then click Query Analyzer .

Method 3: For SQL Server 2005

If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start , point to All Programs , point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio .
3. Run the following scripts in the query window: 
DELETE DYNAMICS..ACTIVITY 
DELETE DYNAMICS..SY00800 
DELETE DYNAMICS..SY00801 
DELETE TEMPDB..DEX_LOCK 	
DELETE TEMPDB..DEX_SESSION
4. Log on to Microsoft Dynamics GP, and then print the Print 1099s report.

↑ Back to the top

Keywords: kb, kberrmsg, kbtshoot, kbprb, kbMBSPartner, kbMBSMigrate, BemisKB859915

↑ Back to the top

Article Info
Article ID : 859915
Revision : 1
Created on : 3/1/2017
Published on : 3/1/2017
Exists online : False
Views : 91