of x

Tracing & Debugging in People Tools 8.4x CMS411

Published on 2 weeks ago | Categories: Documents | Downloads: 0 | Comments: 0

Comments

Content

 

Student Administration

Tracing & Debugging in PeopleTools 8.4x

Kai Markowitz Technical Lead ** This presentation has notes, don’t just view/print the slides ** April 2007

 

Student Administration

    

Agenda

Introduction PeopleTools 8.4x Changes Tracing SQL & PeopleCode Tracing SQR Programs Tracing Cobol Programs

  

Tracing App Engine Programs PeopleCode Debugging Questions

2

 

Student Administration

    

Agenda

Introduction PeopleTools 8.4x Changes Tracing SQL & PeopleCode Tracing SQR SQL & PeopleCode Tracing Programs Tracing Cobol Programs

  

Tracing App Engine Programs PeopleCode Debugging Questions 3

 

Student Administration

    

Agenda

Introduction PeopleTools 8.4x Changes Tracing SQL & PeopleCode Tracing SQR SQL & PeopleCode Tracing Programs Tracing Cobol Programs

  

Tracing App Engine Programs PeopleCode Debugging Questions

4

 

Student Administration



PeopleTools 8.4x Changes

No more pstools.exe on the local client! – CS 8.9 c can’t an’t be be run in twotwo-tier tier mode. mode.



No tracing/debugging in two-tier mode. – App Eng Engine ine pro program grams s are the the only excep exception tion to this.



Trace files are on the application server. – Examining the trace files requires access to the Unix server.

5

 

Student Administration

    

Agenda

Introduction PeopleTools 8.4x Changes Tracing SQL & PeopleCode Tracing SQR Programs Tracing Cobol Programs

  

Tracing App Engine Programs PeopleCode Debugging Questions

6

 

Tracing SQL & PeopleCode

Student Administration



These are very good trace settings to use in order to get very “light” buta useful trace. – Us Use e a uniq unique ue User ID when tracing to make the trace file easier to read. 7

 

Student Administration



Tracing SQL & PeopleCode

Trace files are found in the PS_SERVDIR /LOGS directory of your application server. – PS_SERVDIR is a Unix environment variable.

8

 

Student Administration

Tracing SQL & PeopleCode

9

 

Tracing SQL & PeopleCode

Student Administration

SQL Error

10

 

Student Administration

Tracing SQL & PeopleCode

PeopleCode Error

11

 

Tracing SQL & PeopleCode

Student Administration



If you find an area of PeopleCode that appears to be a performance issue or returns  “unexpected”  results, you can trace the same area again with an expanded set of  trace options 12

 

Student Administration

Tracing SQL & PeopleCode

Expanded PeopleCode Error

13

 

Student Administration

 

Agenda

Introduction PeopleTools 8.4x Changes

  

Tracing SQL & PeopleCode Tracing SQR Programs Tracing Cobol Programs

  

Tracing App Engine Programs PeopleCode Debugging Questions

14

 

Student Administration



Tracing SQR Programs

Append the –s flag to the Process Definition to see a list of the SQL in the program and execution counts .

15

 

Student Administration

Tracing SQR Programs

16

 

Student Administration



Tracing SQR Programs

Append the –debug flag to the Process Definition along with the debug flag(s) you want to see.

17

 

Student Administration



Tracing SQR Programs

The trace file can be accessed directly within the Process Monitor.

18

 

Student Administration

       

Agenda

Introduction PeopleTools 8.4x Changes Tracing SQL & PeopleCode Tracing SQR Programs Tracing Cobol Programs Tracing App Engine Programs PeopleCode Debugging Questions

19

 

Student Administration



Tracing Cobol Programs

Override the Parameters List in the Process Definition using the following template: – PRCSNAME   ORACLE/%%DBNAME%%/%%OPRID%%/%%O PRPSWD%%/%%RUNCNTLID%%/%%INSTANCE %%/255/%%DBFLAG%%

20

 

Student Administration



Tracing Cobol Programs

The trace file can be accessed directly within the Process Monitor.

21

 

Student Administration

Tracing Cobol Programs

PeopleSoft Cobol

22

 

Tracing Cobol Programs

Student Administration

Trace (Body)

23

 

Tracing Cobol Programs

Student Administration

Trace (Timings) 2.

1.

3. 24

 

Tracing Cobol Programs

Student Administration

SQL Error

25

 

Student Administration

Tracing Cobol Programs

 “DMS” Error: Select Item

26

 

Student Administration

Tracing Cobol Programs

 “DMS” Error: Bind Variable

27

 

Student Administration

Tracing Cobol Programs

Subscript out of range

28

 

Student Administration





Tracing Cobol Programs

