Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Error while upgrading PPM from 8.2 to 9.10

Highlighted
raaj_reddy
Occasional Advisor

Error while upgrading PPM from 8.2 to 9.10

Hi,

 

While upgrading PPM from 8.2 to 9.10 we got an error during running "kintana_submit_request.pls".Could some one help me regarding this.

 

Log Deatils:--

 

sqlscript] Create or replace package kintana_submit_request as
[sqlscript] -- $Workfile: kintana_submit_request.pls$
[sqlscript] -- $Revision: 1$
[sqlscript] -- $Date: 6/24/08 5:55:44 PM PDT$
[sqlscript] -- $Project: Dev - Kintana$
[sqlscript] -- $Subproject$
[sqlscript] -- $Archive$
[sqlscript] -- $NoKeywords$

[sqlscript] -- This package contains all of the protected procedures and functions
[sqlscript] -- Kintana needs to call to submit O*M/GL*M concurrent requests to a
[sqlscript] -- local Oracle Applications instance. It references multiple
[sqlscript] -- core Oracle Applications packages.
[sqlscript] -- Only functions and procedures which must be called from the
[sqlscript] -- APPS account are included here.

[sqlscript] /************* FND_REQUEST functions *************/

[sqlscript] -- Procedure
[sqlscript] -- submit_request
[sqlscript] -- Purpose
[sqlscript] -- Calls standard function fnd_request.submit_request to submit
[sqlscript] -- a concurrent request.

