E-PC: Error Received While Compiling Directive PeopleCode when installing PT8.55 with MSSQL (Doc ID 2121822.1)

Last updated on JUNE 13, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Goal

Customer installing PT8.55 at the below step from the "PeopleTools_855_Installation_for_Microsoft_SQL_Server.PDF" file and getting error message as listed below.

Step Information ==> If the application database you are installing is PeopleSoft PeopleTools 8.53 or later, you must compile all directive PeopleCode in your database. Execute the following command on your database to run PeopleSoft
Application Designer in quiet mode. From the DOS command line, the syntax is:
<PS_HOME>\bin\client\winx86\pside.exe -CT MICROSFT -cD -CS -CO -CP -SS NO -QUIET -HIDE -CMPDIRPC -LF

Command Ran ==> pside.exe -CT MICROSFT -cD HCDMO855 -CS PHCMX607 -CO PS -CP PS -SS NO -QUIET -HIDE -CMPDIRPC -LF E:\psoft\hcm92\HCDMO855\log\PEOPLECODE.LOG

Output of the Log File ==>
PeopleSoft Project Command Line
Compile Directive PeopleCode
Tools Release: 8.55.01
2016-03-16 : 11.15.34

-CT Source Database Type = MICROSFT
-CS Source Database Server = PHCMX607
-CD Source Database Name = HCDMO855
-CO Source Database Operator = PS
 
Compile Directive PeopleCode Started . . . . . .
System Error : File: E:\pt85501c-retail\peopletools\src\pspcm\pcmconv.cppSQL error. Stmt #: 3359 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 11 for SQL Server]Function sequence error (SQLSTATE S1010) 0
Failed SQL stmt: SELECT OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, OBJECTID5, OBJECTVALUE5, OBJECTID6, OBJECTVALUE6, OBJECTID7, OBJECTVALUE7 FROM PSPCMPROG WHERE PROGSEQ = 0 and PTTOOLSREL IS NOT NULL and PTTOOLSREL <> ' '
 
Compile Directive PeopleCode completed successfully
 

Command line process successfully completed.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms