PeopleSoft *.tracesql files


(talia) #1

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


(system) #2

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