SAP Knowledge Base Article - Public

2926645 - "dberror (Prepared Statement:execute Update): - 129 transaction rolled by an internal error" in SAP Analytics Cloud (SAC)

Symptom

The following error message occurs in SAP Analytics Cloud (SAC):
dberror (Prepared Statement:execute Update): - 129 transaction rolled by an internal error:External user name *** already exists on provider

Environment

SAP Analytics Cloud (Enterprise) 

Reproducing the Issue

  1. Log in to SAP Analytics Cloud. 
  2. Navigate Security -> Users.
  3. Create a new user.
  4. Observe the error message.

Cause

User already exists on Identity Provider and has not been activated yet.

Resolution

  • Ask user to activate the account.
  • If user has not received welcome e-mail, ask user to navigate to the tenant homepage and click "Forgot password" option. It will trigger a password reset e-mail which would activate an account.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, s, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics,  SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable to create new user , user has no access Access,, Sac, Set, setup new user, Failed to create new user, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, dberror (Prepared Statement:execute Update): - 129 transaction rolled by an internal error:External user  name  already exists on provider,  name already exiists on provider, dberror (Prepared Statement:execute Update),  129 transaction rolled by an internal error, External user name already exists on provider, username, email , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0