# PeopleSoft \*.tracesql files

**URL:** <https://discuss.elastic.co/t/peoplesoft-tracesql-files/99525>\
**Category:** Logstash\
**Created:** [September 6, 2017, 7:04am UTC](https://discuss.elastic.co/t/peoplesoft-tracesql-files/99525 "2017-09-06T07:04:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![talial](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@talial](https://discuss.elastic.co/u/talial)\
**Post date:** [September 6, 2017, 7:04am UTC](https://discuss.elastic.co/t/peoplesoft-tracesql-files/99525/1 "2017-09-06T07:04:33Z")

</div>

Hello,  
Is there a way to insert PeopleSoft \*.tracesql files into elasticsearch to analyze them?  
Maybe using logstash?  
If there is a step by step documentation it will be very helpfull

PeopleCode Trace:

The PeopleCode trace shows the starting and ending of programs. It also shows the calling of any child programs.  
� Start = The start of a Program.  
� End = The end of a Program.  
� Start-ext = The start of a child Program.  
� End-ext = The end of a child program.

Trace Examples  
This trace is for PeopleTools 8.0.

```
1-23339 18.22.07 0.020 Cur#1.OM800DVL RC=0 Dur=0.010 COM Stmt=SELECT OPRID, NAME1, BUSINESS_UNIT, SETID, LEDGER, LEDGER_GROUP, SOURCE, (CONVERT(CHAR(10),AS_OF_DATE,121)), LC_CNTRY, ALT_CHAR_ENABLED, DR_CR_VISIBLE_FLG FROM PS_OPR_DEF_TBL_FS WHERE OPRID=:1 ORDER BY OPRID
 1-23340 18.22.07 0.000 Cur#1.OM800DVL RC=0 Dur=0.000 Bind-1 type=2 length=3 value=VP1
 1-23341 18.22.07 0.010 Cur#1.OM800DVL RC=0 Dur=0.010 EXE
 1-23342 18.22.07 0.000 Cur#1.OM800DVL RC=0 Dur=0.000 Fetch
 1-23343 18.22.07 0.010 >>> start Nest=00 . EG_DISP_ECO_WRK.INV_ITEM_ID.RowInit
 1-23344 18.22.07 0.010 >>> start-ext Nest=01 eg_set_eco_fields FUNCLIB_EGINTFC.EG_DISP_ECO.FieldFormula
 1-23345 18.22.07 0.000 Cur#1.OM800DVL RC=0 Dur=0.000 COM Stmt=SELECT BUSINESS_UNIT, INV_ITEM_ID, ECO_ID FROM PS_EG_ECO_DISP_FS WHERE BUSINESS_UNIT=:1 AND INV_ITEM_ID=:2 ORDER BY BUSINESS_UNIT, INV_ITEM_ID
 1-23346 18.22.07 0.000 Cur#1.OM800DVL RC=0 Dur=0.000 Bind-1 type=2 length=3 value=M04
 1-23347 18.22.07 0.000 Cur#1.OM800DVL RC=0 Dur=0.000 Bind-2 type=2 length=5 value=30100
 1-23348 18.22.07 0.010 Cur#1.OM800DVL RC=0 Dur=0.010 EXE
 1-23349 18.22.07 0.000 Cur#1.OM800DVL RC=1 Dur=0.000 Fetch
 1-23350 18.22.07 0.010 Cur#1.OM800DVL RC=0 Dur=0.010 COM Stmt=SELECT SETID, INV_ITEM_ID, DESCR60 FROM PS_MASTER_ITEM_TBL WHERE SETID=:1 AND INV_ITEM_ID=:2 ORDER BY SETID, INV_ITEM_ID
 1-23351 18.22.07 0.000 Cur#1.OM800DVL RC=0 Dur=0.000 Bind-1 type=2 length=3 value=MFG
 1-23352 18.22.07 0.000 Cur#1.OM800DVL RC=0 Dur=0.000 Bind-2 type=2 length=5 value=30100
 1-23353 18.22.07 0.010 Cur#1.OM800DVL RC=0 Dur=0.010 EXE
 1-23354 18.22.07 0.000 Cur#1.OM800DVL RC=0 Dur=0.000 Fetch
 1-23355 18.22.07 0.000 < 1-23356 18.22.07 0.000 >>> start-ext Nest=01 eg_disp_eco FUNCLIB_EGINTFC.EG_DISP_ECO.FieldFormula
 1-23357 18.22.07 0.000 < 1-23358 18.22.07 0.000 < 1-23359 18.22.07 0.000 >>> start Nest=00 . EN_REVISION.DATE_IN_EFFECT.RowInit
 1-23360 18.22.07 0.000 < 1-23361 18.22.07 0.000 >>> start Nest=00 . DC_PB_WRK.DC_QRY.RowInit
 1-23362 18.22.07 0.000 >>> start-ext Nest=01 Init_DC FUNCLIB_DC.DC_SETUP_PANEL.FieldFormula
 1-23363 18.22.07 0.000 < 1-23364 18.22.07 0.000 < 1-23365 18.22.07 0.000 >>> start Nest=00 . DC_COPY_WRK.DC_COPY_SRC.RowInit
 1-23366 18.22.07 0.000 <

```

Thanks  
Talia

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 4, 2017, 7:04am UTC](https://discuss.elastic.co/t/peoplesoft-tracesql-files/99525/2 "2017-10-04T07:04:39Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.