• Replies 1 reply
  • Subscribers 337 subscribers
  • Views 56 views
  • Users 0 members are here
Related

Errors using SSRS version of ConstituentProfile

Nathan Wigham
$organization

Hello all.

I pointed the "Full Bio" (from Constituents -> Constituent Report) to the canned SSRS report ConstituentProfile, instead of the InfoMaker object d_biography_new.  And it was successful, thanks to some very helpful posts on the forums.  But in testing I get an error in a very specific case.

After I bring up the report, if the first thing I do is to hit Page Down, I get errors that cause Tessitura to close.  It goes like this:

"Application Error: Unfortunately, an irrecoverable application error has occurred.  The application will need to be closed or restarted."  Details: "wa_report_standard.dw_report.keyup.10: Null object reference at line 10 in keyup event of object dw_report of wa_report_standard. (2)"

Then, "DataWindowError: Database transaction information not available.  Call SetTrans or SetTransObject function."

Then, "Application Error: uo_browser.ole_browser.statusextchange.1: Null object reference at line 1 in statusextchange event of object ole_browser of uo_browser. (2)"

Finally, "PowerBuilder application execution error (R0002): Application terminated.  Error: Null object reference at line 10 in dberror event of object dw_const_header of uo_const_header."

And the application is closed.

Now, it only happens if the first thing I do is to hit Page Down.  If i scroll first, then hit Page Down (even from the very top of the page), it's fine.

I know, the simple answer is, "Dont do that."  But as we all know, if a user can do it, a user will do it.  So, how can I avoid this error?  Is there a setting I'm missing?

In case it's helpful, here's the string I used to update the record in T_CONSTITUENT_REPORT to point it to the SSRS object:

d_object =

'<<URL>>?/[path to the report]/ConstituentProfile&rs:Command=Render&rc:DocMap=false&customer_no=<<key>>&list_no:IsNull=True&section_str:IsNull=True&CutOffDate:IsNull=True&UserGroup=<<ug>>&UserId=<<user>>&CompanyName=<<companyname>>&RequestId=0'

and I set display_in_browser to Y.

Any feedback is greatly appreciated!

 

Nathan

  • $organization

    This problem does not appear to happen for me right now.  However, this one sounds familiar.  Like it may have been a hotfix or something. Have you put in a TASK ticket on this issue.

    --Tom

    …

    718.724.8135

    tbrown@BAM.org

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nathan Wigham
    Sent: Thursday, July 09, 2015 3:54 PM
    To: Thomas Brown
    Subject: [Tessitura Technical Forum] Errors using SSRS version of ConstituentProfile

     

    Hello all.

    I pointed the "Full Bio" (from Constituents -> Constituent Report) to the canned SSRS report ConstituentProfile, instead of the InfoMaker object d_biography_new.  And it was successful, thanks to some very helpful posts on the forums.  But in testing I get an error in a very specific case.

    After I bring up the report, if the first thing I do is to hit Page Down, I get errors that cause Tessitura to close.  It goes like this:

    "Application Error: Unfortunately, an irrecoverable application error has occurred.  The application will need to be closed or restarted."  Details: "wa_report_standard.dw_report.keyup.10: Null object reference at line 10 in keyup event of object dw_report of wa_report_standard. (2)"

    Then, "DataWindowError: Database transaction information not available.  Call SetTrans or SetTransObject function."

    Then, "Application Error: uo_browser.ole_browser.statusextchange.1: Null object reference at line 1 in statusextchange event of object ole_browser of uo_browser. (2)"

    Finally, "PowerBuilder application execution error (R0002): Application terminated.  Error: Null object reference at line 10 in dberror event of object dw_const_header of uo_const_header."

    And the application is closed.

    Now, it only happens if the first thing I do is to hit Page Down.  If i scroll first, then hit Page Down (even from the very top of the page), it's fine.

    I know, the simple answer is, "Dont do that."  But as we all know, if a user can do it, a user will do it.  So, how can I avoid this error?  Is there a setting I'm missing?

    In case it's helpful, here's the string I used to update the record in T_CONSTITUENT_REPORT to point it to the SSRS object:

    d_object =

    '<<URL>>?/[path to the report]/ConstituentProfile&rs:Command=Render&rc:DocMap=false&customer_no=<<key>>&list_no:IsNull=True&section_str:IsNull=True&CutOffDate:IsNull=True&UserGroup=<<ug>>&UserId=<<user>>&CompanyName=<<companyname>>&RequestId=0'

    and I set display_in_browser to Y.

    Any feedback is greatly appreciated!

     

    Nathan




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!