Tracing Cobol executed from a RemoteCall in PeopleCode (e.g., pushbutton) is the most complex type of trace to setup in PeopleTools 8.4x. Requires making changes to the psappsrv.cfg file on the Unix server. – Lo Loca cate ted d in PS_SERVDIR directory.



Impacts the application. Be sure everyone to turn offusing the trace as soon as you are done.

29

 

Student Administration



Tracing Cobol Programs

Set TraceSQL=255 in psappsrv.cfg*. *Note: The associated “Mask” value must be set higher than this.

30

 

Student Administration



Tracing Cobol Programs

Set RCCBL Redirect=1 in psappsrv.cfg.

31

 

Student Administration



Tracing Cobol Programs

Cobol trace files can be found in the LOGS directory directory*. *. PS_SERVDIR/ LOGS *Note: The .err file is only found if there is a Cobol error.

32

32

 

Agenda

Student Administration

 

Introduction PeopleTools 8.4x Changes

  

Tracing Tracing Tracing

SQL & PeopleCode SQR Programs Cobol Programs

  

Tracing App Engine Programs PeopleCode Debugging Questions

33

 

Student Administration

 



Tracing App Engine Programs

App Engine programs rule! App Engine programs can be traced in two-tier mode from the Application Designer. The PeopleCode Debugger can be used with App Engine programs in two-tier mode from the Application Designer*. *Note: This is the Debugger only case in PeopleTools 8.4x where the PeopleCode can be run in two-tier mode

34

 

Student Administration



Tracing App Engine Programs

Append the appropriate trace flag(s) to the Process Definition. • -TRAC -TRACE E 131 131 (App (App Engine Engine trace, trace, require required) d) • -TOO -TOOLSTR LSTRACEP ACEPC C 2048 2048 (PCode (PCode trace, trace, optio optional) nal) • -TOOLSTRACESQL 31 (SQL trace, optional)

35

 

Student Administration



Tracing App Engine Programs

The trace files can be accessed directly in process monitor.

36

 

Student Administration

Tracing App Engine Programs

Trace (Body)

37

 

Student Administration

Tracing App Engine Programs

Trace (SQL Timings)

38

 

Student Administration

Tracing App Engine Programs

Trace (PeopleCode Timings)

39

 

Student Administration

Tracing App Engine Programs

Trace (Totals & Environment)

40

 

Student Administration

Tracing App Engine Programs

SQL Error (Process Monitor)

41

 

Student Administration

Tracing App Engine Programs

SQL Error (Trace)

42

 

Student Administration

Tracing App Engine Programs

PeopleCode Error (Process Monitor)

43

 

Student Administration

Tracing App Engine Programs

PeopleCode Error (Trace)

44

 

Student Administration

Tracing App Engine Programs

Dynamic Call Error (Trace)

45

 

Student Administration



Tracing App Engine Programs

For two-tier tracing, you must run App Engine processes through the web browser at least once; you need to do this in order to have a Run Control ID and Process Instance Number*.

46

 

Student Administration



Tracing App Engine Programs

Turn on your Application Engine Trace flags in the Configuration Manager.

47

 

Student Administration



Tracing App Engine Programs

With the App Engine program open in the Application Designer, press the Run Program icon and enter the Run Control ID and Process Instance Number. Click ‘OK’ to run the App Engine process in two-tier mode.

Defaults

48

 

Student Administration



Tracing App Engine Programs

You can find the log files for the run in the C:\TEMP\PS\ DBName DBName directory*. *Note: The location of this file can vary depending dep ending on the particular configuration of your workstation.

49

 

Student Administration



Tracing App Engine Programs

To debug PeopleCode in an App Engine program, turn on the PeopleCode Debugger Mode and set breakpoints before running.

50

 

Agenda

Student Administration

       

Introduction PeopleTools 8.4x Changes Tracing Tracing Tracing

SQL & PeopleCode SQR Programs Cobol Programs

Tracing App Engine Programs PeopleCode Debugging Questions

51

 

Student Administration



PeopleCode Debugging

Online PeopleCode Debugging must be done three-tier from the Citrix desktop. – Logi Login n to App Design Designer er with the the name name of the  

application server.

52

 

Student Administration



PeopleCode Debugging

Debugging swaps back and forth between browser session and App Designer*. *Note: You must login to both sessions with the same Userid.  

53

 

Agenda

Student Administration

       

Introduction PeopleTools 8.4x Changes Tracing Tracing Tracing

SQL & PeopleCode SQR Programs Cobol Programs

Tracing App Engine Programs PeopleCode Debugging Questions

54

 

Student Administration

Sponsor Documents

Hide

Forgot your password?

Or register your new account on INBA.INFO

Hide

Lost your password? Please enter your email address. You will receive a link to create a new password.

Back to log-in

Close