Deriving SQL by executing the IE task code

[ptc-4045806]

Hi All

Is there a way we can get hold of the underlying SQL by executing the IE task code and watch it to execute.

Any suggested tools or technicques?

The database is Oracle 11g.

Looking forward to your help

Thank you

Murugan

[FeofilovIvan]

Enable log as example in this atricle http://plmservice.ru/2012/03/windchill-%D0%BE%D1%82%D0%BB%D0%B0%D0%B4%D0%BA%D0%B0-%D0%BF%D1%80%D0%B8%D0%BB%D0%BE%D0%B6%D0%B5%D0%BD%D0%B8%D0%B9-%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D0%B0%D1%8E%D1%89%D0%B8%D1%85-%D1%81-epm/ (you can use google translate from russian to english)

[PatrickLee]

What is it exactly are you trying to accomplish? I have my little tips and tricks to extract data from the database so that way I can write my own reports, or resolve issues with the application without having to contact the painful support at PTC.

[ptc-4045806]

Hi Patrick Lee

There is a AS 400 program calls an intermediate Java program, which in turn executes an IE task on Windchill server to pull the information and gets the report. This program has been written for all the change objects in Windchill.

We need to build the SQL that executes on Windchill and pulls the same information as that of the program I stated above (as we wanted to do away with that old program). The program is built based on Workitems. Now, since the workitem are archived, we have to find an alternate way to make this SQL work without using workitem table

Can you help?

Thank you

Murugan

[PatrickLee]

Murugan,

Before we get to far down the rabbit's hole. How famaliar are you with your Windchill Database?