DBMS:512, Dynamics:0
Marquez@discussions.microsoft.com Rose Marquez
following results DBS:512, Microsoft Dynamics GP:0 when posting GL and
payables transactions and voiding transactions.
Any idea what's causing this?
Thanks.
Rose
Leeland Clay
players so that other team doesn't beat them so badly :P
Do you get any other errors before or after this one? From the looks of it
the posting process isn't completing any of the posts. Something global may
be askew in the database causing this. Run a Check Links and see if that
helps.
Rose Marquez
"[Microsoft ODBC SQL server driver][SQL Server] subquery returned more than
1 value. This is not permitted when the subquery follows =,!=,<,<==,>,>= or
when the subqueyr is used as an expression"
After clicking the ok button, following error appears:
The stored Procedure glpPostBatch returned the following results DBMS:512,
Microsoft Dynamics GP:0
It only happens during batch posting. No error occurs during trx level
posting. Transactions are posting ok even with the error. There are several
companies but this error happen only on 1 company, when the company was
created I copied the setup and masterfiles from an existing one. I followed
the tables mentioned on techknowledge re: copying setup and masterfiles.
I've run checklinks and reconcile several times, no errors found.
VinceV
the values when you copied the setup and masterfiles to create the company
that generates the error.
You can use the SQL Query Analyzer to look at the stored procedure to narrow
down the tables you need to check. Unfortunately that particular stored
procedure references a lot of tables.
Which version of GP are you using?
MichaelJ
Batch Headers (SY00500) table and clear your Batch Activity
(DYNAMICS.dbo.SY00800). The glpBatchCleanup stored proc selects mostly
from these 2 tables. If you have some bad data in one of them it could
return results you describe.
You can clear the Batch Activity table by running DELETE
DYNAMICS.dbo.SY00800 when there are not any users in the system.
Rebuilding the SY00500 table is more challenging and you will need to
reconcile transactions in each modules to have the Batch Header
recreated after running DELETE SY00500 against your company database.
There's a TK that describes a couple of ways to do this:
To re-create the SY00500 - Posting Definitions Master table. To
re-create this table, use one of the following methods.
Method 1: Use SQL Maintenance
1. Make a full backup of Microsoft Great Plains.
2. Click File, click Maintenance, and then click SQL.
3. Click the company database that is receiving the error.
4. In the Table list, click Posting Definitions Master.
5. On the right side of the window, click to select every check box,
and then click Process.
6. When you receive the following message, click Yes:
You have selected to drop tables; this will delete any data in them.
Are you sure you want to continue?
This procedure re-creates the SY00500 - Posting Definitions Master
table. However, you will temporarily lose all unposted batches. To
retrieve these unposted batches, run the Check Links program on the sub
modules. Then, reconcile the batches for Microsoft Great Plains General
Ledger. However, this sets any batches that are set to Recurring to
Single Use. You must change these batches back to Recurring.
To retrieve the batches, follow these steps.
Note If you use the Multicurrency option in Microsoft Business
Solutions - Great Plains Payables Management, run the Check Links
program on the Payables Transaction History Logical file before you run
the Check Links program on the Payables Transaction Logical file. 1. To
run the Check Links program on the following files, click File, click
Maintenance, click Check Links, click one of the following series
names, and then type the corresponding file name. Follow this step for
the following files:· Series name: Payables Management
File name: Purchasing Series - Payables Transaction Logical
· Series name: Purchase Order Processing
File name: Purchasing Series - Purchasing Transaction Logical
· Series name: Receivables Management
File name: Sales Series - Receivables Open Transaction
· Series name: Invoicing
File name: Sales Series - Invoice Work File
· Series name: Sales Order Processing
File name: Sales - Sales Work File
· Series name: Inventory
File name: Inventory - Inventory Transaction Work file
· Series name: Bill of Materials
File name: Inventory - Inventory - Bill of Materials Transactions file
2. If you use Microsoft Great Plains Project Series (PS) Time &
Expense, you must also run Check Links on the following files. To run
Check Links on the following files, click File, click Maintenance,
click PS Checklinks, and then click one of the following file names.
Follow this step for the following files:· Timesheet Batches - PS
Timesheet Transactions
· Asset Log Batches - PS Asset Log Transactions
· Expense Log Batches - PS Expense Log Transactions
· Inventory Transfer Batches - PS Inventory Transfer Transactions
· Purchase Order Batches - PS Purchase Order Transactions
· Series name: Vendor Invoice Batches - PS Vendor Invoice
Transactions
· Employee Expense Batches - PS Employee Expense Transactions
· Billing Batches - PS Billing Time & Materials Transactions
3. If any batches exist in Microsoft Great Plains General Ledger, click
Tools, point to Utilities, point to Financial, and then click
Reconcile. Click Batches , and then click Reconcile to reconcile your
batches.
Method 2: Use the free toolkit from Professional Services Tools Library
1. Make a full backup of Microsoft Great Plains.
2. Have all users log off from the system.
3. Install the Professional Services Tools Library (PSTL). To do this,
visit the following CustomerSource Web site:
https://mbs.microsoft.com/Customersource
Note This download is located under Downloads and Updates. Installation
instructions are included with the download.
4. After you install the PSTL, start Microsoft Great Plains. When you
are prompted to include new code, click Yes.
5. Log on to Microsoft Great Plains as the system administrator (sa).
6. Click Add, click Other Window, expand Technical Service Tools,
expand Project, click Professional Tools Library, click Add, and then
click Done.
Note This step adds Professional Services Tools Library to the shortcut
bar.
7. On the shortcut bar, click Professional Service Tools. Wait for the
SQL objects build. When you are prompted to enter registration keys,
click Cancel. You do not need registration keys to use this tool.
8. Click Toolkit, and then click Next.
9. Under Toolkit Options, click Recreate SQL Objects, and then click
Next.
10. Next to Series, click Company.
11. Next to Table, click SY00500.
12. Under Maintenance Options, click to select the Recreate Selected
Table check box, and then click to select the Recreate data for
selected table(s) check box.
13. Click Perform Selected Maintenance.
14. When you receive the following messages, click OK:
Table will be recreated with data
SY00500 table will be recreated with data. Verify a backup has been
made before proceeding
SY00500 has been recreated
There are more TK docs on similar issues such as:
Issue
Error - 'The stored procedure glpBatchCleanup returned the following
results: DBMS:0, eEnterprise: 20544' occurs when trying to post a batch
in Microsoft Business Solutions - Great Plains General Ledger.
Potential Cause
A Primary Constraint is missing from the SY00800 (batch activity).
Resolution
Re-create the indexes for the table SY00800.
1. Install the Professional Services Tools Library.
The Professional Services Tools library can be obtained on the
CustomerSource Web site. To locate the library, search in the Search
CustomerSource for box. For the search criteria, type Professional
Services Tools Library Great Plains X, where X is the appropriate
version of Microsoft Great Plains.
To install the tool, follow the detailed installation document that is
included with the Professional Services Tools Library file.
2. Click on the Professional Services Tools Library link from your
Shortcuts tab, and then choose to enable Toolkit. The Toolkit window
will appear.
3. Select to Recreate SQL Objects from the Toolkit window, then click
Next.
4. Select System for the Series and SY00800 for the table.
5. Under the Maintenance Options, select to Rebuild Indexes for the
Selected Table. Note - Verify that no one is posting or editing a batch
when the indexes are being recreated for this table. The SY00800 table
has a record in it any time a user is editing or posting a batch in any
module.
6. Click on Perform Selected Maintenance button to recreate the
indexes.