Okta Group Push to Google Workspace Fails with an Unable to Update Target App Group Error

Okta generates an error when pushing groups to Google Workspace due to a duplicate entry for the external ID and instance key. Resolve this issue by unlinking the push group, refreshing the application group, and pushing the group again. When attempting to push groups to Google Workspace, Okta generates the following error: 

Failed on xx-xx-20xx xx:xx:xx UTC: Unable to update Group Push mapping target App group xxx.

• Okta Identity Engine (OIE)
• Okta Classic Engine
• Google Workspace
• Group Push

This error appears when a duplicate entry exists for the key externalIdAndInstanceKey. Okta generates the following example error in the logs:

Could not execute statement; SQL [n/a]; constraint [externalIdAndInstanceKey]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement. 

How is the Group Push mapping error resolved?

Verify that there are no changes on the application or group side, unlink the push group, and retry the group push.

1. Verify that no changes exist on the application side or the group side.
2. Unlink the Push Group and select the Leave the group in the target app option.
3. Refresh the App Group and push the group again.
4. If Okta generates a Pushing groups that have the same name and AppInstance is unsupported error, delete the cloned groups using the Application Programming Interface (API) endpoint:

5. Push the group again.