CA Identity Manager Release Notes › Known Issues › General › Update to SAP Help Topic

Update to SAP Help Topic

The help for the defaults tab related to SAP r3 accounts should have this definition for Decimal Notation.

• Specifies the different ways to represent decimal notations.
• You can choose from the following:

  1.234.567,89

  1,234,567.89

  1 234567,89

Enable the Fix for Oracle Bug 6376915

The Oracle bug 6376915 causes high water (HW) enqueue contention when the database is busy handling large objects (LOB) and the database is configured to use automatic segments space management (ASSM).

This bug causes performance and scalability problems with CA software, including CA Identity Manager and CA CloudMinder.

The fix for this problem introduces a mandatory event. Set this new event to make the ASSM architecture allocate LOB chunks more efficiently.

This bug was introduced in Oracle 10.2.0.3. It was fixed in both Oracle 10.2.0.4 and Oracle 11.1.0.7. However, the fix is not enabled by default.

The steps in this procedure assume that spfile is used for configuration.

Follow these steps:

1. Enter the following command:

   ALTER SYSTEM SET EVENT='44951 TRACE NAME CONTEXT FOREVER, LEVEL 1024' scope=spfile;
   

2. Restart the database.
3. To test the fix, use the following measures:
   • Use Bulk Loader to measure the task throughput in CA Identity Manager and CA CloudMinder.
   • Measure the wait time for HW enqueue contention.

Failed to Execute the RequestUserToService Task

Symptom:

When Oracle 12c is used as Objectstore with Jboss 6.x as Application server Error message "Failed to execute RequestUserToService. ERROR MESSAGE: SmApiWrappedExceptionRA-01843: not a valid month" is displayed in the UI when a user is requesting for a Service.

Solution:

1. Stop the Jboss 6.x Application server.
2. Edit the file named Standalone-full.xml, available at <Jboss installed location>\Standalone\Configuration.
3. Search for the following text :

   jndi-name="java:/iam/im/jdbc/jdbc/objectstore".
   

4. Add the highlighted line shown below:

   <datasource jta="false" jndi-name="java:/iam/im/jdbc/jdbc/objectstore" pool-name="iam_im-imobjectstoredb-ds" enabled="true" use-java-context="true">
   <connection-url>jdbc:sqlserver://<hostname>:1433;selectMethod=cursor;DatabaseName=<ora_dbname></connection-url>
   <driver>sqljdbc</driver>
   
   <new-connection-sql>alter session set NLS_DATE_FORMAT='YYYY-MM-DD' NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SS.FF3'</new-connection-sql>
   

5. Add the highlighted line shown below in the same file and save it.

   <datasource jta="false" jndi-name="java:/iam/im/jdbc/jdbc/reportsnapshot" pool-name="iam_im-imreportsnapshotdb-ds" enabled="true" use-java-context="true">
   <connection-url>jdbc:sqlserver://<hostname>:1433;selectMethod=cursor;DatabaseName=<ora_dbname></connection-url>
   <driver>sqljdbc</driver>
   
   <new-connection-sql>alter session set NLS_DATE_FORMAT='YYYY-MM-DD' NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SS.FF3'</new-connection-sql>
   

6. Start the Application server.