OIM - SOA : Value too large for column "WFMESSAGEATTRIBUTE"."STRINGVALUE"

Issue Description:

For every request in OIM, OIM User Interface allows justification of 4000 characters but if you provide justification of 4000 characters, you will see error in the SOA Logs:

ORA-12899: value too large for column "_SOAINFRA"."WFMESSAGEATTRIBUTE"."STRINGVALUE" (actual: 4000, maximum: 2000) 

which means SOA supports justification of maximum of 2000 characters.

Workaround:

Put a solution in OIM UI (can be done in many ways) to restrict users from entering justification of more than 2000 characters.

Disconnected Weird Issue - Deployment Manager Import

Disconnected Applications

Weird issue while migrating disconnected applications from one environment to another environment.

Details:

There were two disconnected applications with below names:

1. RajivDewan
2. Rajiv

There's no issue while importing first application "RajivDewan" but when you try to import another one "Rajiv" then you will face below issue :

com.thortech.xl.ddm.exception.DDMException: Object specified is invalid.Rajiv [ApplicationInstance]

Reason:
This error comes at the time of importing application instance when application instance name is a sub-string of existing application instance name.

Solution:
Do not create application instance with similar names to avoid this issue

Workaround:

• Change the existing application instance name from the database for time being
• Import the second application instance
• Rollback the name of existing (old) application instance

Note:
There's a support note on this issue but that doesn't contain the workaround.