0 Replies Latest reply on Mar 13, 2016 12:42 PM by Sohil Bhavsar

    Error occurred while installing ords.3.0.4.60.12.48 with APEX 4.2.2

    Sohil Bhavsar

      Hello,

       

      I am upgrading APEX Listener and getting below error while installation with ords.3.0.4.60.12.48 with APEX 4.2.2:

       

      Error executing script: ords_schema_mapping.sql Error: ORA-00904: "A"."TENANT_ID": invalid identifier ORA-06512: at line 9

       

      -- Create a view that joins APEX_POOL_CONFIG and POOL_CONFIG, indicating the type of mapping
      declare
         l_hint_11g varchar2(100) := ' ';
      begin
        if sys.dbms_db_version.VERSION = 11 then
           l_hint_11g := '/*+NO_NATIVE_FULL_OUTER_JOIN*/';
        end if;
         
      -- Create a view that joins APEX_POOL_CONFIG and POOL_CONFIG, indicating the type of mapping
      execute immediate
       ' create or replace view ORDS_METADATA.unified_pool_config as
         SELECT ' || l_hint_11g ||
        ' CASE
           WHEN o.workspace_identifier is not null and a.workspace_identifier is not null THEN ''BOTH''
           WHEN o.workspace_identifier is null and a.workspace_identifier is not null THEN ''APEX''
           WHEN a.workspace_identifier is null and o.workspace_identifier is not null THEN ''ORDS''
          END schema_type,
          NULL pool_name,
          NVL(o.workspace_identifier,a.workspace_identifier) workspace_identifier,
          NVL(o.type,a.type) type,
          NVL(o.uri,a.uri) uri,
          NVL(o.updated,a.updated) updated,
          a.tenant_id,
          o.enc_key,
          o.mac_key
         FROM ORDS_METADATA.pool_config o
          FULL JOIN ORDS_METADATA.apex_pool_config a
          ON o.workspace_identifier = a.workspace_identifier';
      end;
      /
      

       

      Any thoughts?

       

      Can you please suggest is it a bug?

       

      I have extracted ords.war and found that there is no tenant_id column.

       

      As per few above lines can I change "a.tenant_id" to "1 tenant_id" ?

       

      Also I tried below manual installation command after changing but it is not working:

       

      java -jar ords.war install advanced ords-scripts --scriptdir ./ords/scripts/
      

       

      and I am getting below error:

       

      --scriptdir is not a valid option
      

       

      I can recreate .WAR file but wanted to know if this workaround will not cause any issues on Production.

       

      Kind Regards,

       

      Sohil Bhavsar.