Cognos Analytics

 View Only
Expand all | Collapse all

Unable to Load Metadata for Oracle Synonyms

  • 1.  Unable to Load Metadata for Oracle Synonyms

    Posted Fri April 24, 2020 05:38 PM
    Hello,

    Has anyone run into issues with trying to load metadata for Oracle synonyms?  I receive some error messages in the logs:
    • The metadata provider returned an empty model for schema
    • MSR-GEN-0026 The schema "Schema Name" is either empty, or not accessible using the current signon.
    I enabled the MOSER diagnostic logging but did not find other specific errors.

    At the advice of support, I also added a connection property ibmcognos.qualifier_list and provided the list of source schemas.

    I know it's not the same process, but want to note this isn't a problem when using Framework Manager.  I am able to run the metadata wizard and import the synonym objects.

    Thanks for any info.

    ------------------------------
    Jeremy Aude
    Channell Commercial Corporation
    Rockwall TX
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Unable to Load Metadata for Oracle Synonyms

    Posted Fri April 24, 2020 06:32 PM

    When metadata is requested via JDBC driver, it (the driver) will return tables (DatabaseMetadata.getTables) or columns (DatabaseMetadata.getColumns) where ibmcognos.qualifier_list  plays no role.

    ibmcognos.qualifier_list is only used as described here https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_connection_properties.html

    Please continue to work with the support analyst who has you ticket.



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------

    Original Message


  • 3.  RE: Unable to Load Metadata for Oracle Synonyms

    Posted Fri April 24, 2020 09:21 PM

    Hi Nigel,

     

    Thanks for that info.  I will pass that on to the support analyst who asked me to perform those steps.




    Original Message


  • 4.  RE: Unable to Load Metadata for Oracle Synonyms

    Posted Tue April 28, 2020 03:43 AM

    We have the same issues with synonyms on Oracle.

    Version 11.1.4. 

    -------------------------------
    Ber Hommelberg

    a.s.r.

    Netherlands

    ------------------------------



    ------------------------------
    Ber Hommelberg
    ------------------------------

    Original Message


  • 5.  RE: Unable to Load Metadata for Oracle Synonyms

    Posted Tue April 28, 2020 10:07 AM
    Hi Ber,

    Thanks for sharing.  FYI we are using 11.1.5 so the issue is still present.  I will post the findings from the IBM case if we have a resolution.

    ------------------------------
    Jeremy Aude
    Channell Commercial Corporation
    Rockwall TX
    ------------------------------

    Original Message


  • 6.  RE: Unable to Load Metadata for Oracle Synonyms

    Posted Tue May 26, 2020 05:09 PM
    Just a quick update.  Support was not helpful. I received a message about 20 days ago saying there was an internal defect identified but no other information.

    Very frustrated with the quality of support lately.

    ------------------------------
    Jeremy Aude
    Channell Commercial Corporation
    Rockwall TX
    ------------------------------

    Original Message


  • 7.  RE: Unable to Load Metadata for Oracle Synonyms

    Posted Wed July 01, 2020 10:53 AM

    Still no news on the ability to use synonyms in datamodules?

    We really need this. 

    Ber Hommelberg
    ASR Nederland



    ------------------------------
    Ber Hommelberg
    a.s.r.
    Netherlands
    ------------------------------

    Original Message


  • 8.  RE: Unable to Load Metadata for Oracle Synonyms

    Posted Wed July 01, 2020 01:28 PM
    No update on this end and also a big bottleneck for us.  It's been a very disappointing support experience.



    Original Message


  • 9.  RE: Unable to Load Metadata for Oracle Synonyms

    Posted Wed August 19, 2020 04:58 AM

    Good news  @Jeremy Aude 

    I got notified that the problem with synonyms is found and solved.

    They will try to fix it in 11.1.7 FP1 ​​

    Otherwise it will be in 11.2.0 



    ------------------------------
    Ber Hommelberg
    a.s.r.
    Netherlands
    ------------------------------

    Original Message


  • 10.  RE: Unable to Load Metadata for Oracle Synonyms

    Posted Mon August 31, 2020 10:38 AM

    ORACLE's JDBC driver, by design will not unwind arbitrary sequences of synonyms.

    Should a program call the ORACLE JDBC driver to obtain column metadata, potentially nothing will be returned.

    https://support.oracle.com/knowledge/Middleware/2690139_1.html



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------

    Original Message