[sqlscript] function submit_request (
[sqlscript] application IN varchar2 default NULL,
[sqlscript] program IN varchar2 default NULL,
[sqlscript] description IN varchar2 default NULL,
[sqlscript] start_time IN varchar2 default NULL,
[sqlscript] sub_request IN boolean default FALSE,
[sqlscript] argument1 IN varchar2 default CHR(0),
[sqlscript] argument2 IN varchar2 default CHR(0),
[sqlscript] argument3 IN varchar2 default CHR(0),
[sqlscript] argument4 IN varchar2 default CHR(0),
[sqlscript] argument5 IN varchar2 default CHR(0),
[sqlscript] argument6 IN varchar2 default CHR(0),
[sqlscript] argument7 IN varchar2 default CHR(0),
[sqlscript] argument8 IN varchar2 default CHR(0),
[sqlscript] argument9 IN varchar2 default CHR(0),
[sqlscript] argument10 IN varchar2 default CHR(0),
[sqlscript] argument11 IN varchar2 default CHR(0),
[sqlscript] argument12 IN varchar2 default CHR(0),
[sqlscript] argument13 IN varchar2 default CHR(0),
[sqlscript] argument14 IN varchar2 default CHR(0),
[sqlscript] argument15 IN varchar2 default CHR(0),
[sqlscript] argument16 IN varchar2 default CHR(0),
[sqlscript] argument17 IN varchar2 default CHR(0),
[sqlscript] argument18 IN varchar2 default CHR(0),
[sqlscript] argument19 IN varchar2 default CHR(0),
[sqlscript] argument20 IN varchar2 default CHR(0),
[sqlscript] argument21 IN varchar2 default CHR(0),
[sqlscript] argument22 IN varchar2 default CHR(0),
[sqlscript] argument23 IN varchar2 default CHR(0),
[sqlscript] argument24 IN varchar2 default CHR(0),
[sqlscript] argument25 IN varchar2 default CHR(0),
[sqlscript] argument26 IN varchar2 default CHR(0),
[sqlscript] argument27 IN varchar2 default CHR(0),
[sqlscript] argument28 IN varchar2 default CHR(0),
[sqlscript] argument29 IN varchar2 default CHR(0),
[sqlscript] argument30 IN varchar2 default CHR(0),
[sqlscript] argument31 IN varchar2 default CHR(0),
[sqlscript] argument32 IN varchar2 default CHR(0),
[sqlscript] argument33 IN varchar2 default CHR(0),
[sqlscript] argument34 IN varchar2 default CHR(0),
[sqlscript] argument35 IN varchar2 default CHR(0),
[sqlscript] argument36 IN varchar2 default CHR(0),
[sqlscript] argument37 IN varchar2 default CHR(0),
[sqlscript] argument38 IN varchar2 default CHR(0),
[sqlscript] argument39 IN varchar2 default CHR(0),
[sqlscript] argument40 IN varchar2 default CHR(0),
[sqlscript] argument41 IN varchar2 default CHR(0),
[sqlscript] argument42 IN varchar2 default CHR(0),
[sqlscript] argument43 IN varchar2 default CHR(0),
[sqlscript] argument44 IN varchar2 default CHR(0),
[sqlscript] argument45 IN varchar2 default CHR(0),
[sqlscript] argument46 IN varchar2 default CHR(0),
[sqlscript] argument47 IN varchar2 default CHR(0),
[sqlscript] argument48 IN varchar2 default CHR(0),
[sqlscript] argument49 IN varchar2 default CHR(0),
[sqlscript] argument50 IN varchar2 default CHR(0),
[sqlscript] argument51 IN varchar2 default CHR(0),
[sqlscript] argument52 IN varchar2 default CHR(0),
[sqlscript] argument53 IN varchar2 default CHR(0),
[sqlscript] argument54 IN varchar2 default CHR(0),
[sqlscript] argument55 IN varchar2 default CHR(0),
[sqlscript] argument56 IN varchar2 default CHR(0),
[sqlscript] argument57 IN varchar2 default CHR(0),
[sqlscript] argument58 IN varchar2 default CHR(0),
[sqlscript] argument59 IN varchar2 default CHR(0),
[sqlscript] argument60 IN varchar2 default CHR(0),
[sqlscript] argument61 IN varchar2 default CHR(0),
[sqlscript] argument62 IN varchar2 default CHR(0),
[sqlscript] argument63 IN varchar2 default CHR(0),
[sqlscript] argument64 IN varchar2 default CHR(0),
[sqlscript] argument65 IN varchar2 default CHR(0),
[sqlscript] argument66 IN varchar2 default CHR(0),
[sqlscript] argument67 IN varchar2 default CHR(0),
[sqlscript] argument68 IN varchar2 default CHR(0),
[sqlscript] argument69 IN varchar2 default CHR(0),
[sqlscript] argument70 IN varchar2 default CHR(0),
[sqlscript] argument71 IN varchar2 default CHR(0),
[sqlscript] argument72 IN varchar2 default CHR(0),
[sqlscript] argument73 IN varchar2 default CHR(0),
[sqlscript] argument74 IN varchar2 default CHR(0),
[sqlscript] argument75 IN varchar2 default CHR(0),
[sqlscript] argument76 IN varchar2 default CHR(0),
[sqlscript] argument77 IN varchar2 default CHR(0),
[sqlscript] argument78 IN varchar2 default CHR(0),
[sqlscript] argument79 IN varchar2 default CHR(0),
[sqlscript] argument80 IN varchar2 default CHR(0),
[sqlscript] argument81 IN varchar2 default CHR(0),
[sqlscript] argument82 IN varchar2 default CHR(0),
[sqlscript] argument83 IN varchar2 default CHR(0),
[sqlscript] argument84 IN varchar2 default CHR(0),
[sqlscript] argument85 IN varchar2 default CHR(0),
[sqlscript] argument86 IN varchar2 default CHR(0),
[sqlscript] argument87 IN varchar2 default CHR(0),
[sqlscript] argument88 IN varchar2 default CHR(0),
[sqlscript] argument89 IN varchar2 default CHR(0),
[sqlscript] argument90 IN varchar2 default CHR(0),
[sqlscript] argument91 IN varchar2 default CHR(0),
[sqlscript] argument92 IN varchar2 default CHR(0),
[sqlscript] argument93 IN varchar2 default CHR(0),
[sqlscript] argument94 IN varchar2 default CHR(0),
[sqlscript] argument95 IN varchar2 default CHR(0),
[sqlscript] argument96 IN varchar2 default CHR(0),
[sqlscript] argument97 IN varchar2 default CHR(0),
[sqlscript] argument98 IN varchar2 default CHR(0),
[sqlscript] argument99 IN varchar2 default CHR(0),
[sqlscript] argument100 IN varchar2 default CHR(0))
[sqlscript] return number;


