IAM Integrated Solutions: OIM Connectors

Seeing Error while provisioning to MSSQL Connector:

[ERROR] [] [ORACLE.IAM.CONNECTORS.ICFCOMMON.RECON.LOOKUPRECONTASK] [tid: OIMQuartzScheduler_Worker-4] [userId: oiminternal] [ecid: 73ac5db7-f9df-4987-82d4-b6bf434d2467-000000a6,0:296] [APP: oim] [partition-name: DOMAIN] [tenant-name: GLOBAL] oracle.iam.connectors.icfcommon.recon.LookupReconTask : execute : Error during execution[[

java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:0edda621-37af-41bb-89d8-3542d00f387b

Solution:

1) mssql-jdbc-<latest_version>.jar is missing

Note: check the jdk version for your target and oim.
If you are 11g then the jar must be compatible with jdk1.7 but if you are on 12c then it should be working be jdk1.8. same way check the jdk versions on your connector server and target database.

2) Register this jar on oim server using UploadJars utility

3) Give the reference of this jar in setDomainEnv.sh

POST_CLASSPATH="/opt/oracle/apps/OIM_Middleware/oracle_common/modules/thirdparty/mssql-jdbc-9.4.0.jre8.jar${CLASSPATHSEP}${POST_CLASSPATH}"

export POST_CLASSPATH

4) You need to give the below jars reference additionally.

POST_CLASSPATH="/opt/oracle/apps/OIM_Middleware/idm/server/ThirdParty/ojdbc8.jar${CLASSPATHSEP}${POST_CLASSPATH}"

export POST_CLASSPATH

POST_CLASSPATH="/opt/oracle/apps/OIM_Middleware/oracle_common/lib/ons.jar${CLASSPATHSEP}${POST_CLASSPATH}"

export POST_CLASSPATH

[ERROR] [] [ORACLE.IAM.CONNECTORS.ICFCOMMON.PROV.ICPROVISIONINGMANAGER] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: jlibich] [ecid: e3db7ea4eadae3c1:4b76075a:17630e56b2d:-8000-000000000001e537,0] [APP: oim#11.1.2.0.0] [DSID: 0000NOtWHNpDKeMpQKl3id1Vmjgy000009] oracle.iam.connectors.icfcommon.prov.ICProvisioningManager : updateAttributeValue : Error in updateAttributeValue[[
org.identityconnectors.framework.common.exceptions.ConnectorException: Cannot connect to peoplesoft : PeopleTools release (8.55.27) for web server/ Application Designer '' is not the same as Application Server PeopleTools release (8.57.12). Access denied.

Solution:

1) You should have latest version of psjoa.jar and psmanagement.jar from PeopleSoft team. These are located in PEOPLESOFT_HOME/web/psjoa directory.

2) select * from OIMHOME_JARS;

Identify ICFBundle --> org.identityconnectors.peoplesoftintfc-1.0.5963.jar

3) following environment variables need to be set if not done before

APP_SERVER is weblogic

OIM_ORACLE_HOME is /u01/app/oracle/product/middleware/Oracle_IDM1/

JAVA_HOME is /java/jdk1.7.0_80/

MW_HOME is /u01/app/oracle/product/middleware/

WL_HOME is /u01/app/oracle/product/middleware/wlserver_10.3/

DOMAIN_HOME is / u01/app/oracle/middleware/user_projects/domains/oim_domain/

4) Take Backup of jar

locate the server location for this bundle and take a backup in your local/server host.

Navigate to below path and run Downloadjars.sh utility

/u01/app/oracle/product/middleware/IAM/server/bin

./DownloadJars.sh

For running the Utilities the following environment variables need to be set

APP_SERVER is weblogic
OIM_ORACLE_HOME is /u01/app/oracle/product/middleware/Oracle_IDM1/
JAVA_HOME is /java/jdk1.7.0_80/
MW_HOME is /u01/app/oracle/product/middleware/
WL_HOME is /u01/app/oracle/product/middleware/wlserver_10.3/
DOMAIN_HOME is / u01/app/oracle/middleware/user_projects/domains/oim_domain/

Executing oracle.iam.platformservice.utils.JarDownloadUtility in IPv4 mode

[Enter Xellerate admin username :]xelsysadm

[Enter the admin password :]

