• Replies 4 replies
  • Subscribers 245 subscribers
  • Views 7 views
  • Users 0 members are here
Related

GetPerformanceAvailability and GetPerformances problems in v9.0.0.1

Darrin Katz
$organization

Since upgrading to v9.0.0.1, we are experiencing problems with GetPerformanceAvailability and GetPerformances.

Neither of these API calls returning any results for one of our production seasons using the same parameters as we do for v8.0 and with a fresh live2test copy.

Why would one of the seasons suddenly not be included in the resultset?

Thanks in advance for any assistance you can offer.

  • $organization

    Hi Darrin,

    Good day.

    You need to use SQL profiler to trace the actual sql statement, then you can compare v8.0 with v9.0.0.1.

    then you can figure out what is wrong.

    have fun.

    Ben

  • $organization in reply to Ben Gu

    API_Documentation.pdf

    Page 43-44,

    GetPerformanceAvailability returns data on Productions that match the specified search criteria.

    Database Objects

     

     

     

    WP_PROD_SEARCH

    WP_GET_PROD_INFO

     

     

    Page 29

    GetPerformances returns a result set of performances matching the specified search criteria. Except for mode of

    sale, all search criteria are optional. GetPerformances may also return web content information for the returned

    performances.

    Database Objects

    WP_PROD_SEARCH

  • $organization in reply to Ben Gu

    Good Day Ben,

    Thanks for your reply!

    The issue ended up being caused by a Control Group not being assigned to the security group our Web user is in.  It seems that v9 is less forgiving than v8 in that respect.

    John

     

  • $organization in reply to Ben Gu
    Hi Ben,
     
    Thanks for your reply. In taking a look at WP_PROD_SEARCH this seems to have been where the problem was:
     

    Modified CWR 3/30/2009 FP1066. Now setting web context so that the call to tp_prod_search will use control group settings

     

    Now that we've modified the control group of our web user the performances are showing up properly.

    Thanks for your help.

    Regards,

    Darrin


    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Ben Gu
    Sent: Wednesday, September 16, 2009 8:42 PM
    To: darrin@soulpepper.ca
    Subject: Re: [Tessitura Web Forum] GetPerformanceAvailability and GetPerformances problems in v9.0.0.1

    API_Documentation.pdf

    Page 43-44,

    GetPerformanceAvailability returns data on Productions that match the specified search criteria.

    Database Objects

     

     

     

    WP_PROD_SEARCH

    WP_GET_PROD_INFO

     

     

    Page 29

    GetPerformances returns a result set of performances matching the specified search criteria. Except for mode of

    sale, all search criteria are optional. GetPerformances may also return web content information for the returned

    performances.

    Database Objects

    WP_PROD_SEARCH

    From: Ben Gu <bounce-bengu4278@tessituranetwork.com>
    Sent: 9/16/2009 7:31:50 PM

    Hi Darrin,

    Good day.

    You need to use SQL profiler to trace the actual sql statement, then you can compare v8.0 with v9.0.0.1.

    then you can figure out what is wrong.

    have fun.

    Ben




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!