9 Replies Latest reply: Jan 19, 2013 2:42 AM by Nicolas.Gasparotto RSS

    HRMS Installation

    976588
      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