Posts

Showing posts from 2011

Control creation failed for page field (15,63)

Control creation failed for page field (15,63): Issue: The issue may occur in application pages or customizations. This error comes right from Application Designer, it could be a Tools issue. How to identify the issue: select * from PSPNLFIELD where FIELDTYPE = 4 and RECNAME <> ' ' and FIELDNAME = ' ' and PNLNAME='Page Name’ Might be record might exist without corresponding field in the page.

Where does log file sits after clicking Generatelog checkbox in Exceltoci

The Exceltocixxx.log and SOAPTOCIxxx.log are generated if he selects the Generate Log checkbox in ExcelToCI. i. SOAPTOCIxxx.log – By default this log is created in the app server's "files" directory (below the app server domain), but it may be in another location on the application server machine. The xxx is the timestamp appended to the file name. This log shows the PeopleCode execution path in the SOAPTOCI application package . ii. ExcelToCIxxx.log – By default this log is created in user’s Temp directory. The xxx is the timestamp appended to the file name. To determine the location where your Temp directory is mapped to do the following. On the client machine’s desktop right-click on the “My Computer” icon and select Properties. Then select the “Advanced” tab and click on “Environment Variables”. Locate the Temp (or tmp) variable mappings (it may be C:\Temp or some other location). This is normally where the ExcelToCIxxx log is placed.

Error: Think-time PeopleCode event (Exec), but a SQL update has occurred in the commit interval.

Think-time PeopleCode event (Exec), but a SQL update has occurred in the commit interval. Faced above error after tools upgrade. Custom Application Engine (AE) program. PeopleCode step uses Exec() function with the intention of Syncronous execution of the command. When the AE runs it failed with this, or similar Think-Time error; Solution: There are Restrictions on Use of the Exec() Funtion in PeopleCode Events - and there is also a Restriction in Application Engine programs. This is based on whether the execute of the external program is Synchronous, or Asynchronous. If Asynchronous execution is selected - the execution is not 'tied' directly to the continuing execution of the running AE program, so no Think-time error results from this choice. With Synchronous execution it is different - the AE program will wait for the exectution of the command before continuing with the current process. In order for this to work with no error - a Commit has to happen before the Exec

What does 'Cycles=' refer to within a PeopleCode Trace?

When capturing a PeopleCode trace of a user action, a logged message containing 'Cycles=' can be seen at the end of each PeopleCode event. What does this 'Cycles=' variable refer to? Example: PSAPPSRV.459188 1-413095 08.39.48 0.000128 <<< end-ext Nest=01 SavePunchGrid FUNCLIB_TL_PNCH.TR_PUNCH_FUNC.FieldFormula Dur=6.206963 CPU=4.770000 Cycles=65086 The 'Cycles=' variable is a counter for loops around the PeopleCode interpreter. It is a measure of how much PeopleCode the program is executing. This Cycles count is only updated when tracing or debugging has been turned on. In a general sense a high 'Cycles=' value in a PC trace, can be used as a simple guide in determining how expensive that PeopleCode event is. A high Cycles count would likely indicate a good place to start, when tuning a poorly performing user request.

How to hide Menu while transferring from one page to another page (with in Peoplesoft)

There are various ways to achieve this. When I google for this I am able to see one javascript to be placed in target page. But most of the Technical Guru's won’t accept this solution since we need to add HTMLAREA in your delivered page. But below solution will work. Instead of Transfer please use below approach… &MyURL = GenerateComponentContentURL(%Portal, %Node, MenuName.menu, "GBL", Component.Component, Page.Page, "U",keys); ViewContentURL(&MyURL, True);

Cannot find project or library - Spreadsheet Journal Import not working on Excel 2007 with Windows 7 or Vista

After we open the Journal Import Spreadsheet in Windows 7 or Windows Vista, it does not let us click on any buttons to create journals, etc... We get, "Compile error, Cannot find project or library". The spreadsheet journal import, JRNL1.XLS, can be used so long as the Microsoft delivered XML library file msxml.dll exists on the environment. It does not exist with Windows 7 nor Windows Vista. Please copy the msxml.dll file from the Windows XP computer to the workstation with Windows 7 or Windows Vista. Place the file under the windows directory where it is referenced, as follows. --Open JRNL1.xls and then go to the VB Editor (Tools > Macro > VB Editor) or ((Developer > Visual Basic for Office 7) --With JRNLMCRO highlighted, click Tools > Reference There should be a reference to the Microsoft XML DLL library file (msxml.dll). Microsoft has several versions of this library (msxml2.dll / msxml3.dll / etc.) and they coexist on some computers. NOTE: • For Windows 7, t