Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Gopikiran Dasariraju (GopiK787)
Engineering Industries Excellence
Pega Developer
Engineering Industries Excellence
IN
GopiK787 Member since 2020 2 posts
Engineering Industries Excellence
Posted: Dec 20, 2023
Last activity: Jan 4, 2024
Posted: 20 Dec 2023 5:47 EST
Last activity: 4 Jan 2024 12:08 EST
Closed

Save database query to logs generated by OBJ-SAVE.

Hi ,

Could you please help me how to save SQL query to logs generated by OBJ-SAVE method in activity.

 

Thanks in advance.

To see attachments, please log in.
Pega Platform 7.2.2
Pega Platform
Case Management
Financial Services
Solutions Consultant

Posted: 1 year ago
Posted: 4 Jan 2024 12:08 EST
Marije Schillern (MarijeSchillern)
MOD
Senior Knowledge Management Specialist
Pegasystems Inc.
GB

@GopiK787 To log the SQL query generated by the OBJ-SAVE method in an activity, you can enable debug logging on the class 'com.pega.pegarules.data.internal.access.DatabaseImpl'. This will log all the SQL queries that are executed, including those generated by the OBJ-SAVE method. Please remember to disable the logging once you have the information you need, as excessive logging can impact system performance.

⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.

Debug a activity instead of using remote tracer

ow can we get the SQL query from BIX Extract

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice