E-PC: Error Received While Compiling Directive PeopleCode when installing PT8.55 with MSSQL
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.
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.
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