MxLoader

 View Only
Back to discussions
Expand all | Collapse all

Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

  • 1.  Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 04-14-2022 14:12
      |   view attached
    Hi,

    When I try running the Mx Loader 8.3.4, I get the run-time error '91'.

    Object variable or With block variable not set

    I am able to establish a successful connection. I get this error when I run my Mx sheets for any operation. Any suggestions on what is wrong here?

    Best Regards,
    Vikrant K.

    ------------------------------
    Vikrant Kushwaha
    Savvy Logic Tech Consultants Corp
    ------------------------------


  • 2.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 04-15-2022 08:52
    MXL_ASSET is not a delivered object structure. This does not look like the error if the object structure is not present, but it may be good to confirm it is setup up correctly for integration. Just a guess at this point, as I have not seen this error before.

    ------------------------------
    Christopher Winston
    Projetech Inc.
    ------------------------------

    Original Message


  • 3.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 04-18-2022 11:36

    Hi Christopher,

    MXL_ASSET is a custom object structure, but I encounter this error even with the out-of-box object structures. I have verified this object structure and it works fine with Mx Loader 6.2. I am only getting this error with Mx Loader 8.3.4. Do you suggest anything else I can verify with the configuration?

    Thank you for your assistance!



    ------------------------------
    Vikrant Kushwaha
    Savvy Logic Tech Consultants Corp
    ------------------------------

    Original Message


  • 4.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 04-20-2022 14:12
    @Vikrant Kushwaha I wish I knew more. Perhaps someone with the visual basic knowledge will understand the error and be able to interpret it. ​

    ------------------------------
    Christopher Winston
    Projetech Inc.
    ------------------------------

    Original Message


  • 5.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 05-04-2022 19:16
    Hi, There is any new about this? I wonder if you can share me older versions of Mxloader like 8.3 or 8.2

    best regards

    ------------------------------
    Ricardo Monsivais
    NA
    ------------------------------

    Original Message


  • 6.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 05-05-2022 09:59
      |   view attached
    Hi Ricardo,

    I dont have any news about the error but I am attaching the version you requested (8.2).

    Hope it helps.

    Regards

    ------------------------------
    André Cordeiro
    ------------------------------

    Attachment(s)

    xlsm
    MxLoader_82.xlsm   553 KB 1 version
    Original Message


  • 7.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 05-17-2022 04:39
    Hi Vikrant,

    I have a similar issue, did you already find a solution to the problem?
    ​
    Thanks

    Regards,

    Fred

    ------------------------------
    Fred Aklamanu
    IBM
    ------------------------------

    Original Message


  • 8.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 06-27-2022 12:21
    Hi,

    Has anyone found a resolution to this issue. I am encountering the same in MxLoader 8.3.5.

    Thanks

    Stevie

    ------------------------------
    Stevie Holloway
    U.S. Bureau of Reclamation
    ------------------------------

    Original Message


  • 9.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 07-05-2022 11:55
    All Concerned:

    I don't know if the resolution below will solve others encountering the same error message but it worked for my situation.

    1. Since my configuration is LDAP, I ensured System Properties > Global Property mxe.useAppServerSecurity = 1


    2. In MxLoader, I set the Authentication to LDAP and entered my User and Password info. Next, I tested the connection which returned successful. I then executed a query and results returned without error.


    I hope this information helps others.

    Stevie



    ------------------------------
    Stevie Holloway
    U.S. Bureau of Reclamation
    ------------------------------

    Original Message


  • 10.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 12 days ago

    Has anyone found a solution to this yet?

    I've found when I do something simple like click on MxSheet wizard, I get this error.  I don't think the error has anything to do with Maximo.

    I get the issue in MxLoader 8.4.2 and in 8.2.

    Thanks,

    Aaron



    ------------------------------
    Aaron Sandler
    Correctional Servicers Canada
    ------------------------------

    Original Message


  • 11.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 12 days ago

    No, this doesn't help.  We are using Native Maximo login.  My userid and password are already entered.

    As I said, the error can occur when I try to open the MxLoader wizard.

    I did try to run a query, and got the same "91" error.



    ------------------------------
    Aaron Sandler
    Correctional Servicers Canada
    ------------------------------

    Original Message


  • 12.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 08-09-2022 12:47

    All,

    This may or may not apply to your particular situation. I also encountered this error and was able to work through it by referencing the article below: 

    https://www.ibm.com/support/pages/mif-object-structure-authorization

    The above is for Maximo versions 7.6.0.5 +

    I had to set the system property: mxe.int.enableosauth to a value of 0 meaning that object structure authorization is not required



    ------------------------------
    Jess Schmitz
    Projetech Inc.
    ------------------------------

    Original Message


  • 13.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 04-10-2023 13:29

    Hi Vikrant,
    Did you get this solution of this problem?
    I am getting same error.



    ------------------------------
    Kumari Annoo
    MCt India infotech
    ------------------------------

    Original Message


  • 14.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 6 days ago

    I created my new Windows profile and it was able to solve the issue.



    ------------------------------
    Paweena Wong
    Tripledot Consulting
    ------------------------------

    Original Message


  • 15.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 6 days ago

    Thanks.  Now, how do I create a new Windows profile?

     

    Aaron

     




    Original Message


  • 16.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 5 days ago

    Paweena, I would be interested to know what you mean by 'windows profile'  the issue I am finding is that mxloader is working fine for one maximo but for a newer instance of maximo it is throwing the error mentioned above... so not sure how a windows profile would solve what appears to be an integration object or maximo configuration issue.  If you can shed light on this it would be very helpful.



    ------------------------------
    Stephen Hume
    Sheffield Scientific LLC
    ------------------------------

    Original Message


  • 17.  RE: Microsoft Visual Basic - Run-time error '91' in Mx Loader 8.3.4

    Posted 5 hours ago

    Here are the details of what is happening.

    I can run queries and updates from MXLoader to one instance of Maximo, which uses native security and Maximo is version 7.6.1.3.

    When I try to use the exact same MXLoader workbook on another Maximo environment which is also version 7.6.1.3 I can connect to the server OK (on the configuration sheet), yet when I try to do anything to any of the objects (query for example) I am getting the runtime error 91.  I am trying to figure out what is missing in the new maximo servers that would cause this error to happen.  Is it security? Integration Objects?  Something in websphere configuration?  Fairly perplexed by this issue, and so far nobody has suggested a solution.



    ------------------------------
    Stephen Hume
    Sheffield Scientific LLC
    ------------------------------

    Original Message


Related Content