Issues with workflow causing: RollbackException: Transaction "rolled back" because transaction was set to RollbackOnly.

OL Connect Professional Workflow
1

Hi,

Created a new workflow which is started by an ‘Input from Sharepoint’, a quick script to change some variables then handing these variables to create a datamapper/content that does very little. The overall aim is to ‘stamp’ some of the variables in a white box in the top left corner of a pdf invoice in order to be processed by a team more quickly.

Whether run in debug mode with a local pdf, or one taken from sharepoint it is giving the error message below:

INFO : 14:25:10.924 The SharePoint document “http://dennis/doit/Purchase Orders/4075578_cbottaway.pdf” was successfully deleted
INFO : 14:25:10.925 File captured : http://dennis/doit/Purchase Orders/4075578_cbottaway.pdf, size: 374496 bytes
INFO : 14:25:11.103 Plugin Input from SharePoint completed successfully - 14:25:11 (elapsed time: 00:00:02:862)

INFO : 14:25:11.103 JobInfo/Variable %{FileName} is set to “4075578_cbottaway”
INFO : 14:25:11.103 Plugin Set Job Infos and Variables completed successfully - 14:25:11 (elapsed time: 00:00:00:000)

INFO : 14:25:11.103 Run embedded script…
INFO : 14:25:11.104 Data file processed : job0100OOX0H14C74F30E543DC.dat, size: 374535 bytes
INFO : 14:25:11.104 Plugin Run Script completed successfully - 14:25:11 (elapsed time: 00:00:00:001)

INFO : 14:25:11.114 Sending file data source…
INFO : 14:25:11.497 Sending data mapping command…
WARN : 14:25:11.499 Cached version not available, attempting to upload file.
ERROR: 14:25:14.097 W3001 : Error while executing plugin: HTTP/1.1 500 Internal Server Error LoggedApplicationException: There was an error running the data mapping process caused by RollbackException: Transaction “rolled back” because transaction was set to RollbackOnly. (SRV000012)
ERROR: 14:25:14.098 Execute Data Mapping: W1603 : Plugin failed - 14:25:14 (elapsed time: 00:00:02:994)

Are there any ideas as to what has gone wrong? Image of current workflow below:

2

Shooting in the dark here, but that sounds like a Database error. Are the MySql / MS SQL portions of the Connect setup correct? The “database connection” settings within Connect Server Configuration are what I’m thinking of.

3

First thing to do is to grab that specific PDF file, import it into the DataMapper and click the Validate records option (in the Data menu). This should tell you if there’s an error when data mapping that file. if there is, you should be able to spot the issue and fix it.

4

Are you using an Microsoft SQL server as your database?

Which version of PReS Connect are you using?

5

Hi, They work for all the others (including the mirror of this workflow). Looking at it in comparison to the other similar workflows, it seems like it is an issue with how the file is being created in SharePoint and PlanetPress taking it too early.

Will update for completion if I get the full answer.

6

Unfortunately there was no issue with the file itself. It looks like it may be an issue with the file being created by SharePoint Web Services.

7

Yes to MS SQL, currently using 8.6

Thinking it may have something to do with SharePoint webservices (which imports the file) at the moment. If I get to the bottom of it, I will message back for completeness.

8

Do you know how many records in your Datamapper when this problem occurs?

There is a known limitation using MS SQL that cannot overgo 2100 records. It could be the case here. If it is, this is fixed in upcoming Connect 2018.1 version. In the mean time, you could use MySQL until the upgrade to 2018.1 is done.