2922440 - Error: "Invalid User Name" when trying to save a model to a folder

After creating a new model and trying to save it in a specific folder, you get the error:

---------

Model "ModelName" creation has failed. Please try again. Error detail: dberror(Connection.prepareStatement): 332 - invalid user name: TEAM:t.1.t.1:MyTeamName: line 1 col 102 (at pos 101)

"Statement@/sap/fpa/services/core/db/DbStatement.xsjslib:61\nConnection.prototype.prepareStatement@/sap/fpa/services/core/db/DbConnection.xsjslib:247\nConnection.prototype.execute@sap/fpa/services/core/db/DbConnection.xsjslib:359\nDataAccess.executeGrant@/sap/fpa/services/security/DataAccess.xsjslib:2020\nDataAccess.grantSqlAP@/sap/fpa/services/security/DataAccess.xsjslib:2270\nDataAccess.grantAnalyticViewSqlAP@/sap/fpa/services/security/DataAccess.xsjslib:4355\nDataAccess.grantAnalyticViewSqlAPToTeam@/sap/fpa/services/security/DataAccess.xsjslib:4464\nContentlibManagerUtils._grantRevokeSQLAP@/sap/fpa/services/contentlib/ContentlibManagerUtils.xsjslib:795\nContentlibManagerUtils.updateSQLAPAssignments@/sap/fpa/services/contentlib/ContentlibManagerUtils.xsjslib:116\n\ContentlibManager.prototype._setUserShare@/sap/fpa/services/contentlib/ContentlibManager.xsjslib:4854\n\ContentlibManager.prototype._inheritParentAccess@/sap/fpa/services/contentlib/ContentlibManager.xsjslib:5267\nContentlibManager.prototype.createContent@/sap/fpa/services/contentlib/ContentlibManager.xsjslib:3584\n\DataSourceService.prototype.createModel@/sap/fpa/services/dm/excel/DataSourceService.xsjslib:450\nDmMediator.prototype.createModelAndImportData@/sap/fpa/services/dm/excel/DmMediator.xsjslib:2766\nDmMediator.prototype.createDimensionScheduled@/sap/fpa/services/dm/excel/DmMediator.xsjslib:4897\ndoAction@/sap/fpa/services/dm/DataIntegrationScheduleManager.xsjslib:76\nrun@sap/fpa/services/job/Schedule.xsjs:123\n"{"sFileID":"a9eeaf8c2109461c8d95ea78a6df8ef6"}.

-------------

This only happens when saving to specific folders.

• SAP Analytics Cloud 2020.9.3 

This issue happens when a team has been deleted, but the sharing rights assigned to that team did not get removed from the objects / folders they were assigned to.

If you attempt to remove the rights from the folder, you will get the error "Invalid Team" as the team no longer exists.

To resolve the issue, do the following:

1. In the error message the problem team shows up as "TEAM:t.1.t.1:MyTeamName"
2. t.1.t.1 is the namespace of the team, so create a new team with the name "MyTeamName"
3. You should now be able to remove the problem permissions from the folder.  If the permissions are inherited, be sure to remove them from the base folder that they were inherited from.

SAC, failed, creation, right, rights, roles , KBA , LOD-ANA-ADM , SAC Administration , Problem