Skip to main content

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

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 Case Management Financial Services Solutions Consultant

  • Reply
Posted: 9 months 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