Sage 100

 View Only
Expand all | Collapse all

Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

  • 1.  Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 04-06-2020 09:57
    I have an end-user where they receive "Login failed for user 'MAS_Reports' when trying to run BI Explorer when the user is in CLASSIC desktop ( Standard Desktop not working at all ).

    Everything else in Sage is working fine - can run reports, etc.



    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------


  • 2.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 04-06-2020 10:15
    Edited by Wayne Schulz 04-06-2020 11:28
    I think this is related to the MAS_Reports account either expiring or prompting for a password change. I'm not able to print any reports which makes me think there is some expiration happening

    Update: I'm able to print Sage reports ok so am not certain it would be a problem with MAS_Reports account

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 3.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 04-06-2020 10:22
    Easy enough to test.  Use the Sage utility to change the MAS_Reports password (which can be done anytime... no need to kick users out).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 04-06-2020 10:29
    That's what I'm going to try. Unfortunately for this customer, I don't have access to their server or credentials so everything takes 10x longer than it otherwise would.  Now I'm able to get reports to run but I'm still hitting a roadblock with just Business Insights Explorer.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 5.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 04-08-2020 10:57
    Does anyone have a 2019.3 Premium that they could check to ensure this isn't a defect in just this version? I'm still working on resetting the MAS_Reports password. Every other report within Sage prints fine - it's just when I got to BIE that I get this message.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 6.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 04-08-2020 17:37
    Finally dug up my laptop with 2019 premium on it, installed update 3, and I don't get an error launching BIE from the classic desktop.

    ------------------------------
    ==================
    Rhonda McNamara
    Customer Success Manager
    Stewart Technologies, Inc.
    rsm@stewarttechnologies.com
    ------------------------------



  • 7.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 04-08-2020 18:41
    Thanks. 
    Right now it looks like this is something related to their remote VDI desktop configuration. When we use a regular VM and load workstation setup everything works fine. Now to find what is throwing Sage off track and causing this problem.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 8.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 04-09-2020 02:04
    In my experience bizarre Sage errors with Citrix VDI type of VM configurations are because of lack of permissions the Windows user has to local files, folders, and registry.

    To that end, I think IT can start a Process Monitor trace (Procmon) just prior to running a BI Explorer view then once error occurs, stop it. To limit the scope of trace, they can set the filter for Process Name = exApp.exe and pvxwin32.exe. Then export the trace to tab limited file then open that in Excel. Sort the RESULT column so ACCESS DENIED errors float to the top. Hope that helps.

    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------



  • 9.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 04-09-2020 08:21
    Update to this ongoing issue:

    First, this is in VDI which is a virtual desktop environment the company uses to manage its remote users. They have tight security in place so user rights are always a concern in debugging.


    Sage had me look at these registry keys




    They advised making the HKEY_LOCAL_MACHING the same as what was in HKEY_CURRENT_USER. Did this and it didn't appear to make a difference.

    Next, we created a virtual - non-VDI - desktop and ran workstation setup. This allowed us to run BIE without receiving the "Login failed for user 'MAS_Reports'.

    Then the IT person brought back my VDI desktop without any customization ( personalization?) - BIE worked in this environment.

    So there is something that is conflicting - possibly in a different registry key or ini file or possibly an ODBC that's coming back when they restore some of my VDI personalization (I'm sure there's a more technical word for this ). We are continuing to grind away at this and through the process of elimination, I think we'll be able to find out what's going on.

    So far I think I've eliminated: 
    - Sage program issue ( because BIE does eventually work )
    - MAS_Reports problem ( I think ) because we don't get the error 100% ( we are still considering resetting MAS_Reports and then trying to manually connect to Sage via SQL ODBC just to check/verify)


    The most likely culprit is something that VDI is bringing back and overwriting during it's "personalization" stage of bringing up my desktop.


    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 10.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 05-07-2020 13:56
    What eventually seemed to work: 

    The icon that we were starting Sage 100 Premium had checked off "run in Windows XP SP3" compatibility mode. Once we removed that checkmark everything worked just fine.

    I cannot say for 100% if this was the root cause but it was the only solution that we could reproduce the issue and fix it at will by changing.

    Toying with the registry did not seem to have an impact

    This was in a VDI environment where all of the c:\ and registry comes back with each reboot no matter what the user does to change it. The only ability to save changed items was to the desktop which is why it sort of makes sense that the desktop shortcut could have been at issue and why one user may have experienced the issue and another didn't.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 11.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 05-07-2020 16:41
    I would not have guessed that! It makes a lot of sense, actually. I'm sure BI Explorer is using a .NET method for login with Mas_Reports that is not compatible with Windows XP SP3 mode and so you get the error. For that matter, now that you fixed it, the Standard Desktop will probably work as well (you mentioned earlier only Classic was working).

    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------



  • 12.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 05-08-2020 09:32
    I tell people that can't run BI Explorer in Standard mode to switch to classic run explorer, and then switch back.  Probably what you are doing.  I've always though it was installing a DLL file into the user profile, or the common folders; that is not properly allowing via Standard.  Wonder how this is going to work when Classic is no longer an option?  I'll keep not of the "windows XP Mode" setting to see if I come across it myself.  Thanks @Wayne Schulz​​

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------



  • 13.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 05-08-2020 09:48
    RE: BI issue swapping to Classic, opening, then switching back to Standard... the dev team mentioned at MOTM that they fixed that issue in v2020.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 14.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 05-08-2020 10:06
    Edited by Wayne Schulz 05-08-2020 10:06
    I don't think this particular error was related the prior requirement to open it first in Classic for it to appear in Standard. I think Sage has fixed that in a prior PU.

    I do notice that when I am in Standard that the MAS_Reports error doesn't appear. NO data shows either --- meaning was still not working and also not providing me with an error message when viewed in Standard.

    Ultimately this particular error seemed to arise from running Sage 100 in compatibility mode ( specifically XP SP3).

    If you are ever in a situation where IT forces you to use VDI ( which means they tightly control all the desktops ) you should insist as part of the setup that they provide one VM that connects to the server but does not use VDI. 

    Having a non-VDI desktop is helpful for debugging whether the problem is somewhere in their VDI configurations. The main issue with VDI is you're probably not going to have access to the configuration so you have to rely on IT to make the changes you suggest. They are often reluctant so having a separate VM that runs without issue is VERY helpful at convincing the IT department ( or CTO ) that the issue likely is within VDI. 




    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 15.  RE: Login failed for user 'MAS_Reports' with BI Explorer on v2019 Premium

    Posted 05-08-2020 10:20
    I agree with @Wayne Schulz completely about having a standard connection to test with.  We had a customer situation where their I.T. used an unsupported 3rd party remote app software (2x) and when the customer had problems we could not reproduce in a regular remote session the issue was clearly narrowed down to the unsupported connection method.  With every odd issue we asked if they could reproduce it in a regular remote desktop... eventually the customer I.T. team became so frustrated at wasting time troubleshooting their 3rd party software that they abandoned it for a supported connection method... (with the odd recurring issues miraculously disappearing when they did).
    Trying to troubleshoot issues in non-standard I.T. environments is a big time sink / money pit.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------