Member since
03-31-2017
13
Posts
1
Kudos Received
0
Solutions
04-24-2017
11:35 PM
I found the root cause, ambari user which is created for oracle DB not have enough privileges to drop the Constraint. When I run ambari-server update the constraint is not dropping and not replacing new constraint.
... View more
04-24-2017
11:35 PM
Hi, PFA I was trying to upgrade ambari 2.5.0.3 ambari-server upgrade facing below error, ERROR [main]
DBAccessorImpl:847 - Error executing query: ALTER TABLE
hostcomponentdesiredstate ADD CONSTRAINT PK_hostcomponentdesiredstate PRIMARY
KEY (id)java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an
existing object . Failed to run the Amba ri Server
org.apache.ambari.server.AmbariException: Current database store version is not compatible with current server version, serverVersion=2.5.0.3, schemaVersion=2.4 .2
at org.apache.ambari.server.checks.DatabaseConsistencyCheckHelper.checkD BVersionCompatible(DatabaseConsistencyCheckHelper.java:222)
at org.apache.ambari.server.controller.AmbariServer.main(AmbariServer.ja va:1002) Oracle Database need to update Schema automatically once ambari-server upgrade, but some how i am geting above issues. any solution ?
... View more
Labels: