ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nate Cole (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (AMBARI-4391) During Oracle db upgrade, syntax error in Oracle DML scripts
Date Thu, 23 Jan 2014 12:05:37 GMT

     [ https://issues.apache.org/jira/browse/AMBARI-4391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Nate Cole updated AMBARI-4391:
------------------------------

    Attachment: AMBARI-4391.patch

> During Oracle db upgrade, syntax error in Oracle DML scripts
> ------------------------------------------------------------
>
>                 Key: AMBARI-4391
>                 URL: https://issues.apache.org/jira/browse/AMBARI-4391
>             Project: Ambari
>          Issue Type: Bug
>          Components: controller
>            Reporter: Nate Cole
>            Assignee: Nate Cole
>             Fix For: 1.4.4
>
>         Attachments: AMBARI-4391.patch
>
>
> When executing Ambari-DML-Oracle-FIX_LOCAL_REPO.sql, the following error occurs to every
single query with INSTR() function:
> {code}
> SQL> SQL>   2    3    WHERE INSTR('HDPLocal' in current_stack_version) > 0
>                          *
> ERROR at line 3:
> ORA-00907: missing right parenthesis
> {code}
> When executing Ambari-DML-Oracle-INSERT_METAINFO.sql
> * Need commit;
> * Need to single-quote string values
> * Need to double-quote metainfo column names, because the create script uses double-quoted
column names.



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

Mime
View raw message