Skip to main content
Inspiring
September 13, 2021
Question

Documents cannot be saved - '..there are open transactions in process on the database.'

  • September 13, 2021
  • 6 replies
  • 1162 views

We have a document with a rectangle and an image in it. We tried to set clippingPath property of the image running the following script:

 

var obj = app.activeDocument.allGraphics[0];
obj.clippingPath.paths.add();
obj.clippingPath.paths[0].pathType = 1668051812; //PathType.CLOSED_PATH
obj.clippingPath.paths[0].entirePath = [[30.7,100.888888888889],[30.7,46],[84,40.7],[102.75,100.888888888889]

 

Running the script we couldn't save the document and we had to close it loosing all changes. Trying to save it in the script we got:

 

Error: Cannot save document because there are open transactions in process on the database.

Please advice. We have to set clippingPath via a script.

This topic has been closed for replies.

6 replies

Kasyan Servetsky
Legend
August 5, 2024

I also encountered this error: here are the details.

Community Expert
September 17, 2021

Hi Dimitri,

I have no issue at all to save your testDoc.indd with the relinked image file with InDesign 16.4.0.55 on Windows 10.

 

 

Here the download link to the packaged and zipped folder:

https://www.dropbox.com/s/gulymrni3syodb2/testDoc-EDITED-2021.zip?dl=1

 

My suggestion:

Update your InDesign version 16.0.0.77 to 16.4.0.55.

 

Obviously the problem is on your system and cannot replicated on other machines.

The original path of the placed image is this:

D:\jporf\Downloads\Jaws\877\img0.jpg

 

Is this volume D a network volume?

 

Regards,
Uwe Laubender

( ACP )

 

Inspiring
September 21, 2021

We tried with the lattest version and still getting this error with your initial sscript that i cannot share here. We will create another test and share it. Thanks.

Community Expert
September 15, 2021

Also added a graphic frame with your entirePath array to the spread to see if the clipping path is applied in the right place.

var obj = app.documents[0].spreads[0].rectangles.add({ fillColor : "Yellow" });
obj.paths[0].entirePath =

[
	[30.7,100.888888888889],
	[30.7,46],
	[84,40.7],
	[102.75,100.888888888889]
];

 

I see no issue at all:

 

 

Regards,
Uwe Laubender

( ACP )

Inspiring
September 16, 2021

Hi again.

Trying to find a solution witth this issue we created a new test case. This time we do not have any script but the following indesign document saved in 2021. Opening that document inDesign ask us to uppdate or not update the missing link. If we do not update and open links and relink the image (image als attached) we cannot save the document anylonger. If we update missing links again we cannot save the document. Our problem is that status were we cannot save the document anymore and we loose all the work either user or scripts did on the document.

 

steps:

1. Opening testDoc.indd - Don't Update Links

2. Relink image

3. No longer able to save our document.

Community Expert
September 15, 2021

Hi Dimitri,

also no issue on my side with your document.

Ran your script on your document with InDesign 2020 v.15.1.3.302 on Windows 10.

I could save the document to a new name without error.

 

Hm…

Perhaps it's the version of InDesign 2020 you are using that has this issue.

Your document was created with InDesign 15.1.3.302 and was saved the last time with 15.0.2.323.

 

Regards,
Uwe Laubender

( ACP )

Inspiring
September 13, 2021

var obj = app.activeDocument.allGraphics[0];
obj.clippingPath.paths.add();
obj.clippingPath.paths[0].pathType = 1668051812; //PathType.CLOSED_PATH
obj.clippingPath.paths[0].entirePath = [[30.7,100.888888888889],[30.7,46],[84,40.7],[102.75,100.888888888889]];

Kasyan Servetsky
Legend
September 13, 2021

This script works for me using your test file. (the latest version on Mac)

You forgot to add closing bracket and semicolon at the end of the last line — '];'

Inspiring
September 13, 2021

The bracket is missing here only. in the script i run in my inDesign 2020 is ok but the  problem exists... 😞