Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

NQSModifyMetadata - how to call it

Received Response
1
Views
4
Comments
988468
988468 Rank 1 - Community Starter
in Oracle Business Intelligence Applications

Does someone know the exact syntax to be used to update some object in the Repository using the NQSModifyMetadata procedure ?

Answers

  • rmoff
    rmoff Rank 6 - Analytics Lead

    Did you check the docs, https://docs.oracle.com/middleware/1221/biee/BIEIT/bi_server_web_services.htm#BIEIT3253

    Maybe run NQSQueryMetadataObjects first and base your call to NQSModifyMetadata on the response from that?

    Share what you've tried so far, and we can help out

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    +1 to @rmoff - what's in the documentation is all there is. Everything else is you finding out things yourself by testing the calls and experimenting. It's not really a functionality which is supposed to be widely used by everybody for every case. Hence also Robin's interest and mine.

    Which makes me ask: What's your use case? Most people find this, get excited, fail and then give up ;-)

  • 988468
    988468 Rank 1 - Community Starter

    thnks folks -

    The need is to change the password of the connection pools - we have 13 of them every month w/o having to upload the RPD

    the command tried in administration -> Issue Direct SQL

    --==========Command tried

    call NQSModifyMetadata( '<?xml version="1.0" encoding="UTF-8" ?>

    <Repository  xmlns:xsi=''http://www.w3.org/2001/XMLSchema-instance''>

    <DECLARE><ConnectionPool name="Oracle Data Warehouse Connection Pool" password="ddummy"  isSiebelJDBSecured="false">  </ConnectionPool></DECLARE></Repository>')

    Error encountered

    ================================

    [nQSError: 28006] Near Line 1, <>: Not defined

    Also tried escaping chars for "<" and ">" tags - didn't work

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Instead of nourishing your second thread (please close that one by the way) - have you already looked at this?

    https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=58768885147732&id=1508896.1&_afrWindowMode=0&…

    Behind that JAR is nothing but a call of NQSModifyMetadata and this was written as a replacement for 10g's nqschangepassword.exe