Summary:

The CRMJ webapp was unable to execute eware_get_identity_ID.

Symptoms:

The following error was logged:

ERROR: 28-Apr-2013 23:55:16.106 com.sage.scrm.model.error.SageSynchronizationException: com.sage.scrm.model.error.SageDataAccessException: Data access failure.

Sync Activity Exchange to CRM:
ERROR: 19-Apr-2013 15:39:35.323 com.sage.scrm.model.db.error.SageIdentityGeneratorException: com.sage.scrm.model.db.error.SageQueryException: org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{? = call eware_get_identity_id(?)}]; nested exception is java.sql.SQLException: ORA-01031: insufficient privileges
ORA-06512: at "SA.CRM_RECREATE_SEQUENCE", line 18
ORA-06512: at "SA.EWARE_GET_IDENTITY_ID", line 70
ORA-06512: at line 1

Work around / Resolution:

The CRM database user did not have rights to execute eware_get_identity_id. Granting privileges to the user resolved the issue. It may be worthwhile making sure that the users defined in the registry and the jdbc.properties match.