Discussion

3
Replies
654
Views
Close popover
Vigneshwaran Aravindhan (VigneshAravind)
Cognizant
Senior Technology Architect
Cognizant
IN
VigneshAravind Member since 2007 28 posts
Cognizant
Posted: May 4, 2016
Last activity: April 6, 2018
Closed

ORA-01749 : you may not GRANT/REVOKE privileges to/from yourself

We were performing the third step of a split schema upgrade (6.2.1 to 7.1.9) "Generate and Apply Rules Schema Objects".

We have received the following error while running the migrate.sh in a Unix + Oracle Setup. Kindly post your suggestions.

[java] 2016-05-03 04:41:34,429 ( SQLLoader) INFO - GRANT ALL ON
[java] 2016-05-03 04:41:34,436 ( SQLLoader) INFO - File: oracledate00550.sql
[java] 2016-05-03 04:41:34,437 ( SQLLoader) INFO - GRANT INSERT ON
[java] 2016-05-03 04:41:34,443 ( SQLLoader) WARNING - Failed to execute SQL in file oracledate00550.sql
[java]
[java] java.sql.SQLSyntaxErrorException: ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
[java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
[java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
[java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
[java] at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:266)
[java] 2016-05-03 04:41:34,445 ( SQLLoader) WARNING - Statement: GRANT insert ON PEGA_APP.pr_sys_updatescache TO pega_user
[java] Exception in thread "main" com.pega.pegarules.install.SQLLoader$SQLLoaderException:
[java] ********************************************************************************
[java]
[java] Encountered a SQL Exception, clean schema before running again.
[java]
[java] ********************************************************************************
[java] at com.pega.pegarules.install.SQLLoader.fail(SQLLoader.java:359)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:316)

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

System Administration Upgrades
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.