[sqlscript] /************* FND_GLOBAL procedures *************/

[sqlscript] -- Procedure
[sqlscript] -- apps_initialize
[sqlscript] -- Purpose
[sqlscript] -- Calls standard procedure fnd_global.apps_initialize to initialize
[sqlscript] -- global and profile variables for a non-forms context.
[sqlscript] procedure APPS_INITIALIZE(p_user_id in number,
[sqlscript] p_resp_id in number,
[sqlscript] p_resp_appl_id in number,
[sqlscript] p_security_group_id in number default 0);


[sqlscript] /************* FND_PROFILE functions *************/
[sqlscript] -- Procedure
[sqlscript] -- profile_initialize
[sqlscript] -- Purpose
[sqlscript] -- Calls standard procedure fnd_profile.initialize to initialize
[sqlscript] -- profile variables
[sqlscript] procedure PROFILE_INITIALIZE(p_user_id in number,
[sqlscript] p_responsibility_id in number,
[sqlscript] p_application_id in number,
[sqlscript] p_site_id in number);


[sqlscript] /************* TABLE_EXISTS utility function **************/
[sqlscript] -- Function
[sqlscript] -- table_exists
[sqlscript] -- Purpose
[sqlscript] -- Checks for the existence of a given table in the OraApps
[sqlscript] -- instance. Used when Kintana may not have direct visibility
[sqlscript] -- to the table but needs to check existence.
[sqlscript] -- In case of error, FALSE is returned
[sqlscript] function TABLE_EXISTS (p_table_name in varchar2,
[sqlscript] p_owner in varchar2 default null)
[sqlscript] return boolean;

[sqlscript] end kintana_submit_request;

[sqlscript] java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
FAILED: Thu Jun 13 22:24:28 GMT+00:00 2013
Duration: 00h:02m:46s

BUILD FAILED
/toolsglobal/kintp1/kintp1/upgrade_910/xml/upgrade.xml:42: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object


Total time: 4 minutes 26 seconds
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)
at com.kintana.sqlminus.commands.PLSQLCommand.execute(PLSQLCommand.java:63)
at com.kintana.sqlminus.ExecutionDriver.executeBlock(ExecutionDriver.java:251)
at com.kintana.sqlminus.ExecutionDriver.execute(ExecutionDriver.java:211)
at com.kintana.sqlminus.ExecutionDriver.execute(ExecutionDriver.java:201)
at com.kintana.upgrade.xml.commands.SqlScriptCommand.runFiles(SqlScriptCommand.java:147)
at com.kintana.upgrade.xml.commands.SqlScriptCommand.execute(SqlScriptCommand.java:56)
at com.kintana.upgrade.xml.elements.SqlScriptTask.execute(SqlScriptTask.java:195)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at com.kintana.upgrade.xml.ItgCheema.runBuild(ItgCheema.java:432)
at com.kintana.upgrade.xml.ItgCheema.start(ItgCheema.java:300)
at com.kintana.ismp.bean.actions.CheemaRunner.action(CheemaRunner.java:98)
at com.kintana.ismp.bean.actions.KintanaAction.execute(KintanaAction.java:90)
at com.installshield.wizard.RunnableWizardBeanContext.run(RunnableWizardBeanContext.java:21)

 

 

Regards,

Raju  Reddy Baddam

2 REPLIES
ieroglif
Super Collector

Re: Error while upgrading PPM from 8.2 to 9.10

The answer at the log:

 

[sqlscript] java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
FAILED: Thu Jun 13 22:24:28 GMT+00:00 2013

 

Check your existing tables,views and synonyms or modify or drop the existing object so it can be reused.

 

Best Regards,
Ieroglif.
Utkarsh_Mishra
Honored Contributor

Re: Error while upgrading PPM from 8.2 to 9.10

Take back up of function "TABLE_EXISTS" and then drop it.

 

Finally run the upgrade agian.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
//Add this to "OnDomLoad" event