My Oracle Support Banner

E-QR: E-AS: Sporadic Error in Query that Contains Prompts after Adding xlst (transformation tab) if Jolt Pooling is Enabled -- File <temp folder>/<file_name> is not opened or opened in wrong mode for method WriteLine. (2,627) (Doc ID 2957363.1)

Last updated on JUNE 29, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.


 Running a Query that has prompts on an environment setup that has two web servers and two application servers with Jolt Pooling enabled. In query manager, after adding xlst (transformation tab), when we try to see the preview (preview button) we get the following error :

File <PS_CONFIG_HOME>/<APPSRV DOMAIN>/files/QRY/<temp location>/<temp file name>.xsl is not opened or opened in wrong mode for method WriteLine. (2,627)

The file was not opened correctly for the given method.


If we disable Jolt Pooling, the issue gets resolved.

How can we keep Jolt Pooling enabled and not face the above intermittent issue?



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.