You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "Pradeep Agrawal (Jira)" <ji...@apache.org> on 2020/02/26 10:14:00 UTC
[jira] [Commented] (RANGER-2742) Database patch 046 does not apply
correctly on SQL Server and SQL Anywhere
[ 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)