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)
IBM PVT LTD
Pega Developer
IBM PVT LTD
IN
GopiK787 Member since 2020 1 post
IBM PVT LTD
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.

Related content:

Related content has not currently been identified for this post.

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