[[Enter serverURL (Ex. t3://oimhostname:oimportno for weblogic or corbaloc:iiop:localhost:2801 for websphere)]:]t3://oimoamlib.test.com:14005

[[Enter context (i.e.: weblogic.jndi.WLInitialContextFactory for weblogic or com.ibm.websphere.naming.WsnInitialContextFactory for websphere)]:]weblogic.jndi.WLInitialContextFactory

Logging configuration class "oracle.core.ojdl.logging.LoggingConfiguration" failed

java.lang.ClassNotFoundException: oracle.core.ojdl.logging.LoggingConfiguration

log4j:WARN No appenders could be found for logger (org.springframework.jndi.JndiTemplate).

log4j:WARN Please initialize the log4j system properly.

Enter the jar type

1.JavaTasks

2.ScheduleTask

3.ThirdParty

4.ICFBundle

Enter the full path of the download directory :

/u01/bundle/PSFTJar/prod_backup

Enter the name of jar file to be downloaded from DB :

org.identityconnectors.peoplesoftintfc-1.0.5963.jar

Do u want to download more jars [y/n] :n

Download jar executed successfully

5) Delete jar

./DeleteJars.sh

For running the Utilities the following environment variables need to be set

Executing oracle.iam.platformservice.utils.JarDeleteUtility in IPv4 mode

[Enter Xellerate admin username :]xelsysadm

[Enter the admin password :]

[[Enter serverURL (Ex. t3://oimhostname:oimportno for weblogic or corbaloc:iiop:localhost:2801 for websphere)]:]t3://oimoamlib.test.com:14005

[[Enter context (i.e.: weblogic.jndi.WLInitialContextFactory for weblogic or com.ibm.websphere.naming.WsnInitialContextFactory for websphere)]:]weblogic.jndi.WLInitialContextFactory

Logging configuration class "oracle.core.ojdl.logging.LoggingConfiguration" failed

java.lang.ClassNotFoundException: oracle.core.ojdl.logging.LoggingConfiguration

log4j:WARN No appenders could be found for logger (org.springframework.jndi.JndiTemplate).

log4j:WARN Please initialize the log4j system properly.

Enter the jar type

1.JavaTasks

2.ScheduleTask

3.ThirdParty

4.ICFBundle

Enter the name of jar to be deleted from DB :

org.identityconnectors.peoplesoftintfc-1.0.5963.jar

Do u want to delete more jars [y/n] :n

Delete jar executed successfully

This jar contains psjoa.jar file in lib directory of older version. Extract bundle and file and replace with upgraded version of psjoa.jar and rebuild org.identityconnectors.peoplesoftintfc-1.0.5963.jar file.

6) Upload upgraded bundle jar

1. ./UploadJars.s

For running the Utilities the following environment variables need to be set

Executing oracle.iam.platformservice.utils.JarUploadUtility in IPv4 mode

[Enter Xellerate admin username :]xelsysadm

[Enter the admin password :]

[[Enter serverURL (Ex. t3://oimhostname:oimportno for weblogic or corbaloc:iiop:localhost:2801 for websphere)]:]t3://oimoamlib.test.com:14005

[[Enter context (i.e.: weblogic.jndi.WLInitialContextFactory for weblogic or com.ibm.websphere.naming.WsnInitialContextFactory for websphere)]:]weblogic.jndi.WLInitialContextFactory

Logging configuration class "oracle.core.ojdl.logging.LoggingConfiguration" failed

java.lang.ClassNotFoundException: oracle.core.ojdl.logging.LoggingConfiguration

log4j:WARN No appenders could be found for logger (org.springframework.jndi.JndiTemplate).

log4j:WARN Please initialize the log4j system properly.

Enter the jar type

1.JavaTasks

2.ScheduleTask

3.ThirdParty

4.ICFBundle

Enter the path/location of jar file :

/tmp/Sanjivani/org.identityconnectors.peoplesoftintfc-1.0.5963.jar

Do u want to load more jars [y/n] :n

Upload jar executed successfully

7) Replace psjoa.jar with upgraded version

Navigate to below location and replace psjoa.jar file with upgraded version.

cp /tmp/Sanjivani/psjoa.jar /u01/app/oracle/product/middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/targetsystems-lib/PSFT_UM-11.1.1.6.0

NOTE: If you are using PeopleTools 8.54, PeopleTools 8.55, PeopleTools 8.56, or PeopleTools 8.57, you must also copy the psmanagement.jar file from PEOPLESOFT_HOME/client-tools/class to the directory created in ConnectorDefaultDirectory/targetsystems-lib/PSFT_UM-11.1.1.6.0

cp /tmp/Sanjivani/psmanagement.jar /u01/app/oracle/product/middleware/Oracle_IDM1/server/ConnectorDefaultDirectory/targetsystems-lib/PSFT_UM-11.1.1.6.0

8) Restart oim servers

9) Test Peoplesoft Provisioning/Update attribute/Disable/Delete Operation from OIM on Peoplesoft Test account.
you should not see the error in log.

IAM Integrated Solutions

SQLServerException:This driver is not configured for integrated authentication

Peoplesoft Provisioning is failing after Peoplesoft tools Upgrade

Basic Perfomance Tuning For stuck threads and response times

Report Abuse