0 votes
in Process Server by (16.1k points)

1 Answer

0 votes
by (16.1k points)
Best answer
The DATA Blob Column in LSW_INSTANCE_DATA holds the runtime data of an instance, it seems to be a compressed java serialized object, it may be possible to un-compress it with oracle functions and then read it using tools like jdserialize, but don't think the data will be usable, Direct Process Server DB queries are not recommended since IBM may change the structure and working of these tables and the data within in future versions. Also they may cause locks hindering the performance of Process Server.

You can use REST API's, or JS API based retrievals to get that data, one misconception is that with JS API we can not get all the data but in our tests we have found that the instance.BusinessData.get(key) method returns a Map which has all the exploded objects in it. For list objects the value is a serialized form of the variable which can be converted back to an object using system.serializer.fromXML() method, just concatenate the returned value with an empty string or cast it to a string to make it a string for use by the above method. You can iterate over the keys and values to generate a xml of sort and then transform it using xslt to a usable xml for deserialization.

With REST APIs it  a simple process of converting JSON to desired format.

Related questions

0 votes
1 answer 182 views
0 votes
1 answer 182 views
0 votes
1 answer 86 views
0 votes
1 answer 174 views
0 votes
1 answer 229 views

582 questions

482 answers


1.7k users

Dosvak IBM BPM /BAW Products, Download Evaluation
Process & Performance Tools Process & Performance Tools
Code Analyzer Code Analyzer
UI Toolkit UI Toolkit
Integration Monitoring Integration Monitoring
Welcome to BPM Tips Q&A, Community wiki/forum where you can ask questions and receive answers from other IBM BPM experts and members of the community. Users with 2000 points will automatically be promoted to expert level.
Created by Dosvak LLC
Our Youtube Channel