agl addin installation fails: ORA-01722

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When upgrading the agile addin to 16.2.0, the installation fails:

java.sql.BatchUpdateException: se ha producido un error durante el procesamiento por lotes: ORA-01722: número no válido

ORA-06512: en línea 2

        at oracle.jdbc.driver.OracleStatement.executeLargeBatch(OracleStatement.java:4659)

        at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:4527)

....

Process - other: POSTUPGRADE_AGL_TEAM_OPEN_TIME_ENTRY.xml

SQL Text:

BEGIN

  UPDATE odf_ca_integration

     SET agl_team_is_open = 1

   WHERE agl_team_is_open IS NULL

   AND (

       NOT EXISTS (SELECT INSTALL_TYPE FROM CMN_INSTALL_HISTORY WHERE INSTALL_ID = 'agl')

       OR ( ( SELECT MAX(TO_NUMBER(SUBSTR(BASE_RELEASE, 1, 4))) FROM CMN_INSTALL_HISTORY WHERE INSTALL_ID = 'agl') < 14.4 )

       );

END;

 

Environment

16.2.0

Cause

The server OS was set to Spanish

Resolution

Set the server language to English

sudo localetcl set-locale LANG=en_US.UTF-8