0
0

Written by

Mark OReilly
Follow
Question Mark OReilly · Aug 30, 2024

Only load part of XML/ SQL Snapshot in visual trace- portal loads too slow

#InterSystems IRIS for Health #Business Service #Management Portal #Message Search

As part of fully decoupling code we send a snapshot from a business service (running a SQL statement). 

sql service                         Processor                                File Out

This is picked up by a processer and puts it into a file .txt. 

Issue is if you open it up via the SQL.snapshot message as this is 46,819 rows it'll take too long to respond to opening up the sql.snapshot in the message viewer when viewing the session if looking from the business service 

Is there any way to not have this xml open up in full in the portal? I.e. have a see more? 

I am aware this could just be in the BP but for me this is the correct integration setup- SQL service to pick up the data- process to do something with it (passed in the correct message type for it) and then sent to a file/ downstream. 

Product version: IRIS 2024.1
Discussion (0)0
Log in or sign up to continue

Comments

Eduard Lebedyuk · Aug 30, 2024

Sure, you have two approaches:

  1. Define a message class with XMLPROJECTION=NONE for the properties you want to skip
  2. Redefine %ShowContents method for your message class to skip some of the properties (check Ens.Util.MessageBodyMethods for a sample implementation).
0