Maximo User Group - UK & Ireland

Maximo-ICON.png

Maximo

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

Maximo-ICON.png

TRIRIGA

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

Maximo-ICON.png

Engineering

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
    Hi,
    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,
    Paul.