2 Replies Latest reply on Jul 1, 2014 4:28 PM by delhi

    Error while removing peoplesoft account

    delhi

      Hi Everyone,

       

      I am getting below exception while manually removing the peoplesoft accounts from oim:

       

      [2014-06-30T17:46:25.619-05:00] [oim_server1] [NOTIFICATION] [] [ORG.IDENTITYCONNECTORS.PEOPLESOFT.COMPINTFC.PEOPLESOFTCOMPINTFCDELETEOP] [tid: [ACTIVE].ExecuteThread: '108' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 77bf7d01d8d9917f:-6ef8d965:146edb3611e:-8000-0000000000006210,0] [APP: oim#11.1.2.0.0] org.identityconnectors.peoplesoft.compintfc.PeopleSoftCompIntfcDeleteOp : delete : Deleting user [X224413]

      [2014-06-30T17:46:25.620-05:00] [oim_server1] [NOTIFICATION] [] [ORG.IDENTITYCONNECTORS.PEOPLESOFT.COMMON.PEOPLESOFTSESSION] [tid: [ACTIVE].ExecuteThread: '108' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 77bf7d01d8d9917f:-6ef8d965:146edb3611e:-8000-0000000000006210,0] [APP: oim#11.1.2.0.0] org.identityconnectors.peoplesoft.common.PeopleSoftSession : getMapping : getting component interface mapping..

      [2014-06-30T17:46:25.621-05:00] [oim_server1] [NOTIFICATION] [] [ORG.IDENTITYCONNECTORS.PEOPLESOFT.COMMON.SESSIONWRAPPER] [tid: [ACTIVE].ExecuteThread: '108' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 77bf7d01d8d9917f:-6ef8d965:146edb3611e:-8000-0000000000006210,0] [APP: oim#11.1.2.0.0] org.identityconnectors.peoplesoft.common.SessionWrapper : getCompIntfc : param [DELETE_USER_PROFILE]

      [2014-06-30T17:46:25.735-05:00] [oim_server1] [ERROR] [] [ORG.IDENTITYCONNECTORS.PEOPLESOFT.COMPINTFC.PEOPLESOFTCOMPINTFCDELETEOP] [tid: [ACTIVE].ExecuteThread: '108' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 77bf7d01d8d9917f:-6ef8d965:146edb3611e:-8000-0000000000006210,0] [APP: oim#11.1.2.0.0] org.identityconnectors.peoplesoft.compintfc.PeopleSoftCompIntfcDeleteOp : delete :  Error deleting account

      [2014-06-30T17:46:25.737-05:00] [oim_server1] [ERROR] [] [ORACLE.IAM.CONNECTORS.ICFCOMMON.PROV.ICPROVISIONINGMANAGER] [tid: [ACTIVE].ExecuteThread: '108' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 77bf7d01d8d9917f:-6ef8d965:146edb3611e:-8000-0000000000006210,0] [APP: oim#11.1.2.0.0] oracle.iam.connectors.icfcommon.prov.ICProvisioningManager : deleteObject : Error while deleting user[[

      org.identityconnectors.framework.common.exceptions.ConnectorException:  Error deleting account

      Caused by: org.identityconnectors.framework.common.exceptions.ConnectorException: No interface by name [DELETE_USER_PROFILE]

      [2014-06-30T17:46:25.741-05:00] [oim_server1] [TRACE] [] [ORACLE.IAM.CONNECTORS.ICFCOMMON.PROV.ICPROVISIONINGMANAGER] [tid: [ACTIVE].ExecuteThread: '108' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 77bf7d01d8d9917f:-6ef8d965:146edb3611e:-8000-0000000000006210,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.2.0.0] [SRC_METHOD: debug] oracle.iam.connectors.icfcommon.prov.ICProvisioningManager : deleteObject : Return [CONNECTOR_EXCEPTION]    

       

      Any pointers ?

        • 1. Re: Error while removing peoplesoft account
          Kevin Pinsky

          There is a profile required within Peoplesoft that must exist in order to delete the users.  It's called "DELETE_USER_PROFILE".

           

          Here is the documentation and you can search for the DELETE_USER_PROFILE value to see what you missed:

           

          Deploying the Connector

           

          -Kevin

          1 person found this helpful
          • 2. Re: Error while removing peoplesoft account
            delhi

            Thanks Kevin, that helps. I am getting the below error now:

             

            Caused by: psft.pt8.joa.JOAException: Error invoking method [Save]

            Message item[0] : (0,0) : A fatal PeopleCode SQL error occurred. Please consult your system log for details.

            Message item[1] : (48,122) : Warning -- Select OK to confirm deletion of User Definition or select Cancel. (48,122)

            Message item[2] : (2,280) : SQL error in Exec. (2,280) TBLSELECTION_VW.RECNAME.SavePostChange  PCPC:471  Statement:9

            Message item[3] : (91,37) : Error saving Component Interface. {DELETE_USER_PROFILE} (91,37)

            Message item[4] : (0,0) : Failed to execute PSBusComp request

             

            Seems like some issue @ peoplesoft side. I am checking.