This discussion is archived
9 Replies Latest reply: Jan 19, 2013 12:42 AM by Nicolas.Gasparotto RSS

HRMS Installation

976588 Newbie
Currently Being Moderated
Hi,

Installation getting aborted while importing PS_GPCH_TX_RATES table.Below is the error message.Even though oracle database is up and running.Please advice

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2520000,File: E:\pt851-903-R1-retail\peopletools\src\pssys\gendttm.cppSQL error. Stmt #: 325 Error Position: 0 Return: 3114 - ORA-03114: not connected to ORACLE
Failed SQL stmt:SELECT TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD-HH24.MI.SS.FF') FROM PSCLOCK
File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 3135 - ORA-03135: connection lost contact Process ID: 4712 Session ID: 14 Serial number: 7
Failed SQL stmt:INSERT INTO PS_GPCH_TX_RATES (GPCH_TX_CANTON, GPCH_TX_PCT_TYPE, EFFDT, GPCH_TX_TRF_CD, SEX, GPCH_TX_LOW_GROSS, CURRENCY_CD, GPCH_TX_LGSTEP, GPCH_TX_STAX_AMT, GPCH_TX_STAX_PCT) VALUES (:1, :2, TO_DATE(:3,'YYYY-MM-DD'), :4, :5, :6, :7, :8, :9, :10)
Error: Unable to insert row 8384
Error: SQL execute error for GPCH_TX_RATES
File: SQL Access ManagerSQL error. Stmt #: 43 Error Position: 0 Return: 3114 - ORA-03114: not connected to ORACLE
File: SQL Access ManagerSQL error. Stmt #: 44 Error Position: 0 Return: 0 - Invalid cursor number
File: SQL Access ManagerSQL error. Stmt #: 43 Error Position: 0 Return: 3114 - ORA-03114: not connected to ORACLE
File: SQL Access ManagerSQL error. Stmt #: 44 Error Position: 0 Return: 0 - Invalid cursor number
SQL Spaces: 0 Tables: 1 Triggers: 0 Indexes: 0 Views: 0
File: E:\pt851-903-R1-retail\peopletools\src\pssys\gensql.cppSQL error. Stmt #: 1555 Error Position: 0 Return: 3114 - ORA-03114: not connected to ORACLE
Failed SQL stmt:UPDATE PSSTATUS SET UNICODE_ENABLED=:1
File: E:\pt851-903-R1-retail\peopletools\src\pssam\samutil.cppSQL error. Stmt #: 8364 Error Position: 0 Return: 3114 - ORA-03114: not connected to ORACLE
Failed SQL stmt:UPDATE PSSTATUS SET DATABASE_OPTIONS = DATABASE_OPTIONS + :1 WHERE MOD(FLOOR(DATABASE_OPTIONS/:2),2) = 0
File: E:\pt851-903-R1-retail\peopletools\src\pssam\samutil.cppSQL error. Stmt #: 8138 Error Position: 0 Return: 3114 - ORA-03114: not connected to ORACLE
Failed SQL stmt:UPDATE PSSTATUS SET DATABASE_OPTIONS = DATABASE_OPTIONS + :1 WHERE MOD(FLOOR(DATABASE_OPTIONS/:2),2) = 0
Ended: Thu Jan 10 09:22:20 2013
Unsuccessful completion


SYSTEM DETAILS
------------------------------------------------------------------------------
OEL 5.7 64 bit
oracle 11.2.0.1 64 bit
PeopleTools 8.51 64 bit
Application HRMS 9.1FP2 64 bit
Weblogic 1033 64 bit
Tuxedo 10gR3 64 bit
File server Windows2008 64 bit

Regards,
Vikas

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points