ERM - Problems with imported roles

[Former Member]

Is it possible that a role is successfully imported into ERM yet not all of its authorization data getting imported?

We are configuring ERM 5.3, and so far we have imported a group of roles from the backend without errors (the job details shows "Role xxxx imported successfully" for each role).

However, analyzing some of the imported roles, we are finding that some authorization data is missing in the ERM (objects imported but not all of their fields/values, and even objects not imported at all). This data is present in the downloaded file from the back end and obviously in the pfcg, but is not getting imported into ERM.

Is this behavior correct? Did we miss something?

[hkaur · Accepted solution]

Please increase the pool size to 100 connections and the time to wait for connection to 60 seconds. SAP Note 719778 also gives some guidelines to be followed for this error.

[Former Member]

Adding more info on this thread, the synchronization job for Transaction/Object/Field finally completed. In spite of the error:

"Error synchronizing transaction information for <language> and connector DE1: Statement is closed. at the index 501 Transaction Id"

apparently the synchronization of objects, classes, fields, etc have completed without any errors for every language, and the job shows status "Completed".

Later, we ran the mass role import again, and now all roles are apparently successfully imported with all authorization data.

So the initial problem of roles being imported with some auth data missing is solved now that the Transaction/Object/Field sync job finally completed.

Nevertheless we are still in doubt if these errors will affect or not the normal operations of ERM.

Has anybody faced these errors before?

[Former Member]

Thank you Harleen for your response.

We have duplicated all the values recommended in the post-installation guide and the first error of the above post haven't ocurred again.

But now, every time we run the synchronization for Transaction/Object/Field several times, the job always throws the following errors:

17 11/10/08 11:01:39 AM Running Synchronization of transaction information for German and connector DE1 started

17 11/10/08 11:02:16 AM Error Error synchronizing transaction information for German and connector DE1: Statement is closed. at the index 501 Transaction Id

17 11/10/08 11:02:16 AM Running Synchronization of transaction information for English and connector DE1 started

17 11/10/08 11:02:41 AM Error Error synchronizing transaction information for English and connector DE1: Statement is closed. at the index 501 Transaction Id

17 11/10/08 11:02:41 AM Running Synchronization of transaction information for Spanish and connector DE1 started

17 11/10/08 11:03:05 AM Error Error synchronizing transaction information for Spanish and connector DE1: Statement is closed. at the index 501 Transaction Id

17 11/10/08 11:03:05 AM Running Synchronization of transaction information for French and connector DE1 started

17 11/10/08 11:03:27 AM Error Error synchronizing transaction information for French and connector DE1: Statement is closed. at the index 501 Transaction Id

17 11/10/08 11:03:27 AM Running Synchronization of transaction information for Hungarian and connector DE1 started

17 11/10/08 11:03:50 AM Error Error synchronizing transaction information for Hungarian and connector DE1: Statement is closed. at the index 501 Transaction Id

17 11/10/08 11:03:50 AM Running Synchronization of transaction information for Italian and connector DE1 started

17 11/10/08 11:04:13 AM Error Error synchronizing transaction information for Italian and connector DE1: Statement is closed. at the index 501 Transaction Id

17 11/10/08 11:04:13 AM Running Synchronization of transaction information for Japanese and connector DE1 started

17 11/10/08 11:04:36 AM Error Error synchronizing transaction information for Japanese and connector DE1: Statement is closed. at the index 501 Transaction Id

17 11/10/08 11:04:36 AM Running Synchronization of transaction information for Korean and connector DE1 started

17 11/10/08 11:05:00 AM Error Error synchronizing transaction information for Korean and connector DE1: Statement is closed. at the index 501 Transaction Id

17 11/10/08 11:05:00 AM Running Synchronization of transaction information for Portuguese and connector DE1 started

17 11/10/08 11:05:25 AM Error Error synchronizing transaction information for Portuguese and connector DE1: Statement is closed. at the index 501 Transaction Id

17 11/10/08 11:05:25 AM Running Synchronization of transaction information for Russian and connector DE1 started

17 11/10/08 11:05:49 AM Error Error synchronizing transaction information for Russian and connector DE1: Statement is closed. at the index 501 Transaction Id

17 11/10/08 11:05:49 AM Running Synchronization of transaction information for Chinese and connector DE1 started

17 11/10/08 11:06:14 AM Error Error synchronizing transaction information for Chinese and connector DE1: Statement is closed. at the index 501 Transaction Id

Any ideas of what might be the cause of this errors?

[Former Member]

Hi experts,

I would like to add more data about this issue.

When running the synchronization for Transaction/Object/Field for the first time, the job ended with the following error:

"ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.connector.exceptions.BaseResourceException: Cannot get connection for 120 seconds.

Possible reasons: 1) Connections are cached within SystemThread(can be any server service or any code invoked within SystemThread in the SAP J2EE Engine), 2) The pool size of adapter "SAPSR3DB" is not enough according to the current load of the system or 3) The specified time to wait for connection is not enough according to

the pool size and current load of the system. In case 1) the solution is to check for cached connections using the Connector Service list-conns command, in case 2) to increase the size of the pool and in case 3) to increase the time to wait for connection property. In case of application thread, there is an automatic mechanism which detects unclosed connections and unfinished transactions."

Nevertheless, the Org Value Sync job and the Activity Sync job ended successfully.

So we've tried to run this sync again, and now it is throwing the following error for every language:

"Error synchronizing transaction information for <language> and connector DE1: Statement is closed. at the index 501 Transaction Id".

In spite of the errors mentioned, we have imported a group of roles from the backend without errors (the job detail shows "Role xxxx imported successfully" for each role). However, the roles imported to ERM do not contain all the authorization data present in the downloaded text file from the backend system.

Do you think that this is due to the faild Transaction/Object/Field synchronization?

What steps would you recommend to fix this issue?