Topic
  • 1 reply
  • Latest Post - ‏2013-05-14T13:32:02Z by Aravinth_KM
Chris_in_NY
Chris_in_NY
58 Posts

Pinned topic Help Debugging errors

‏2013-05-10T16:50:10Z |

 

I am getting some errors out of the maximo application, and they 
pretty much just say there are system errors check the logs.
 
Nothing  is in the logs other than an error occurred.
 
I am trying to create a local object.
I bring in mxinvbal and try to duplicate it as bu_mxinvbal.
I  try to save it and I get an error BMXAA4160e - A major exception has occurred.
If I back out and list bu objects, bu_mxinvbal exists.
If I try to delete bu_mxinvbal I get a system error. 
 
Any assistance on this error, or more importantly how to find out what is causing these types of errors. Are there other files/tables

to look at that have more descriptive error messages that might point me in the right direction?

 

Thanks.

  • Aravinth_KM
    Aravinth_KM
    4 Posts

    Re: Help Debugging errors

    ‏2013-05-14T13:32:02Z  

    Examine if there are any dangling references using the following query and delete if any.


    select * from maximo.MAXINTOBJALIAS WHERE INTOBJECTNAME not in (select intobjectname from maximo.maxintobject);
    select *from maximo.MAXINTOBJCOLS WHERE INTOBJECTNAME not in (select intobjectname from maximo.maxintobject);
    select *from maximo.MAXINTOBJDETAIL WHERE INTOBJECTNAME not in (select intobjectname from maximo.maxintobject);
    select *from maximo.MAXINTOBJECT WHERE INTOBJECTNAME not in (select intobjectname from maximo.maxintobject);

    select *from maximo.MAXEXTIFACEIN WHERE IFACENAME not in (select ifacename from MAXIFACEIN) and ifacename not in(select ifacename from MAXIFACEOUT);
    select *from maximo.MAXEXTIFACEOUT WHERE IFACENAME not in (select ifacename from MAXIFACEIN) and ifacename not in(select ifacename from MAXIFACEOUT);
    select *from maximo.MAXIFACECOND WHERE IFACENAME not in (select ifacename from MAXIFACEIN) and ifacename not in(select ifacename from MAXIFACEOUT);
    select *from maximo.MAXIFACEIN WHERE INTOBJECTNAME not in (select intobjectname from maximo.maxintobject);
    select *from maximo.MAXIFACEOUT WHERE INTOBJECTNAME not in (select intobjectname from maximo.maxintobject);
    select *from maximo.MAXIFACEPROC WHERE IFACENAME not in (select ifacename from MAXIFACEIN) and ifacename not in(select ifacename from MAXIFACEOUT);