Dynamics Community Forum Thread Details

Where is GP Workflow information stored? We did a restore on GP and SharePoint databases but still cannot re-create the PO's that happened between the backup and the restore.

The problem we are experiencing is when we do a Restore, we cannot re-create the “lost” documents (those that were created since the last backup).

For example, we did a backup when the last PO number was PO-123.
Create new PO's PO-124, 125, etc. up to PO-130.

Do a restore. GP will be at PO-123 again.

Try to re-create PO-124 and onward. When we "Submit" the re-created PO, we get a workflow failed error message.
We tried deleting the document records from the workflow website, and also restored the SharePoint databases. For some reason, GP will create PO number 124, 125 etc. but cannot Submit them for Approval. By manually changing the PO number to PO-131, I was able to Submit for workflow approval.

We would like to re-create “lost” POs with the same number. What if a PO went to a Vendor and when we do a backup that PO cannot be re-created?

Any assistance would be appreciated. Thanks in advance.

Hello Jocelyn,

I would love to find a solution for this but unfortunately nothing can recover these orders and there is no technical explination fo this, SharePoint is treating the Purchase Order from GP as a "document" and all the document information is saved in one field inside the SharePoint content database as an XML string.

Personally I tried hard to recover a Purchase Order in the SharePoint database but I been unable to do so, however this shouldn't make a problem to you, if the orders were sent to vendors, then it should been got approved and therefore you can go to the SQL, POP10100 table and change the workflow status from there to approved, for other purchase orders that was not yet approved, you will need to cancel all from GP and recrete them with new numbers to be resubmitted to the workflow and go through your users.

Hope that this helps.

Quick Links