Since SAP bought Crystal Reports there has been a constant change in the licensing between Oracle and SAP. It would appear that Oracle no longer has direct rights to Crystal, and is trying to get PeopleSoft costumers to change to the XML Publisher.

However, for customers that have been with PeopleSoft (Oracle) for a long time and have developed lots of Crystal Reports, you have to request access to download the Crystal 2008 or 2011 files from the edelivery site. To do this you must submit a NON-Technical SR on the MOS site.

When trying to run on the process scheduler you may receive the following error:

In order to make the process scheduler capable of running Crystal you must install SAP Crystal software, and then you have to install SAP Crystal runtime software. These files are available from SAP. Make sure you get the 32bit runtime. Once the runtime is installed the above error should go away.

Use this link to get the runtime:
http://scn.sap.com/docs/DOC-7824

When trying to encrypt the passwords using the datamover script encrypt.dms or just using the ENCRYPT_PASSWORD *; command I got an error that was showing that there was an error with msgver.cpp trying to UPDATE the PSLOCK table for CLM. Interestingly enough I could not find any cases that seem to make any sense, but putting a couple of things together, I decided to check the database version levels.

It turned out that for SQL Server 2012 running on PeopleTools 8.53.02, you need to be at a minimum of CU3. So after apply the cumulative update #3 patch to my new SQL Server 2012 64-bit install, the problem went away without a problem.

Just working on a new install on a Windows 2008 R2 system with the newest toolset 8.53, and the Process Scheduler fired up great and runs nicely, but when I tried to run SQR, I got an (SQR 1803) CONNECT failed error.

It turns out the in 8.53 toolset, the SQR uses the 32 bit ODBC to connect to the database. After running the program: c:\windows\SysWOW64\odbcad32.exe and configuring a 32-bit connection the SQR ran without a problem.

When installing Weblogic PIA as a service on Windows using the installNTService.cmd program, this error will pop up if you do not have the proper administrative privileges. This error is not PeopleSoft based it is a Windows OS error. Since the introduction of UAC (User Access Controls) this error can occur because of the user privileges.

I always change the administrative account to have no UAC controls, but in cases where the administrative user must have the privilege, you can simply run the DOS command feature as Administrator (right click on the command program) and select “Run As Administrator”. You will see a DOS window and it will be titled “Administrator: Windows Command Processor”.

Working on a new PSNT server, I ran into the following error:

This looks serious, but if you look closely, you might actually see the problem. When the Process Scheduler Domain is built it defaults the SQRBIN parameter. In my case, my %PS_HOME% was e:\psft\pt852 not e:\psoft\pt852. After changing the SQRBIN parameter to: %PS_HOME%\bin\sqr\ORA\bin….. Everything was good! Don’t forget to stop/restart the process scheduler for this change to take effect.