Maximo User Group - UK & Ireland



Learn how to increase the operational efficiency of the assets you manage, and improve overall equipment effectiveness by using IoT data and AI.



Reduce the operational costs of the facilities you manage, and create more engaging occupant experiences through the application of IoT data and AI.



Learn how IoT data and AI are being applied to transform the end-to-end engineering lifecycle.

Expand all | Collapse all

Help required for Maximo

  • 1.  Help required for Maximo

    Posted Thu January 10, 2019 09:07 AM
    I need help for Maximo 4.1.1.

    Problem Statement
    When user generates PMs (Preventive Maintenance) using Maximo he gets below error.

    "SQL error: 166 - Cannot create a front-end result set". On this Error screen, "OK" & "More" buttons are present.

    If I click on "More" button, I get SQL query & error message is 
    "SQL Error: 203 - Command has not been executed".

    After this application crashes & needs to restart.

    Every time, query on error screen is different.

    More Details
    I am facing this issue on multiple computers & has repeatedly occurred over the last 4-5 months.

    Request you kind help

    Thanks in advance

    Suhas Nangnurkar

  • 2.  RE: Help required for Maximo

    Posted Thu January 10, 2019 09:32 AM

    This is way too old.

    No plan to upgrade ?



  • 3.  RE: Help required for Maximo

    Posted Fri January 11, 2019 04:05 AM
    This sort of thing used to happen when triggers clashed with Maximo code. You may want to check out any customisations, including any in the C++ classes and see if any work at the same time as PM generation. Turn them off and see what happens.
    Best wishes,