Clarity

How can I serialize the XML Document in an On-Demand environment where there is no access to the physical servers where the CA PPM application is running. Serialization is done onto a file that is stored on a file system. The On-Demand path does not allow access to the file system.

Debugging because very time consuming if one does not see the XML that was generated using Gel Scripts.

As an alternative is it possible to Serialize the XML onto the log through LOG Out?

We currently are using OnDemand and we have a folder that is accessible via SFTP.

For files needing to be used in a GEL script we just upload them to the shared folder and then reference them in the script.

For debugging, I usually run the GEL from my laptop against the OnDemand system.  Setting up the XOG /GEL client is a little bit tricky.

https://communities.ca.com/docs/DOC-231162474

I also enable logging in the command line execution.

https://communities.ca.com/docs/DOC-231149717

V/r,

Gene

You can have your Gel script to log the xml generated and applied into the process messages which are accessible from the GUI (Initiated processes, messages)

I did explore this as an option and am assuming that you are referring to the use of “<gel:log” to generate this output. Given that the code iterates through the result set from the database, it did not seem worthwhile to attempt this path.

Can you kindly share some sample code to log the XML Generated?

If Serialization is a possibility the gel itself would do it in a jiffy by generating an XML document on the File System. Wondering if the Serialization could somehow be achieved through logging.

Kind regards.

Ashwin Kumar (Contractor)

NetImpact Strategies, Inc.

National Cancer Institute

Center for Biomedical Informatics and Information Technology

9609 Medical Center Drive, 1W532

Rockville, MD 20850

Email:  Ashwin.Kumar@NIH.Gov<mailto:Ashwin.Kumar@NIH.Gov>

Phone: 240-276-7603

I used a couple of scripts by others  to create one for a specific purpose which functions as requested.

One of the examples was the script posted by

Christine.Takeuchi in https://communities.ca.com/message/101805022?commentID=101805022#comment-101805022 

See also the post of  Dave in that thread.

Incidentally I saw an earlier thread on serialize

GEL script - XOG output to fileshare 

This was very helpful. I utilized the gel: expr tag and was able to see the XML on the log.

Is there a limit on the size of the XML while being output on the log. I am asking because lengthier SQL statements get truncated.

Thank you so very much.

Kind regards.

Ashwin

You would need to get the answer from a more technically skilled person.

I have used that to xog in one custom attribute for several projects with minimum project data without anybody reporting missed data.