SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 4 of 4
  1. #1
    Apprentice
    Join Date
    Sep 2009
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Updating AUDIT_PROPERTIES with Command Object

    I need to update AUDIT_PROPERTIES (won't go into why, but a real, legitimate need).

    I can update AUDIT_PROPERTIES in Site Admin with SQL with no problem (highly undesirable because it's manual)

    I *cannot* UPDATE AUDIT_PROPERTIES using the OTA's Command Object - I get an error that I do not have permissions. (what I really need to be able to do)

    *** This is *not* due to the Command processing being disabled through Site Configuration. I can update other tables via the Command object.

    Using a direct DB connection through ODBC or other means is *not* an option. I really need to do it through the Command.

    Anyone have a solution?

  2. #2
    Advanced Member
    Join Date
    Nov 2006
    Posts
    821
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    2 Thread(s)
    Total Downloaded
    0
    What is the version and patch level of the ALM/QC product you are using? Have you contacted HP Support? If you are blocked from updating only the one table this could be either a defect or intentional functionality.
    Trudy C
    (Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)

  3. #3
    Apprentice
    Join Date
    Sep 2009
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    ALM 11 Patch 17 ... no, we have no HP support and yes, I don't like it but I'm just a contractor so there's nothing I can do. Was just looking for ideas. Thanks.

  4. #4
    Apprentice
    Join Date
    Sep 2009
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    This turned out to be a restriction imposed on the Command object (updating the audit tables). Just as it can be done directly in Site Admin, the Site Admin API (SAClient) has a method RunQuery that is not subject to that restriction. Problem solved.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 02:17 AM.

Copyright BetaSoft Inc.