[jira] [Commented] (AMBARI-4415) During Oracle schema upgrade ORA-06502: PL/SQL: numeric or value error: raw variable length too long

["Oleksandr Diachenko (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AMBARI-4415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13881099#comment-13881099 ] 

Oleksandr Diachenko commented on AMBARI-4415:
---------------------------------------------

Changes was made in script Ambari-DDL-Oracle-UPGRADE.sql:
- Update statement that fills table column "stage.cluster_host_info" was changed to deal with long commands.
- Analytical function "ROW_NUMBER" was added to handle duplicates.
- New function was added: "compress_cluster_host_info_pkg.substr_blob" - it is similar to "dbms_lob.substr", but has no limitation in a maximum buffer size of 2000 bytes.
- Fixed using of correct type nested_vachar2_tbl_type.

> During Oracle schema upgrade ORA-06502: PL/SQL: numeric or value error: raw variable length too long
> ----------------------------------------------------------------------------------------------------
>
>                 Key: AMBARI-4415
>                 URL: https://issues.apache.org/jira/browse/AMBARI-4415
>             Project: Ambari
>          Issue Type: Task
>          Components: controller
>    Affects Versions: 1.4.3
>            Reporter: Oleksandr Diachenko
>            Assignee: Oleksandr Diachenko
>             Fix For: 1.4.4
>
>




--
This message was sent by Atlassian JIRA
(v6.1.5#6160)