batch recovery failure

Hi,

I posted a payables batch and it gave me an error and instructed me to use 
batch recovery. When I tried to recover the batch I get the following message:

The stored procedure icpmValidateIC returned the following results: DBMS: 
512, Microsoft Dynamics GP: 0.

Anybody know what I have to do next?

Thanks.
0
10/20/2008 10:31:01 AM
greatplains 29623 articles. 3 followers. Follow

3 Replies
929 Views

Similar Articles

[PageSpeed] 41

This is telling you that the stored procedure in question executed an action 
that resulted in more than one value being returned -- typically a SELECT 
statement that attempts to assign its resultset to some variables, something 
like SELECT @x = foo_column from footable. In this case the SELECT is 
returning more than one value that is trying to be assigned to @x throwing an 
error 512.

Unfortunately, there is no easy fix for this without knowing the details of 
your environment, but I would try to run the Automated Solutions designed to 
deal with batch issues:

Dynamics GP v10 (ClearBatchActivity10_v1.msi in System Manager's section)
https://mbs.microsoft.com/customersource/support/selfsupport/automatedsolutions/automatedsolutionsR10.htm

Dynamics GP v9 (Clear Batch Activity v9.2.msi in System Manager's section)
https://mbs.microsoft.com/customersource/support/selfsupport/automatedsolutions/automatedsolutions9plus.htm

Once you have recovered the batch, run a batch edit list looking for any 
error messages on transactions that would prevent the batch from posting, for 
example, close fiscal periods, etc.

If you cannot seem to find the problem, move the transactions from the 
damaged batch to a new batch. At this point, I would also clear the 
wkPostingValidationState table and the pJournal table located under your 
company database (MAKE A BACKUP AND HAVE EVERYONE EXIT THE SYSTEM BEFORE 
TRYING THIS).

If this still does not resolve the issue, then make sure you are on the 
latest service pack for your version of Dynamics GP. 

If after applying the service pack you are still experiencing the issue, 
turn on a DEXSQL.LOG. You can install the new Support Debugging Tool which 
you can obtain from your partner. In turn, they can download from 
PartnerSource. In any case, the DEXSQL.LOG will allow you to pinpoint the 
specific SQL transaction that is causing the issue.

Last but not least, if none of the above resolves the issue, delete and 
re-enter the batch.

Good luck,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com


"Jacob Raymond" wrote:

> Hi,
> 
> I posted a payables batch and it gave me an error and instructed me to use 
> batch recovery. When I tried to recover the batch I get the following message:
> 
> The stored procedure icpmValidateIC returned the following results: DBMS: 
> 512, Microsoft Dynamics GP: 0.
> 
> Anybody know what I have to do next?
> 
> Thanks.
0
MarianoGomez (3440)
10/20/2008 2:36:03 PM
Thanks Mariano,

We are running GP 10 professional version 10.00.1061 on MS SQL 2005 
9.00.3042.00 (X64). The OS on the server is running MS windows 2003 R2 64 
bit. All the client systems are running windows vista with the latest service 
pack.

I did try the Automated Solutions related to batch issues but that didnt 
solve the problem. I am still stuck with a batch I cant recover. Would it be 
safe to delete the entries from the tables using sql?

Regards.

Jacob.

"Mariano Gomez" wrote:

> This is telling you that the stored procedure in question executed an action 
> that resulted in more than one value being returned -- typically a SELECT 
> statement that attempts to assign its resultset to some variables, something 
> like SELECT @x = foo_column from footable. In this case the SELECT is 
> returning more than one value that is trying to be assigned to @x throwing an 
> error 512.
> 
> Unfortunately, there is no easy fix for this without knowing the details of 
> your environment, but I would try to run the Automated Solutions designed to 
> deal with batch issues:
> 
> Dynamics GP v10 (ClearBatchActivity10_v1.msi in System Manager's section)
> https://mbs.microsoft.com/customersource/support/selfsupport/automatedsolutions/automatedsolutionsR10.htm
> 
> Dynamics GP v9 (Clear Batch Activity v9.2.msi in System Manager's section)
> https://mbs.microsoft.com/customersource/support/selfsupport/automatedsolutions/automatedsolutions9plus.htm
> 
> Once you have recovered the batch, run a batch edit list looking for any 
> error messages on transactions that would prevent the batch from posting, for 
> example, close fiscal periods, etc.
> 
> If you cannot seem to find the problem, move the transactions from the 
> damaged batch to a new batch. At this point, I would also clear the 
> wkPostingValidationState table and the pJournal table located under your 
> company database (MAKE A BACKUP AND HAVE EVERYONE EXIT THE SYSTEM BEFORE 
> TRYING THIS).
> 
> If this still does not resolve the issue, then make sure you are on the 
> latest service pack for your version of Dynamics GP. 
> 
> If after applying the service pack you are still experiencing the issue, 
> turn on a DEXSQL.LOG. You can install the new Support Debugging Tool which 
> you can obtain from your partner. In turn, they can download from 
> PartnerSource. In any case, the DEXSQL.LOG will allow you to pinpoint the 
> specific SQL transaction that is causing the issue.
> 
> Last but not least, if none of the above resolves the issue, delete and 
> re-enter the batch.
> 
> Good luck,
> --
> MG.-
> Mariano Gomez, MIS, MCP, PMP
> Maximum Global Business, LLC
> http://www.maximumglobalbusiness.com
> The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> 
> 
> "Jacob Raymond" wrote:
> 
> > Hi,
> > 
> > I posted a payables batch and it gave me an error and instructed me to use 
> > batch recovery. When I tried to recover the batch I get the following message:
> > 
> > The stored procedure icpmValidateIC returned the following results: DBMS: 
> > 512, Microsoft Dynamics GP: 0.
> > 
> > Anybody know what I have to do next?
> > 
> > Thanks.
0
10/21/2008 5:50:01 AM
I forgot to add, we are using the Analytical Accounting module too.

Regards.

Jacob.


"Mariano Gomez" wrote:

> This is telling you that the stored procedure in question executed an action 
> that resulted in more than one value being returned -- typically a SELECT 
> statement that attempts to assign its resultset to some variables, something 
> like SELECT @x = foo_column from footable. In this case the SELECT is 
> returning more than one value that is trying to be assigned to @x throwing an 
> error 512.
> 
> Unfortunately, there is no easy fix for this without knowing the details of 
> your environment, but I would try to run the Automated Solutions designed to 
> deal with batch issues:
> 
> Dynamics GP v10 (ClearBatchActivity10_v1.msi in System Manager's section)
> https://mbs.microsoft.com/customersource/support/selfsupport/automatedsolutions/automatedsolutionsR10.htm
> 
> Dynamics GP v9 (Clear Batch Activity v9.2.msi in System Manager's section)
> https://mbs.microsoft.com/customersource/support/selfsupport/automatedsolutions/automatedsolutions9plus.htm
> 
> Once you have recovered the batch, run a batch edit list looking for any 
> error messages on transactions that would prevent the batch from posting, for 
> example, close fiscal periods, etc.
> 
> If you cannot seem to find the problem, move the transactions from the 
> damaged batch to a new batch. At this point, I would also clear the 
> wkPostingValidationState table and the pJournal table located under your 
> company database (MAKE A BACKUP AND HAVE EVERYONE EXIT THE SYSTEM BEFORE 
> TRYING THIS).
> 
> If this still does not resolve the issue, then make sure you are on the 
> latest service pack for your version of Dynamics GP. 
> 
> If after applying the service pack you are still experiencing the issue, 
> turn on a DEXSQL.LOG. You can install the new Support Debugging Tool which 
> you can obtain from your partner. In turn, they can download from 
> PartnerSource. In any case, the DEXSQL.LOG will allow you to pinpoint the 
> specific SQL transaction that is causing the issue.
> 
> Last but not least, if none of the above resolves the issue, delete and 
> re-enter the batch.
> 
> Good luck,
> --
> MG.-
> Mariano Gomez, MIS, MCP, PMP
> Maximum Global Business, LLC
> http://www.maximumglobalbusiness.com
> The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> 
> 
> "Jacob Raymond" wrote:
> 
> > Hi,
> > 
> > I posted a payables batch and it gave me an error and instructed me to use 
> > batch recovery. When I tried to recover the batch I get the following message:
> > 
> > The stored procedure icpmValidateIC returned the following results: DBMS: 
> > 512, Microsoft Dynamics GP: 0.
> > 
> > Anybody know what I have to do next?
> > 
> > Thanks.
0
10/21/2008 5:55:01 AM
Reply:

Similar Artilces:

Delivery Failure after creating calendar event
> This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3205343077_45724 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Folks, Every time I Create a calendar event, I receive the following email: This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed. /O=First Organization/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=MKPSERVER/cn=Microsoft System Attendant Reporting-MTA: dns;mar...

recovery
had to recover my OS. No files were lost, and Money files were backed up to HD by default, but when I ask to restore from backup, no accounts show up. Help!! In microsoft.public.money, <icoczar@bellsouth.net> wrote: >had to recover my OS. No files were lost, and Money files >were backed up to HD by default, but when I ask to restore >from backup, no accounts show up. Help!! If no files were lost, use your latest *.mny file rather than a *.mbf. I wonder what the date and size are on the backup where no accounts show up. I worry that it is a really old backup that predate...

HidD_SetFeature Failure #2
Hi All, I'm new to HID class devices. I'm working on printers. I need to set the features on the printer. In HID class, i'm using HidD_SetFeature command for this. This is failing and when given GetLastError(), i get "The Semaphore Timeout period has expired". The part of code is #define PRINTER_SET_CONFIGURATION {0x1F...0x00,0x00} main() { BYTE bBuff[64] ; WORD wRead ; HANDLE h = openHid() ; if (h != INVALID_HANDLE_VALUE) { CheckDevice(h) ; BYTE bBuff[] = PRINTER_SET_CONFIGURATION; SetData_FeatureIn(h,4,bBuff) ; RecvData_FeatureIn(h,sizeof(bBuff),bB...

Payables batch entry problem
Hi everyone, Our payables dept has a problem with Payables Batch Entry where when they edit an existing or enter a new batch and then select computer check as the origin the post option gets grayed out. They're claiming it never was like that and that happened just recently. What could be the cause of it? I've checked the posting options under setup and nothing sticks out at me. I've also checked for stuck batches or anything that might be suspect. Thanks, -- Jim Bourque Jim, Cheque Batches do not get Posted from the Batch Entry Window, they need ...

Batch processing
I'm trying to program batch order processing for our company, but can't find info on how to do that with RMS. What would be helpful is diagram of the tables and fields that are updated when a transaction is closed. Or some documentation! Anyone know? ...

W2003, batch converter wizard: call from cmd (batch)
Hi, Working with Word 2003. I have installed the batch converter wizard and all is well. I would like to create a batch file that opens Word, calls the wizard and runs with a defined configuration, eg convert Word doc to xml, predefined source and target folders, select all. I can run a batch file to open the wizard, thus.. echo off "C:\Program Files\Microsoft Office\Templates\1033\Batch Conversion Wizard.Wiz" .... but I am still faced with manually selecting conversion type, sourc e and target folders, select all. I tried recording a macro calling the wizard a...

Missing Check Batch (Batch not hitting GL)
My client is on GP 8 and this happened 2 times already. Basically they post a batch of computer checks, they are set to post through to GL. They got an error about glpostcleanup and the batch became stuck in Batch Recovery. We 'freed' up the batch but afterwards it is nowhere to be found. The batch is not in Post Checks, not in GL Batches, not in SY00500. In both instances we had to post the checks in Bank Rec to GL. The checks did not hit BR either. This is starting to worry me. GP said to run the special upgrade procedure in GP Utilities and I ran this before my client ...

Previously Closed Bills in Quickbooks Reappear during RMS Batch Po
I am seeing previously posted and closed bills in Quickbooks Premier 2008 reappear during later posts of new batches from RMS. Anybody seen this one? Thanks, Richard ...

Creating a batch file for Inventory Adjustments
I'd like to import the results of our physical inventory into an Inventory Adjustment batch. Can someone explain how to do this? The batch will consist of approx 1,000 records. Are you using a stock count schedule? if so, there is no way to do this directly. You could directly import the data into the SQL table - Ask your partner for assistance in this if you are not a DBA. HS "MrMark" <MrMark@discussions.microsoft.com> wrote in message news:B88E26CD-2503-4844-9AA9-94003208556A@microsoft.com... > I'd like to import the results of our physical inventory into...

JET/ESE failure when backing up Exchange 2003 Online Stores
Hello, Operating System: Windows 2003 SBS Service Packs: Windows 2003 SP1, Exchange 6.5 SP1, Sharepoint SP1, SBS SP1. Prelim: When performing an online backup, the job fails, logging the following information. ============================= NTBackup Log: ----------------------------- Backup started on 30/07/2005 at 8:41 PM. The 'Microsoft Information Store' returned 'Error returned from an ESE function call (d). ' from a call to 'HrESEBackupRead()' additional data '-'The 'Microsoft Information Store' returned 'Error returned from an ESE function...

CRM Mobile Express login failure on smarphone
I setup CRM mobile express and have it working with an extenal ip address:81. I can access it from our network, outside of our network and on 2 other smart phones (Treo and Verizon phone both with mobile 5). When I try to access from a cingular 8125 mobile 5 phone it doesn't prompt me to login and thus fails. I am able to connect to the internet from this phone. I would gues that it is some browser setting but have searched through all the options and don't see anything different from other mobile phones that are able to bring up the site. HELP! Thanks! Greg Possibly a certificate i...

Re-number credit card batch for settling
Had a problem settling a credit card batch due to duplicate batch number. Credit card company (paymentech) keeps saying we have to re-number our batch. Batch is already gone as "settled" on my side. No error came back as "duplicate". Didn't know till we called processor. \ Also, would like duplicate receipt for debit card without a signature line and without pressing reprint. How to? Thanks Roxanne, Make a backup first. Do it again and store it somewhere else just to be safe. Contact Paymentech and find out what batch number they are looking for. *** CAUTION ...

revenue expense deferral, recurring batches
If there is a transaction that happens monthly - and there is a need to defer these, it will be very helpful is the RED feature can be available for use in recurring batches. Currently, this is not possible and it becomes inconvenient to keep on entering transactions that happen on a regular basis. Quick journals are no help as you can not defer transactions on them as well. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you...

Unable to recover Payables Batch through Batch Recovery.
We are unable to recover a Payables Batch we attempted to post by using Batch Recovery. When we get to the Batch Recovery screen we marked the Payables Batch and clicked on continue. When we did this we got the following error message "An open operation on table 'PM_Distribution_WORK_OPEN_TRX' has an incorrect record length." After clicking on OK we were prompted to return to Batch Recovery. When we returned to Batch Recovery we marked the Payables Batch again and clicked on continue. We then received a second error message that read as follows "An open opera...

batch marked for deletion
We have a batch that was accidentally partially deleted. we removed all sales from the batch to another batch and now when we try to delete the batch it says the batch is being edited by another user and yet it is not and it will not let us delete it from the sales batch window. Jeremey, You didn't indicate your version or platform, so this may or may not apply, but have you looked at the ClearBatchActivity.exe automated solution in CustomerSource? This generally will release the status of stuck batches, and its easy to run. Just be sure to read the notes carefully to be sure it ...

Task creation failure
Create new task, click "save and close". Error has popup,"Could not complete the operation. One or more parameter values are not valid." Longshot - Highlight the Task folder from the View menu make sure the Current View is set to simple list and then from the Actions menu select "Save Task Order". "Clyde" <clyde.jiang@sap.com> wrote in message news:01f201c3d8a8$d7e54ca0$a401280a@phx.gbl... > Create new task, click "save and close". > Error has popup,"Could not complete the operation. > One or more parameter values are not v...

Batch Invoice Entry
Hello, Please inform me about the following: wrt: 1 an invoice is saved in a batch from the window "Invoice Entry" 2. an invoice is saved in a batch from the window "Sales Transaction Entry" Now I would like to a. post the tranactions in the batch b. void the transaction. Hence, in case of 1 & 2 for a) & b) what are the tables that will be affected. I need to export these data using ODBC/trigger on these tables. Any help would be greatly appreciated. Thanking you in anticipation, Regards, Samik. ...

SOP Batches all going to batch recovery
Hello, I have an issue where a SOP batch always results in the: " batch was interrrupted while receiving data from another module and is available in the Batch Recovery Window." error. It is available batch recovery with a status of "Journal Printing Interrupted". Is this possibly a service pack issue? ...any ideas? thx, Doug -- Doug Wilson Great Plains Consultant MCS Canada When you recover it, does it complete posting or return to an unposted state? -- Charles Allen, MVP "Doug" wrote: > Hello, > > I have an issue where a SOP batch always...

Posted Batch
Hi, How can I see the posted batch, before posted? Than you Before posting the batch, click the printer icon at the top right of the window. This will show the batch as if it was posted, and if you have errors it will show them also. "Mauricio Ramirez" wrote: > Hi, > > How can I see the posted batch, before posted? > > Than you Thank you klewis, but I want to review after in a report or something like that, only to assure to me that batch was posted. Any suggestion? "klewis" wrote: > Before posting the batch, click the printer icon at the to...

Batches
I have an Invoice Entry batch that is not being used by anyone & yet it is marked with a Busy status. I cannot post this or change it. Any ideas? It sounds like the batch is locked. Check on partner source with specific version info and such. You will want to first try batch recovery and then likely have to adjust some table records based on partner source instructions related to your particular scenario. gl "New user" wrote: > I have an Invoice Entry batch that is not being used by anyone & yet it is > marked with a Busy status. I cannot post this or change ...

hal.dll mising on system restore/recovery
If I try and boot up in recovery mode I get some message, forget exact working but it says I think hal.dll is missing. I think it may say window/system32/hal.dll is missing. There is a hal.dll in the system32 directory on the main partition, should there be one on the recovery partition? Anyway whats the problem, the file is there apparently and the system boots up into normal mode so wtf can't it boot into recovery? "Colin Trunt" <colin@trunt.com> wrote in message news:pqMun.164583$7o6.143583@newsfe27.ams2... > If I try and boot up in recovery mode...

assertion failure on adding control variable
hi, i have placed an activex controll for real player on my dialog box. but when i run it after adding a member variable for the control, getting an assertion failure. it comes only when the dialog box is closed. no error comes after placing the control and then running it.error comes only if the member variable is added. could anyone tell me why this happens and how to solve it. thanks anu Since you don't tell us what the assertion failure is or where it occurs, it is sort of hard to guess what in the world you are talking about. Note that every assertion failure tells you all thi...

EDC batch missing
I have a customer that is able to process credit card successfully, but when they go to settle the EDC batch under utilites menu. There is no transactions to settle. I am able to run EDC report and it shows those transactions status open, but obivous they're missing in settlement screen. Thanks Dave Never mind. I'd fixed it by reindexing the database. Dave "DCR" wrote: > I have a customer that is able to process credit card successfully, but when > they go to settle the EDC batch under utilites menu. There is no transactions > to settle. I am able to run E...

Open Batches
I've used several RMS 1.3R "Manager" computers to temporarily test POS transaction. I no longer need to use these computers for POS but only for SO Manager. How do I get rid of the Open Batches that show up in SO Manger under Journal - Update Batch Info? As soon as I Z out the no longer used POS register(s) it automatically creates a new open batch for that register number. And these open batches show up in the Update Batch Info screen which confuses the (closing) Mangers. First of all, are your manager is performing Z out from SO Manager program ?? second you can just...

Upgrade failure release 10.0, duinstall.log
Hi, I'm trying to upgrade (on a test server) from release 9.0.362 to 10. I've downloaded release 10 from the web site, things go well until I try to run gputilities to upgrade the db's. Then I get the error referenced in kb 952054, Error message when you access Microsoft Dynamics GP 10.0 Utilities: "There was a problem ascertaining product version information. Microsoft Dynamics GP Utilities will now exit. Check DUinstall.log for more information" duinstall.log has the line: Failure encountered ON 7/9/2009 at 4:51:31 PM. Error: Product 0 does not support upgr...