There’s a simple way to turn peoplecode and SQL tracing on and off using peoplecode, rather than having to set the trace values when you login or via PeopleTools > Utilities > Debug. You can use these commands to trace/debug only the peoplecode you’re interested in. For peoplecode tracing, you set the trace flags using the SetTracePC() function. e.g
|
1 |
SetTracePC(4044); |
… will set the trace flags as per the defaults on the Trace Peoplecode page.…
I was trying to debug an application engine process in Application Designer, and the following line (in bold) would throw an exception and prevent me from debugging any further
|
1 2 3 |
Local XmlDoc &objXMLDoc; &objXMLDoc = CreateXmlDoc(""); &booReturn = &objXMLDoc.ParseXmlFromURL(&sTmplFile); |
The value of &sTmplFile was:
|
1 |
\files\XMLP\bb4ba112-d394-11e0-bd82-ee802d84f08b\CCCG0005_1_0 |
I finally discovered that the ParseXmlFromURL method requires a fully qualified path. For example:
|
1 |
c:\files\XMLP\bb4ba112-d394-11e0-bd82-ee802d84f08b\CCCG0005_1_0 |
My environment was not prepending the drive component because it did not have the PS_SERVDIR environment variable defined. Once I set this variable, everything…
I was trying to debug an Application Engine and noticed that the debugger had hung. I restarted Application Designer and re-ran the debugger for the Application Engine. Since there was only one instance assigned to each temporary table, I noticed that the previous failed run had not released the temporary tables. I managed to work around this by deleting from the following tables:
|
1 2 |
PS_AERUNCONTROL PS_AETEMPTBLMGR |
The following are the SQL Statements that I used:
|
1 2 3 |
DELETE FROM PS_AERUNCONTROL WHERE OPRID = 'PS' AND RUN_CNTL_ID = 'JAY'; DELETE FROM PS_AETEMPTBLMGR WHERE OPRID = 'PS' AND RUN_CNTL_ID = 'JAY'; COMMIT; |
If…
For some unknown reason, I was also not able to convert my VMWare images using the VMWare vCenter Converter. I figured out that the problem was with a particular datastore on the ESXi server. When having a look at the datastore on the ESXi server, I discovered that the datastore was reporting ridiculously high capacities (eg. 600 TB; at one time it even went negative!!). I ended up enabling SSH on the ESXi server and…