[
https://issues.apache.org/jira/browse/AMBARI-4391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nate Cole updated AMBARI-4391:
------------------------------
Summary: During Oracle db upgrade, syntax error in Oracle DML scripts
(was: During Oracle schema upgrade, syntax error in Oracle DML scripts)
> 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
>
>
> 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)
