Question

How can we get the SQL query from BIX Extract.

How can we get the SQL query from BIX Extract. we looking for this to fine tune the performance.

***Updated by Moderator: Marissa to update categories***

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Correct Answer
August 30, 2016 - 4:29am

You can get the query by enabling debug logging on the class - com.pega.pegarules.data.internal.access.ExtractImpl

Comments

Keep up to date on this post and subscribe to comments

Pega
August 30, 2016 - 4:29am

You can get the query by enabling debug logging on the class - com.pega.pegarules.data.internal.access.ExtractImpl

August 30, 2016 - 1:12pm

Thankyou, will give it a try and get back if i still have an issue =)

March 1, 2018 - 11:09am

is the logging to be enabled in bix.xml file and if yes can I get the syntax of enabling this SQL logging

March 2, 2018 - 2:19am
Response to sudhaharr

No, you should enable the logging in prlogging.xml file the way how you enable for other classes.

March 2, 2018 - 8:47am

We have below config in prlog4j2.xml. Still its not printing the INSERT statements for extraction.

<Loggers>
  <asyncRoot>
   <AppenderRef ref="CONSOLE"/>
   <AppenderRef ref="PEGA"/>
   <AppenderRef ref="ALERT" level="ALERT"/>  
   <AppenderRef ref="ALERTSECURITY" level="ALERT"/>
  </asyncRoot>
     <Logger name="com.pega.pegarules.session.internal.mgmt.SecurityEventLogger" additivity="false" level="DEBUG">
       <AppenderRef ref="SECURITYEVENT"/>
     </Logger>
     <Logger name="com.pega.pegarules.data.internal.access.ExtractImpl" additivity="false" level="DEBUG">
       <AppenderRef ref="BIX"/>
     </Logger>
     <Logger name="com.pega.pegarules.data.internal.access.ExtractParameters" additivity="false" level="DEBUG">
       <AppenderRef ref="BIX"/>
     </Logger>
     <Logger name="com.pega.pegarules.data.internal.access.DatabaseUtilsCommonImpl" additivity="false" level="DEBUG">
       <AppenderRef ref="BIX"/>
     </Logger>
     <Logger name="com.hazelcast" additivity="false" level="info">
       <AppenderRef ref="CLUSTER"/>
     </Logger>
  <Logger name="org.apache.ignite" additivity="false" level="info">
       <AppenderRef ref="CLUSTER"/>
     </Logger>
 </Loggers>