Project and Portfolio Management Practitioners Forum
cancel

Error when try upgrade PPM 7.5 to 8

SOLVED
Go to solution
Highlighted
Bruno_Iemma
Frequent Contributor.

Error when try upgrade PPM 7.5 to 8

Hi, i´m upgrading PPM to 8.0 and get this error.

I try to debug this in TOAD editor, but icant find the error

Regards,

Bruno.-

 

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Task:      sqlscript PRESEED
Started:   Fri Mar 16 16:20:00 ARST 2012
[sqlscript]            This step has not been run, will run now*** running compile_schema.sql
[sqlscript] *** running core/knta_languages_800_2.sql
[sqlscript] *** running knta_upgrade_records_800_1.sql
[sqlscript] *** running reference_code_800_1.sql
[sqlscript] *** running reference_code_800_2.sql
[sqlscript] *** running drv/kdrv_calendars_800_2.sql
[sqlscript] *** running dsh/delete_portlets_800_1.sql
[sqlscript] *** running dsh/delete_portlet_categories_800_1.sql
[sqlscript] *** running core/delete_special_commands_preseed.sql
[sqlscript] *** running core/delete_param_set_fields_preseed_800.sql
[sqlscript] *** running core/knta_help_contents_nls_800_1.sql
[sqlscript] *** running core/update_param_set_fields_preseed_800.sql
[sqlscript] *** running core/update_knta_parameter_set_fields_800_1.sql
[sqlscript] *** running core/update_knta_lookups_800_1.sql
[sqlscript] *** running core/update_knta_lookups_800_2.sql
[sqlscript] *** running compile_schema.sql
[sqlscript] *** running core/knta_languages_800_2.sql
[sqlscript] DECLARE
[sqlscript]
[sqlscript]      l_server_conf_system_lang varchar2(10);
[sqlscript]      l_system_language_id NUMBER;
[sqlscript]      l_ErrorText VARCHAR2(300);
[sqlscript]      l_SQLTemp VARCHAR2(300);
[sqlscript]      l_underline_location NUMBER;
[sqlscript]
[sqlscript]      SCRIPT_NAME CONSTANT VARCHAR2(30) := 'update_system_lang_800.sql';
[sqlscript]      LOCALE_NOT_SET EXCEPTION;
[sqlscript]      LANG_ID_NOT_FOUND EXCEPTION;
[sqlscript]
[sqlscript]   BEGIN
[sqlscript]
[sqlscript]     DBMS_OUTPUT.Put_Line('File ' || SCRIPT_NAME || ' Started at ' || TO_CHAR(CURRENT_DATE, 'MON-DD-YYYY HH24:MI:SS'));
[sqlscript]
[sqlscript]     EXECUTE IMMEDIATE 'update KNTA_APP_SERVER_PROPERTIES set VALUE=''it_IT'' where VALUE=''it'' and KEY= ''INSTALLATION_LOCALE'' ';
[sqlscript]     EXECUTE IMMEDIATE 'update KNTA_APP_SERVER_PROPERTIES set VALUE=''es_ES'' where VALUE=''es'' and KEY= ''INSTALLATION_LOCALE'' ';
[sqlscript]     EXECUTE IMMEDIATE 'update KNTA_APP_SERVER_PROPERTIES set VALUE=''tr''    where VALUE=''tr_TR'' and KEY= ''INSTALLATION_LOCALE'' ';
[sqlscript]
[sqlscript]     -- fetch the row from KNTA_APP_SERVER_PROPERTIES table to get the current Value for the System Lang.
[sqlscript]     Select distinct VALUE Into l_server_conf_system_lang From KNTA_APP_SERVER_PROPERTIES a,KNTA_LANGUAGES l Where a.KEY= 'INSTALLATION_LOCALE' AND Instr(a.value, L.ISO_LANG_CODE) = 1;
[sqlscript]
[sqlscript]     If l_server_conf_system_lang is NULL then
[sqlscript]        Raise LOCALE_NOT_SET ;
[sqlscript]     End If;
[sqlscript]
[sqlscript]     DBMS_OUTPUT.Put_Line('The Installation Locale: ' || l_server_conf_system_lang);
[sqlscript]
[sqlscript]     -- Find out the language based on the data from the KNTA_APP_SERVER_PROPERTIES (server.conf)
[sqlscript]     l_SQLTemp := ' Select LANGUAGE_ID From KNTA_LANGUAGES Where ISO_LANG_CODE = substr('''||l_server_conf_system_lang||''', 1, 2)';
[sqlscript]     select instr(l_server_conf_system_lang,'_', 1, 1) into l_underline_location from dual;
[sqlscript]
[sqlscript]     If (l_underline_location=0) Then
[sqlscript]         l_SQLTemp :=  l_SQLTemp || ' And ISO_COUNTRY_CODE is NULL ';
[sqlscript]     Else
[sqlscript]         l_SQLTemp :=  l_SQLTemp || ' And ISO_COUNTRY_CODE = substr('''||l_server_conf_system_lang||''',instr('''||l_server_conf_system_lang||''',''_'', 1, 1)+1)';
[sqlscript]     End If;
[sqlscript]
[sqlscript]     EXECUTE IMMEDIATE l_SQLTemp Into l_system_language_id;
[sqlscript]     If l_system_language_id is NULL then
[sqlscript]        Raise LANG_ID_NOT_FOUND ;
[sqlscript]     End if;
[sqlscript]
[sqlscript]     DBMS_OUTPUT.Put_Line('The Language_id : ' || l_system_language_id );
[sqlscript]
[sqlscript]     -- First Set all the values for SYSTEM_LANGUAGE as 'N'.
[sqlscript]     EXECUTE IMMEDIATE 'UPDATE KNTA_LANGUAGES SET SYSTEM_LANGUAGE = ''N'' ';
[sqlscript]
[sqlscript]     -- Set SYSTEM_LANGUAGE and installed language flag to 'Y' to only a language that's been set in KNTA_APP_SERVER_PROPERTIES (server.conf)
[sqlscript]     EXECUTE IMMEDIATE 'UPDATE KNTA_LANGUAGES SET SYSTEM_LANGUAGE = ''Y'', installed_language_flag = ''Y'' WHERE LANGUAGE_ID =  '|| l_system_language_id;
[sqlscript]
[sqlscript]     -- Update DEPLOYED set deployed flag to 'Y'
[sqlscript]     EXECUTE IMMEDIATE 'UPDATE KNTA_LANGUAGES SET DEPLOYED =''Y'' WHERE SYSTEM_LANGUAGE = ''Y'' ';
[sqlscript]
[sqlscript]     DBMS_OUTPUT.Put_Line('File ' || SCRIPT_NAME || ' Returning at ' || TO_CHAR(CURRENT_DATE, 'MON-DD-YYYY HH24:MI:SS'));
[sqlscript]     RETURN;
[sqlscript]
[sqlscript]       EXCEPTION
[sqlscript]            WHEN LOCALE_NOT_SET THEN
[sqlscript]                 l_ErrorText := ' There is no installation locale set in the Server.Conf (KNTA_APP_SERVER_PROPERTIES table)';
[sqlscript]                 DBMS_OUTPUT.Put_line('The following error occured: ORA' || SQLCODE || ' : '|| l_ErrorText);
[sqlscript]                 DBMS_OUTPUT.Put_Line('update_system_lang_800: Returning at ' || TO_CHAR(CURRENT_DATE, 'MON-DD-YYYY HH24:MI:SS'));
[sqlscript]                 RAISE;
[sqlscript]
[sqlscript]             WHEN LANG_ID_NOT_FOUND THEN
[sqlscript]                 l_ErrorText := ' There is no language found in table KNTA_LANGUAGES corresponding to the Server.conf setting.';
[sqlscript]                 DBMS_OUTPUT.Put_line('The following error occured: ORA' || SQLCODE || ' : '|| l_ErrorText);
[sqlscript]                 DBMS_OUTPUT.Put_Line('update_system_lang_800: Returning at ' || TO_CHAR(CURRENT_DATE, 'MON-DD-YYYY HH24:MI:SS'));
[sqlscript]                 RAISE;
[sqlscript]
[sqlscript]             WHEN OTHERS THEN
[sqlscript]                 DBMS_OUTPUT.Put_line('The following error occured: ORA' || SQLCODE || ' : '|| SQLERRM);
[sqlscript]                 DBMS_OUTPUT.Put_Line('add_default_system_language: Returning at ' || TO_CHAR(CURRENT_DATE, 'MON-DD-YYYY HH24:MI:SS'));
[sqlscript]                 RAISE;
[sqlscript] END;

[sqlscript] java.sql.SQLException: ORA-01403: no data found
[sqlscript] ORA-06512: at line 75
FAILED:    Fri Mar 16 16:21:32 ARST 2012
Duration:  00h:01m:32s

BUILD FAILED
D:\PPM\upgrade_800\xml\upgrade-75-to-80.xml:48: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at line 75


Total time: 1 minute 32 seconds
java.sql.SQLException: ORA-01403: no data found
ORA-06512: at line 75

 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
 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)

7 REPLIES
dirkf
Acclaimed Contributor.

Re: Error when try upgrade PPM 7.5 to 8

Hi Bruno,

 

I've seen this before. The issue occurs when you have a spanish, turkish or italan language pack deployed on 7.5 - at least, those are the languages that have been reported (so far). Can you le me know if you have a localized environment and if yes, which language is deployed? You can see in the code before the error that the problem is something with localization, I just don't know which part. Also, which base language are you upgrading to?

 

The issue is supposed to be fixed since quite some time - the file knta_languages_800_3.sql was added to the upgrade-bits and that fixed the issue. Unless you have a VERY old upgrade-bundle, the issue should really not be occuring.

 

Please send the output of the following

 

select  * from knta_languages

 

Thanks and best regards,

Dirk

 


Bruno_Iemma
Frequent Contributor.

Re: Error when try upgrade PPM 7.5 to 8

yes its true, i have installed a spanish LP

i will download the new version of the upgrade and I will  try again.

 

I attached the file requested.

 

Regards,

Bruno.-

dirkf
Acclaimed Contributor.
Solution

Re: Error when try upgrade PPM 7.5 to 8

Hi Bruno,

 

just checked that file that you attached.

 

You have a strange issue on that table.

 

The spanish language is missing the column value ISO_COUNTRY_CODE for the row. Update the table to reflect the correct value (suppose it must be ES) and then try deploying the upgrade bundle again.

 

Best regards,

Dirk

Bruno_Iemma
Frequent Contributor.

Re: Error when try upgrade PPM 7.5 to 8

Hi Dirk
it works, thanks.
But now I found another error.
Aparently during postupgrade in RML_SETUP_IN_RML sqlscript

 

I attached the error file

 

Thanks in advance
Bruno.-

dirkf
Acclaimed Contributor.

Re: Error when try upgrade PPM 7.5 to 8

Hi Bruno,

 

that's good news.

Could you possibly evaluate 'solving' this thread and opening a new one for the new problem? That way, any future searches on the board topic threads are kept to what they are opened for. Doesn't take long and I'll look at the new issue later.

 

Best regards,

Dirk

 

- Kudos always welcome -

Bruno_Iemma
Frequent Contributor.

Re: Error when try upgrade PPM 7.5 to 8

OK Dirk

we are very grateful for your help.
we will open another post to resolve the issue.

 

Regards,

Bruno.-

Acamargo
Respected Contributor.

Re: Error when try upgrade PPM 7.5 to 8

Hi Bruno.

 

Not found for download on the HP website for the media upgrade from version 8. Just found the installation media. The media is in this upgrade?