BIX reports details on database
Hi,
Do you know if we can retrieve details of a BIX report on database? For now, it's on a log file like below:
2019-01-31 00:43:23,284 [ PegaRULES-Batch-4] ( internal.access.ExtractImpl) INFO - PAL Statistics for BIX Extract run :
Non-rule-resolved instances accessed from the database: 10
CPU time accessing non-rule-resolved instances from the database: 0
Elapsed Time accessing non-rule-resolved instances from the database: 0.025
CPU time retrieving rule-resolved Rules from the database: 0
Rule-resolved rules requested from database or cache: 2
Bytes read from database Storage Streams (uncompressed): 25870
Number of database requests that exceeded the time threshold: 3
CPU time spent performing BLOB decryption: 0
Elapsed time spent performing BLOB decryption: 164.096
BLOB decryption: 208569
Hi,
Do you know if we can retrieve details of a BIX report on database? For now, it's on a log file like below:
2019-01-31 00:43:23,284 [ PegaRULES-Batch-4] ( internal.access.ExtractImpl) INFO - PAL Statistics for BIX Extract run :
Non-rule-resolved instances accessed from the database: 10
CPU time accessing non-rule-resolved instances from the database: 0
Elapsed Time accessing non-rule-resolved instances from the database: 0.025
CPU time retrieving rule-resolved Rules from the database: 0
Rule-resolved rules requested from database or cache: 2
Bytes read from database Storage Streams (uncompressed): 25870
Number of database requests that exceeded the time threshold: 3
CPU time spent performing BLOB decryption: 0
Elapsed time spent performing BLOB decryption: 164.096
BLOB decryption: 208569
2019-01-31 00:43:23,452 [ PegaRULES-Batch-4] ( internal.access.ExtractImpl) INFO - # Total Instances retrieved: 208569
2019-01-31 00:43:23,459 [ PegaRULES-Batch-4] ( internal.access.ExtractImpl) INFO - Elapsed Time (seconds): 803.412
2019-01-31 00:43:23,459 [ PegaRULES-Batch-4] ( internal.access.ExtractImpl) INFO - Total CPU Time (seconds): 0.0
2019-01-31 00:43:23,459 [ PegaRULES-Batch-4] ( internal.access.ExtractImpl) INFO - #Instances Extracted: 208569
2019-01-31 00:43:23,459 [ PegaRULES-Batch-4] ( internal.access.ExtractImpl) INFO - #Instances per second: 259.6040387746262
2019-01-31 00:43:23,459 [ PegaRULES-Batch-4] ( internal.access.ExtractImpl) INFO - #Instances per hour: 934574.5395886544
2019-01-31 00:43:23,459 [ PegaRULES-Batch-4] ( internal.access.ExtractImpl) INFO - #Instances not extracted due to errors: 0
Thanks
Regards
Pegasystems Inc.
IN
Hi,
There is a final internal RD pzListExtractRunInstances, if you run this and click on the message column you would see an XML which has a value of pyTotalRecords.
The same report is responsible for generating execution history tab in your BIX extract rule.
Now this may not give you what you see in logs, but at least its a start. I am not sure how to navigate the properties like pyTotalRecords from here. Maybe class join will help you here. Or an activity to read through the XML in message column !!
But its worth looking you RD pzListExtractRunInstances might be helpful.
Thank You