When running a SmartConnect map to create a Purchase Order Document, receiving an error that says, “Invalid Object name ‘PA01901′”.
This is cause by Microsoft PR 60024 which is resolved in the year end service pack releases of GP 10 and GP 2010. In order to resolve the issue, you need to do one of the following two items.
1. Update to the latest service pack for GP 2010
2. Perform the following workaround
a. Go to SQL Server Management Studio, expand out TWO and Tables, right click on PA01901 and Script Table As – Create to – New Query.
b. Change the USE statement at the top of the query to your company database instead of TWO.
c. Add the following line to the end of the script: grant all on PA01901 to DYNGRP
d. Click Execute