Tag: Post Needs to Move

These posts still need to move from Wordpress.com

Tip — PeopleTools: Tablespaces What happens when…

Tip — PeopleTools: Tablespaces

What happens when you decide to create a new record and PeopleSoft asks you which tablespace to use, but the tablespace you want is not in the list?

Solution: Insert a Row into the PeopleTools System Catalog table.

As far as I know, PeopleSoft offers no other way of adding tablespaces as options.

Insert Statement:
INSERT INTO PSTBLSPCCAT (DDLSPACENAME, DBNAME, TSTYPE, DBXTSTYPE, COMMENTS) VALUES (‘TABLESPACE_NAME’, ‘ ‘, ‘R’, ‘DMS’, ‘Your Comments’);

More Information on Tablespaces
PeopleTools tables: PSTBLSPCCAT
http://peoplesoft.ittoolbox.com/groups/technical-functional/peoplesoft-fi-l/creating-new-tablespace-in-ps84-489136#

Tip — Other Tools: Toad Installation Issue Just …

Tip — Other Tools: Toad Installation Issue

Just recently, we installed the free version of Toad on a development VMWare server. After logging in, we received two error messages:

Access violation at address 00000000. Write of address 00000000.

and

Error loading SPServer.

I found the fix for these error messages at:
http://www.nabble.com/Error-loading-SPServer-t995120.html

Basically, you must turn off Data Execution Prevention for Toad.

  • Go to the System Properties:
    Control Panel, System or Start Key+Pause/Break Key
  • On the Advanced tab, click the Settings under Performance
  • On the Performance Options, go to the Data Execution Prevention tab
  • You should see selected: “Turn on DEP for all Programs and Services except those I select”
  • Click the Add button, and browse to the Toad executable.
    Probably: c:\Program Files\Quest Software\Toad for Oracle FREEWARE\Toad.exe
  • Choose Ok/Apply for all the Windows and try to run Toad again.

Tip — PeopleTools: Application Engine Logging Ap…

Tip — PeopleTools: Application Engine Logging

Application Engines have the ability to write to the “Redirected Terminal Output”. But, everything that is written into it must be written with a MessageBox command. That results in a blank line between messages and the infamous message set ids at the end.

If you want any formatting at all you should open a file and use the File object to create the file.

First, declare the variable in every PeopleCode program in your App Engine:

Component File &logFile;

Declare the variable as a component or global variable so that it stays around for the life of the App Engine program. Otherwise, you will have to keep reopening the file to write to it in each PeopleCode step.

Second, create an Init step in the Main section that will open the file:

&logFile = GetFile(GetEnv(“PSPRCSLOGDIR”) “\logFile.txt”, “W”, %FilePath_Absolute);

PSPRCSLOGDIR is the environment variable that is set to the path where the files should go. Every file that is put in this path will be copied to the web server so that the user can see it.

You can use %Filepath_Relative in many cases, but sometimes the relative path does not point to the proper folder, particullarly on older PeopleSoft systems. I have had more success with PSPRCSLOGDIR.

Third, close the file in a step at the end of the Main section:

&logFile.close();

Finally, write what you want to the file with:

&logFile.writeline(“This is a log statement!”);

You have complete control of this file and can make it say what you want it to.