Unable to import BIRT report into maximo

BIRTing
BIRTing Member
edited February 11, 2022 in Analytics #1
Hi All,<br />
<br />
I'm using maximo 7.1.1.0 and I'm trying to import a BIRT report into maximo. I provided the correct path of the '.rptdesign' file, but it's throwing the below error.<br />
<br />
<strong class='bbc'>BMXAA5457E - The report import process failed. Verify the specified information is correct before proceeding again</strong><br />
<br />
Please provide your inputs.<br />
Thanks!<br />
<br />
Regards,<br />
Sankar

Comments

  • jverly01
    jverly01 Member
    edited December 31, 1969 #3
    Double check that you are selecting the .rptdesign vs the .rptconfig file. I still occassionaly grab the wrong file and get this error.
  • leeysh
    leeysh Member
    edited December 31, 1969 #4
    Hi,
    I'm using Birt 2.3.2, Maximo 7.1.1.5.

    I'm also facing the same issue when I try to import a report. I am sure that I have selected the correct file .rptdesign and the spelling in Report File Name is correct in MAXIMO Report Administration.

    Something I noticed is that I have a parameter group which is defined in the report. When I remove the Parameter Group, I'm able to upload the report without any error prompted. May I know is this a bug? Or I've missed out configuring something in the .rptdesign?

    Appreciate any advice! Thank you!

    Cheers,
    Gen
  • micajblock
    micajblock E Member
    edited December 31, 1969 #5
    <blockquote class='ipsBlockquote' data-author="'leeysh'" data-cid="112360" data-time="1355302551" data-date="12 December 2012 - 01:55 AM"><p>
    Something I noticed is that I have a parameter group which is defined in the report. When I remove the Parameter Group, I'm able to upload the report without any error prompted. May I know is this a bug? Or I've missed out configuring something in the .rptdesign?<br /></p></blockquote>
    <br />
    Why are you using a parameter group? To my knowledge this will have no affect within Maximo.
  • leeysh
    leeysh Member
    edited December 31, 1969 #6
    Hi,
    I just used it to consolidate the parameters that are optional. Hmm... okie.. Probably I'll try it out again with another report and see how it goes.
  • ebennett
    ebennett Member
    edited December 31, 1969 #7
    Is there a fix for this? I'm getting the same error, but only when using cascading parameters.<br />
    <br />
    I have a custom BIRT(3.7.1) report, that I am trying to deploy to Maximo<br />
    7.5.0.3, and getting this error when importing the design file.<br />
    <br />
    BMXAA5457E - The report import process failed. Verify the specified information.<br />
    <br />
    This started occurring after I added cascading parameters to the report. I can<br />
    import the previous version of the report just fine, but the version with the<br />
    cascading parameter fails.<br />
    <br />
    No errors in eclipse preview, and the validation passes successfully.<br />
    <br />
    <br />
    Any ideas?<br />
    <br />
    <br />
    <br />
    <br />
    <blockquote class='ipsBlockquote' data-author="'leeysh'" data-cid="112360" data-time="1355302551" data-date="12 December 2012 - 01:55 AM"><p>
    Hi,<br />
    I'm using Birt 2.3.2, Maximo 7.1.1.5. <br />
    <br />
    I'm also facing the same issue when I try to import a report. I am sure that I have selected the correct file .rptdesign and the spelling in Report File Name is correct in MAXIMO Report Administration.<br />
    <br />
    Something I noticed is that I have a parameter group which is defined in the report. When I remove the Parameter Group, I'm able to upload the report without any error prompted. May I know is this a bug? Or I've missed out configuring something in the .rptdesign?<br />
    <br />
    Appreciate any advice! Thank you!<br />
    <br />
    Cheers,<br />
    Gen<br /></p></blockquote>
  • micajblock
    micajblock E Member
    edited December 31, 1969 #8
    <blockquote class='ipsBlockquote' data-author="'ebennett'" data-cid="112805" data-time="1356640344" data-date="27 December 2012 - 01:32 PM"><p>
    Is there a fix for this? I'm getting the same error, but only when using cascading parameters.<br />
    <br />
    Any ideas?<br /></p></blockquote>
    <br />
    Yes, don't use cascading parameters. There is no reason I know for it in Maximo. IMHO this is a Maximo bug. Complain to IBM.
  • ebennett
    ebennett Member
    edited December 31, 1969 #9
    Do you know if there is an alternative way to do the same thing?<br />
    <br />
    What I am trying to do is have one combo box populated with locations, the second combo box is then populated with the store rooms for the selected location.<br />
    <br />
    <br />
    <br />
    <br />
    <blockquote class='ipsBlockquote' data-author="'mblock'" data-cid="112844" data-time="1356829382" data-date="29 December 2012 - 06:03 PM"><p>
    Yes, don't use cascading parameters. There is no reason I know for it in Maximo. IMHO this is a Maximo bug. Complain to IBM.<br /></p></blockquote>
  • micajblock
    micajblock E Member
    edited December 31, 1969 #10
    <blockquote class='ipsBlockquote' data-author="'ebennett'" data-cid="112859" data-time="1356971754" data-date="31 December 2012 - 09:35 AM"><p>
    Do you know if there is an alternative way to do the same thing?<br />
    <br />
    What I am trying to do is have one combo box populated with locations, the second combo box is then populated with the store rooms for the selected location.<br /></p></blockquote>
    <br />
    Sorry, I am a BIRT expert that knows some Maximo. I do not know how to create cascading parameters in Maximo.
  • Runold
    Runold Member
    edited January 29, 2013 #11
    If you look in the database with an SQL tool, you may notice that sometimes a report row is added to the SCHEMA.REPORTS table despite the BMX.. error

    ...bmxaa4211e database error number 803 has occurred when operating on report sqlstate=23505...

    The row is added as you import the rptdesign file in the popup. After you cloase the popup and try to save you get this error.

    If you now delete the row in the REPORTS table for your specific report, and commit the delete tranasction, you can now save the report and continue to test it.
  • Maximo123
    Maximo123 Member
    edited December 31, 1969 #12
    I'm also facing the same issue when I'm trying to import the design file with the cascading parameter. Is there any solution to it?

    Please suggest me some other alternative solution to have cascading parameter in maximo.
  • jverly01
    jverly01 Member
    edited December 31, 1969 #13
    Any chance you can post the rptdesign file with the cascade parameters to help with review/testing?
  • jverly01
    jverly01 Member
    edited December 31, 1969 #14
    I confirmed over the weekend from IBM that BIRT reports with cascade parameters will fail to import into Maximo. There is supposed to be an open Request for Enhancement (RFE) to update Maximo to allow cascade parameters.

    I will post the link to the RFE once the Developer Works site is back up.
  • <p>Is there any updates on this topic?</p>