You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Tom Beerbower (JIRA)" <ji...@apache.org> on 2014/01/23 16:13:38 UTC
[jira] [Commented] (AMBARI-4391) During Oracle db upgrade, syntax
error in Oracle DML scripts
[ https://issues.apache.org/jira/browse/AMBARI-4391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13879978#comment-13879978 ]
Tom Beerbower commented on AMBARI-4391:
---------------------------------------
+1 on the 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)