We are performing Userapplication upgrade from 3.5.1 to 3.7

Context root used is IDM
schema name used in 3.5.1 :IDM_DEV_USERAPP
While installaing the Userapplication 3.7 over the Existing Database
schema (used in Userapp 3.5.1)

We received below error.

Mar 9, 2010 10:13:37 AM liquibase.commandline.Main main
SEVERE: Error executing SQL UPDATE PROFILEUSERPREFERENCES SET ELEMENTID
= 'IDM' WHERE ELEMENTID != 'IDM' and ELEMENTID not like '%.%'
liquibase.exception.MigrationFailedException: Migration failed for
change set UpdateProducerId.xml::2000::IDMRBPM:
Reason: liquibase.exception.JDBCException: Error executing SQL
UPDATE PROFILEUSERPREFERENCES SET ELEMENTID = 'IDM' WHERE ELEMENTID !=
'IDM' and ELEMENTID not like '%.%':
Caused By: Error executing SQL UPDATE PROFILEUSERPREFERENCES
SET ELEMENTID = 'IDM' WHERE ELEMENTID != 'IDM' and ELEMENTID not like
'%.%':
Caused By: ORA-00001: unique constraint
(IDM_DEV_USERAPP.USRPRFS_USRIID_UK) violated

at liquibase.ChangeSet.execute(ChangeSet.java:260)
at
liquibase.parser.visitor.UpdateVisitor.visit(Updat eVisitor.java:26)
at
liquibase.parser.ChangeLogIterator.run(ChangeLogIt erator.java:41)
at liquibase.Liquibase.update(Liquibase.java:112)
at liquibase.commandline.Main.doMigration(Main.java:6 50)
at liquibase.commandline.Main.main(Main.java:97)
Caused by: liquibase.exception.JDBCException: Error executing SQL
UPDATE PROFILEUSERPREFERENCES SET ELEMENTID = 'IDM' WHERE ELEMENTID !=
'IDM' and ELEMENTID not like '%.%'
at
liquibase.database.template.JdbcTemplate.execute(J dbcTemplate.java:55)
at
liquibase.database.template.JdbcTemplate.execute(J dbcTemplate.java:86)
at
liquibase.change.AbstractChange.execute(AbstractCh ange.java:247)
at
liquibase.change.AbstractChange.executeStatements( AbstractChange.java:93)
at liquibase.ChangeSet.execute(ChangeSet.java:236)
... 5 more
Caused by: java.sql.SQLException: ORA-00001: unique constraint
(IDM_DEV_USERAPP.USRPRFS_USRIID_UK) violated

at
oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112)
at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:331)
at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 745)
at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:210)
at
oracle.jdbc.driver.T4CStatement.executeForRows(T4C Statement.java:961)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1190)
at
oracle.jdbc.driver.OracleStatement.executeInternal (OracleStatement.java:1726)
at
oracle.jdbc.driver.OracleStatement.execute(OracleS tatement.java:1696)
at
liquibase.database.template.JdbcTemplate$1ExecuteS tatementCallback.doInStatement(JdbcTemplate.java:7 8)
at
liquibase.database.template.JdbcTemplate.execute(J dbcTemplate.java:48)
... 9 more

Any idea why this error we are getting.

Let me know if any information needed.


--
lvaradha
------------------------------------------------------------------------
lvaradha's Profile: http://forums.novell.com/member.php?userid=77512
View this thread: http://forums.novell.com/showthread.php?t=404193