[
https://issues.apache.org/jira/browse/RANGER-2742?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17045335#comment-17045335
]
Pradeep Agrawal commented on RANGER-2742:
-----------------------------------------
[~andrewluo] Did you test RANGER-2713 patch for delete user case ?
Its seems failing like :
{code:java}
2020-02-26 07:43:32,350 [http-bio-6080-exec-18] ERROR
org.apache.catalina.core.StandardWrapperValve (StandardWrapperValve.java:266) -
Servlet.service() for servlet [REST Service] in context with path [] threw
exception
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse
Persistence Services - 2.5.2.v20140319-9ad6abd):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Unknown column 'added_by_id' in 'where clause'
Error Code: 1054
Call: update x_policy_ref_condition set added_by_id=null where added_by_id=61
Query: DataModifyQuery(sql="update x_policy_ref_condition set added_by_id=null
where added_by_id=61")
at
org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:308)
at
org.apache.ranger.common.db.BaseDao.updateUserIDReference(BaseDao.java:303)
at
org.apache.ranger.service.XPortalUserService.updateXXPortalUserReferences(XPortalUserService.java:291)
at org.apache.ranger.biz.XUserMgr.deleteXUser(XUserMgr.java:2265)
{code}
> Database patch 046 does not apply correctly on SQL Server and SQL Anywhere
> --------------------------------------------------------------------------
>
> Key: RANGER-2742
> URL: https://issues.apache.org/jira/browse/RANGER-2742
> Project: Ranger
> Issue Type: Bug
> Components: Ranger
> Affects Versions: master
> Reporter: Andrew Luo
> Priority: Critical
> Fix For: master
>
> Attachments:
> 0001-RANGER-2742-Fix-database-patch-046-on-SQL-Server-and-SQL-Anywher.patch
>
>
> On SQL Anywhere the constraint and column names are swapped in some
> statements. In SQL Server, the same problem exists in addition to not
> properly dropping the default constraint.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
