My Oracle Support Banner

E-QR: Receiving Think-time PeopleCode Event (ViewAttachment) Error When Adding XSLT Transform Then PREVIEW (Doc ID 2802977.1)

Last updated on JUNE 07, 2024

Applies to:

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

Symptoms

Adding XSLT transformations to some Queries generates an error for the PREVIEW feature in Query Manager. Impacts Queries with Prompts that are using this feature but only fails for Preview. However, normal Query execution working.
 

Think-time PeopleCode event (ViewAttachment), but a SQL update has occurred in the commit interval. (2,148) PSXP_RPTDEFNMANAGER.Utility.OnExecute Name:ViewXMLPAttachment PCPC:9055 Statement:157
Called from:QRYXSLT_WRK.QRYXFORMPREVIEW.FieldChange Statement:48

Think-time PeopleCode events such as messages requiring a user response cannot be executed if a SQL update, insert, or delete has occurred in the commit interval. Examples of PeopleCode that invoke update type of SQL includes Process Scheduler, TriggerBusinessEvent, or MarkWorked. A unit of work cannot contain both think-time events and update type SQL.

The issue can be reproduced with the following steps:
1. Reporting Tools > Query > Query Manager
2. Open delivered Query "QA_CS_FA_SLC" and go to the Transformations tab
3. Click "Add XSLT" button
4. Add a "Name" like "tab"
5. Add valid XSLT text and click "OK" button
6. Click "Preview" button
7. Observe "Think-Time" error.

Cause

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
Symptoms
Cause
Solution
References


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