We are using WebMethods 8.2 and MWS v 8.0.2.

In services, pipeline is visible for all the failed transactions, can anyone please help me understand where are these pipelines saved, what table if its database or what location if its server filesystem.

Thanks

Hi Akshat,

The pipeline is the general term used to refer to the data structure in which input and output values are maintained for a flow service. It allows services in the flow to share data.The pipeline starts with the input to the flow service and collects inputs and outputs from subsequent services in the flow. When a service in the flow executes, it has access to all data in the pipeline at that point.

Pipeline will reside only in internal memory unless until explicitly specified to save it to a File.

There are few built in services listed below which you can check how the pipeline works:

[b]pub.flow:savePipeline[/b] Saves the pipeline with a $nake key in memory which you can retrieve whenever you want with the unique $nake key, but it's not available after server restart.

[b]pub.flow:savePipelineToFile[/b] Saves the pipeline in a File system and you have to specify the file path to which the whole pipeline Data should be saved, you can retrieve whenever you want with the file Name, and it's also available after server restart.

[b]pub.flow:restorePipeline[/b] Used when you use pub.flow:savePipeline and pipeline can be retrieved with the unique $nake key.

[b]pub.flow:restorePipelineFromFile[/b] Used when you use pub.flow:savePipelineToFile and pipeline can be retrieved from the F/s file with the Filename parameter.

[b]pub.flow:tracePipeline[/b] Using this service the Integration Server logs the name-value pairs in the pipeline at that time to server log

Let me know if anything is not clear to you.

Hi Nelsiri,

Thanks for sharing the info, really helpful.

Though I fear I didn't quote my question properly.

I've referring to pipeline data visible in MWS -> Monitoring -> Integration -> Services for all the failed jobs. I've attached a screenshot for same.

We are trying to figure out, where is MWS pulling this data from. These services aren't using any pipeline saving services in code, also data isn't saved for same service when it completes successfully. That makes me wonder whether there's a setting somewhere specifying 'save only on fail'.

Hope this explains my query better.
[attachment=8]Pipeline.JPG[/attachment]

Hi Akshat,

Please refer [url=http://documentation.softwareag.com/webmethods/wmsuites/wMdoc/_webM_suite_71/My%20webMethods%20Server%20and%20Task%20Engine/My%20webMethods%20Server%20and%20Task%20Engine%207.1/My%20webMethods%20Server%20Administrator%27s%20Guide%207.1.pdf]MWS Admin guide[/url]

Chapter 13. Analysis, Reporting, and Troubleshooting lists the topics server logging,configurations..etc.

I think your configurations are set up to log only errors and as part of Error logging it saves the entire pipeline while an error occured, traced via getLastError servie...you should work out on your MWS Server logging configurations.

Thanks

Hi Nelsiri,

You understood it right. Flowservice properties mention 'on error' for Save pipeline setting.

Guide surely does tell me what database/schema is being used as data source. But still I cannot see any reference to where/which tables the pipeline is saved for failed services.

thanks
akshat

Hi Akshat,

If you want table names then try WMERROR which store all error information..we have this configuration setting for storing our error information, try to check WMSERVICE table or any tables which have the name WMSERVICE... All the wM database tables are selfexplanatory and they refer by their functionality. So it will be easy for you to trace them.

Meanwhile i will try to explore things in my landscape and get back to you.

Thanks,
Neelima