ReportDesign (id=1): Unhandled exception when executing script

Hello,

I am a new user to BIRT - ECLIPSE and I am trying to preview a report. During Preview, I am getting the following error:

ReportDesign (id=1): Unhandled exception when executing script.

i run the debugger and get :
Compiled Source: UNNNAMED SCRIPT - params ["system_parentRecordID"].value

I have read a ton of documentation and I am not making heads or tails of it. I think I need to bind the parameters, but it's a little confusing. I am working with starter queery report from TRIRIGA.

Any help is very appreciated.

Comments

  • mwilliamsmwilliams BIRT Guru
    Could you attach the design?

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: [email protected]

  • Sorry, Unfortunately, due to privacy with this sector, I cannot attach the report.  It would be a breach of security :-(  Is there anything that I could possibly look for? 

     

    Thanks

    Tronda

  • mwilliamsmwilliams BIRT Guru
    Do you have a parameter named system_parentRecordID?

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: [email protected]

  • Yes I do have a parameter named system_parentRecordID.  To give you a little background, BIRT will let you start with starter reports from TRIRIGA.  I have started with the starter reports.  Under Report Parameters, there is a {}system_parentRecordId.  And In the output colums under the dataset where you can edit the query, there's a system_recordId, along with other output colums. 

  • mwilliamsmwilliams BIRT Guru
    Would it be against the security policy to email me the report, rather than posting it in a public forum?

    Or, if you set up a similar situation with a sample report that you could post, does the same issue happen?

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: [email protected]

  • The same thing happened with the sample data.  I am attaching the report:

     

    <?xml version="1.0" encoding="UTF-8"?>

    <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">

    <property name="createdBy">Eclipse BIRT Designer Version 2.6.2.r262_v20110209 Build &lt;2.6.2.v20110219-1842></property>

    <simple-property-list name="includeResource">

    <value>[v2QRY]Classification__triBuildingSystemDeficiencySeverity__triBuildingSystemDeficiencySeverity_-_Filter_-_triDeferredLineItem.tririgalabels</value>

    </simple-property-list>

    <parameters>

    <scalar-parameter name="Classification__triBuildingSystemDeficiencySeverity____triNameTX" id="5">

    <text-property name="promptText" key="[FIELD]Classification__triBuildingSystemDeficiencySeverity____triNameTX"></text-property>

    <property name="valueType">static</property>

    <property name="isRequired">false</property>

    <property name="dataType">string</property>

    <property name="distinct">true</property>

    <property name="paramType">simple</property>

    <property name="controlType">text-box</property>

    <structure name="format">

    <property name="category">Unformatted</property>

    </structure>

    </scalar-parameter>

    <scalar-parameter name="Classification__triBuildingSystemDeficiencySeverity____triIdTX" id="6">

    <text-property name="promptText" key="[FIELD]Classification__triBuildingSystemDeficiencySeverity____triIdTX"></text-property>

    <property name="valueType">static</property>

    <property name="isRequired">false</property>

    <property name="dataType">string</property>

    <property name="distinct">true</property>

    <property name="paramType">simple</property>

    <property name="controlType">text-box</property>

    <structure name="format">

    <property name="category">Unformatted</property>

    </structure>

    </scalar-parameter>

    <scalar-parameter name="system__parentRecordId" id="7">

    <property name="hidden">true</property>

    <text-property name="promptText" key="[FIELD]system__parentRecordId"></text-property>

    <property name="valueType">static</property>

    <property name="isRequired">false</property>

    <property name="dataType">decimal</property>

    <property name="distinct">true</property>

    <property name="paramType">simple</property>

    <property name="controlType">text-box</property>

    <structure name="format">

    <property name="category">Unformatted</property>

    </structure>

    </scalar-parameter>

    </parameters>

    <data-sources>

    <script-data-source name="TRIRIGA" id="4"/>

    </data-sources>

    <data-sets>

    <script-data-set name="[v2QRY]Classification__triBuildingSystemDeficiencySeverity__triBuildingSystemDeficiencySeverity_-_Filter_-_triDeferredLineItem" id="8">

    <property name="eventHandlerClass">com.tririga.platform.birt.dataset.TriDataSetEventHandler</property>

    <list-property name="resultSetHints">

    <structure>

    <property name="position">1</property>

    <property name="name">Classification__triBuildingSystemDeficiencySeverity____triIdTX</property>

    <property name="dataType">javaObject</property>

    </structure>

    <structure>

    <property name="position">2</property>

    <property name="name">Classification__triBuildingSystemDeficiencySeverity____triNameTX</property>

    <property name="dataType">javaObject</property>

    </structure>

    <structure>

    <property name="position">3</property>

    <property name="name">system__recordId</property>

    <property name="dataType">decimal</property>

    </structure>

    </list-property>

    <list-property name="columnHints">

    <structure>

    <property name="columnName">Classification__triBuildingSystemDeficiencySeverity____triIdTX</property>

    <text-property name="displayName" key="[FIELD]Classification__triBuildingSystemDeficiencySeverity____triIdTX"></text-property>

    </structure>

    <structure>

    <property name="columnName">Classification__triBuildingSystemDeficiencySeverity____triNameTX</property>

    <text-property name="displayName" key="[FIELD]Classification__triBuildingSystemDeficiencySeverity____triNameTX"></text-property>

    </structure>

    <structure>

    <property name="columnName">system__recordId</property>

    <text-property name="displayName">recordId</text-property>

    </structure>

    </list-property>

    <list-property name="parameters">

    <structure>

    <property name="name">Classification__triBuildingSystemDeficiencySeverity____triNameTX</property>

    <property name="dataType">string</property>

    <property name="position">1</property>

    <expression name="defaultValue" type="javascript">params["Classification__triBuildingSystemDeficiencySeverity____triNameTX"].value</expression>

    <property name="isInput">true</property>

    <property name="isOutput">false</property>

    </structure>

    <structure>

    <property name="name">Classification__triBuildingSystemDeficiencySeverity____triIdTX</property>

    <property name="dataType">string</property>

    <property name="position">2</property>

    <expression name="defaultValue" type="javascript">params["Classification__triBuildingSystemDeficiencySeverity____triIdTX"].value</expression>

    <property name="isInput">true</property>

    <property name="isOutput">false</property>

    </structure>

    <structure>

    <property name="name">system__parentRecordId</property>

    <property name="dataType">decimal</property>

    <property name="position">3</property>

    <expression name="defaultValue" type="javascript">params["system__parentRecordId"].value</expression>

    <property name="isInput">true</property>

    <property name="isOutput">false</property>

    </structure>

    </list-property>

    <structure name="cachedMetaData">

    <list-property name="resultSet">

    <structure>

    <property name="position">1</property>

    <property name="name">Classification__triBuildingSystemDeficiencySeverity____triIdTX</property>

    <property name="dataType">javaObject</property>

    </structure>

    <structure>

    <property name="position">2</property>

    <property name="name">Classification__triBuildingSystemDeficiencySeverity____triNameTX</property>

    <property name="dataType">javaObject</property>

    </structure>

    <structure>

    <property name="position">3</property>

    <property name="name">system__recordId</property>

    <property name="dataType">decimal</property>

    </structure>

    </list-property>

    </structure>

    <property name="dataSource">TRIRIGA</property>

    </script-data-set>

    </data-sets>

    <styles>

    <style name="crosstab-cell" id="2">

    <property name="borderBottomColor">#CCCCCC</property>

    <property name="borderBottomStyle">solid</property>

    <property name="borderBottomWidth">1pt</property>

    <property name="borderLeftColor">#CCCCCC</property>

    <property name="borderLeftStyle">solid</property>

    <property name="borderLeftWidth">1pt</property>

    <property name="borderRightColor">#CCCCCC</property>

    <property name="borderRightStyle">solid</property>

    <property name="borderRightWidth">1pt</property>

    <property name="borderTopColor">#CCCCCC</property>

    <property name="borderTopStyle">solid</property>

    <property name="borderTopWidth">1pt</property>

    </style>

    <style name="crosstab" id="3">

    <property name="borderBottomColor">#CCCCCC</property>

    <property name="borderBottomStyle">solid</property>

    <property name="borderBottomWidth">1pt</property>

    <property name="borderLeftColor">#CCCCCC</property>

    <property name="borderLeftStyle">solid</property>

    <property name="borderLeftWidth">1pt</property>

    <property name="borderRightColor">#CCCCCC</property>

    <property name="borderRightStyle">solid</property>

    <property name="borderRightWidth">1pt</property>

    <property name="borderTopColor">#CCCCCC</property>

    <property name="borderTopStyle">solid</property>

    <property name="borderTopWidth">1pt</property>

    </style>

    <style name="report" id="10">

    <property name="fontFamily">sans-serif</property>

    <property name="fontSize">10pt</property>

    </style>

    </styles>

    <page-setup>

    <simple-master-page name="Simple MasterPage" id="9"/>

    </page-setup>

    <body>

    <table id="11">

    <property name="dataSet">[v2QRY]Classification__triBuildingSystemDeficiencySeverity__triBuildingSystemDeficiencySeverity_-_Filter_-_triDeferredLineItem</property>

    <list-property name="boundDataColumns">

    <structure>

    <property name="name">Classification__triBuildingSystemDeficiencySeverity____triIdTX</property>

    <text-property name="displayName" key="[FIELD]Classification__triBuildingSystemDeficiencySeverity____triIdTX">ID</text-property>

    <expression name="expression" type="javascript">dataSetRow["Classification__triBuildingSystemDeficiencySeverity____triIdTX"]</expression>

    <property name="dataType">javaObject</property>

    </structure>

    <structure>

    <property name="name">Classification__triBuildingSystemDeficiencySeverity____triNameTX</property>

    <text-property name="displayName" key="[FIELD]Classification__triBuildingSystemDeficiencySeverity____triNameTX">Name</text-property>

    <expression name="expression" type="javascript">dataSetRow["Classification__triBuildingSystemDeficiencySeverity____triNameTX"]</expression>

    <property name="dataType">javaObject</property>

    </structure>

    </list-property>

    <column id="21"/>

    <column id="22"/>

    <header>

    <row id="12">

    <cell id="13">

    <label id="23">

    <text-property name="text" key="[FIELD]Classification__triBuildingSystemDeficiencySeverity____triIdTX">ID</text-property>

    </label>

    </cell>

    <cell id="14">

    <label id="25">

    <text-property name="text" key="[FIELD]Classification__triBuildingSystemDeficiencySeverity____triNameTX">Name</text-property>

    </label>

    </cell>

    </row>

    </header>

    <detail>

    <row id="15">

    <cell id="16">

    <data id="24">

    <property name="whiteSpace">nowrap</property>

    <property name="resultSetColumn">Classification__triBuildingSystemDeficiencySeverity____triIdTX</property>

    </data>

    </cell>

    <cell id="17">

    <data id="26">

    <property name="whiteSpace">nowrap</property>

    <property name="resultSetColumn">Classification__triBuildingSystemDeficiencySeverity____triNameTX</property>

    </data>

    </cell>

    </row>

    </detail>

    <footer>

    <row id="18">

    <cell id="19"/>

    <cell id="20"/>

    </row>

    </footer>

    </table>

    </body>

    </report>

  • mwilliamsmwilliams BIRT Guru

    It fails for me by not having the event handler class. Can you make a report that I can run break the same way, by chance?

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: [email protected]

  • I can try??  Plz Understand, that I am not intentionally trying to break my rpt, lol.  Are you going to send me the report? 

     

    I have another question as well.  I can create a report by not using the starter reports from TRIRIGA.  However, when I deploy the report back to TRIRIGA, I get the error:

     

    "Can not load the report query: 488. Errors occurred when generating the report document for the report element with ID 488"

     

    I don't get the message when I run them in ECLIPSE BIRT.  They run fine.  Can you help me with the error. 

     

    Idealy, I would love to create the reports with the Starter Reports from TRIRIGA, So, I still need help with the 1st question. 

     

    Thanks

     

    LT

  • Hi, How did you fix this issue? I am getting the same error with a report that uses multiple starter reports.

  • No one from the thread from five years ago has responded. It's not clear from this long thread what the issue is. Could you please provide details of the issue you are encountering?

    • All products/environments with version numbers
    • Error messages and description of undesirable behavior
    • Sample reports/code
    • Anything else that might be useful
    Jeff F.
    Customer Support Engineer I
    OpenText
Sign In or Register to comment.