Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
Expand all | Collapse all

Export ad-hoc report and import as new report (BMXAA4211E)

  • 1.  Export ad-hoc report and import as new report (BMXAA4211E)

    Posted Tue October 12, 2021 10:04 PM
    Edited by System Admin Wed March 22, 2023 11:48 AM

    MAM 7.6.1.2 (Oracle 19c):

    I have a simple ad-hoc report:


    As an experiment:
    I want to export the report, make a minor adjustment to the .rptdesign XML, and then import the report as a new report.

    Reason:
    It's easier to create reports via the ad-hoc report functionality than it is to create custom BIRT reports. I want to create an ad-hoc report, but make a minor adjustment to the SQL that isn't supported by the ad-hoc UI. And then import the report back into Maximo.
    It's ok if the imported report isn't treated as an ad-hoc report by Maximo going forward.



    Steps:
    1. Create the ad-hoc report.
    2. Report Administration --> Export Report.
    3. Extract the Zip file.
    4. Rename the .rptdesign file as WOTRACK_copy.rptdesign.
    5. Make minor adjustment to .rptdesign XML/SQL. I'm going to skip this step for now, just to simplify the test.
    6. Create a new report in Report Administration UI. (The new report isn't saved yet.)
    7. Import the report:

    8. OK
    9. The file appears to have imported successfully to the unsaved report:

    9. Save the new report. I get an error:
    BMXAA4211E - Database error number 1 has occurred when operating on REPORT : Application=WOTRACK TEST Report File Name=WOTRACK_copy.rptdesign. Report the error to the owner of the deployment.



    Question:
    Why am I getting that error? 


    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Export ad-hoc report and import as new report (BMXAA4211E)

    Posted Tue October 12, 2021 10:28 PM
    Edited by System Admin Wed March 22, 2023 11:51 AM

    It looks like Maximo automatically changed the Application field from "WOTRACK" to my description which was "WOTRACK TEST".
    I changed it back to WOTRACK and I was able to save successfully. So I think that fixed it.
    #Maximo
    #AssetandFacilitiesManagement