tcSDK/validateRecociliationFieldMappings error while activating process form (Doc ID 2284073.1)

Last updated on JULY 06, 2017

Applies to:

Identity Manager - Version 11.1.2.3.170418 and later
Information in this document applies to any platform.

Symptoms

The following error occurs while trying to activate a process form version.

[2017-06-07T17:03:59.933-05:00] [oim_server1] [ERROR] [] [XELLERATE.SERVER] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 88eaa00eefcf3cd4:1bd247dd:15c83f8bc0c:-8000-0000000000002bef,0] [APP: oim#11.1.2.0.0] Class/Method: tcSDK/validateRecociliationFieldMappings encounter some problems: {1}[[
com.thortech.xl.orb.dataaccess.tcDataAccessException
at com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(tcDataAccessExceptionUtil.java:81)
at com.thortech.xl.dataaccess.tcDataBase.createException(tcDataBase.java:3209)
at com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(tcDataBase.java:1411)
at com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(tcDataBase.java:1190)
at com.thortech.xl.dataobj.PreparedStatementUtil.execute(PreparedStatementUtil.java:355)
at com.thortech.xl.dataobj.tcSDK.validateReconciliationFieldMappings(tcSDK.java:390)

.....

at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:518)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a process form.
2. Create a child form.
3. Update the process(parent) form, by creating new version.
4. Activate process (parent) form.


Cause

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