Sage 100

 View Only

  • 1.  Excel Query

    Posted 08-14-2020 10:49
    HI All,   I have a perplexing issue with an Excel Query.   I originally built the spreadsheet in Excel 2016 32bit.  It queries WO1 and WO2 brining it the required component Quantities.  Works perfectly in this setup.    However the user than needs to run it is on an RDP server (server 2012 R2) with Office 365 64 bit.  I updated it to use a 64bit version of the ODBC driver.  Sometimes it will work the first time I run it but then I start getting "internal error" messages.  I made sure the RDP server had all updates (thinking it may be a .Net issue).   I am stumped.   Any thoughts or suggestions?

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------


  • 2.  RE: Excel Query

    Posted 08-14-2020 11:30
    Maybe try disabling all local resources and devices within your RDP config?

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 3.  RE: Excel Query

    Posted 08-14-2020 17:55
    What component is putting out the "internal error" message? Excel? ODBC? Windows? Have you checked the Event Viewer?

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------



  • 4.  RE: Excel Query

    Posted 08-14-2020 20:39

    Here you go – pretty much says the same thing as the error box that come up..

     

    Log Name:      OAlerts

    Source:        Microsoft Office 16 Alerts

    Date:          8/14/2020 5:30:55 PM

    Event ID:      300

    Task Category: None

    Level:         Information

    Keywords:      Classic

    User:          N/A

    Computer:      TERM2018-2.ioc.local

    Description:

    Microsoft Excel

    [ProvideX][ODBC Driver]Internal error

    P1: 100749

    P2: 16.0.11727.20244

    P3:

    P4:

     

    Event Xml:

    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

      <System>

        <Provider Name="Microsoft Office 16 Alerts" />

        <EventID Qualifiers="0">300</EventID>

        <Level>4</Level>

        <Task>0</Task>

        <Keywords>0x80000000000000</Keywords>

        <TimeCreated SystemTime="2020-08-15T00:30:55.000000000Z" />

        <EventRecordID>361</EventRecordID>

        <Channel>OAlerts</Channel>

        <Computer>TERM2018-2.ioc.local</Computer>

        <Security />

      </System>

      <EventData>

        <Data>Microsoft Excel

    </Data>

        <Data>[ProvideX][ODBC Driver]Internal error

    </Data>

        <Data>100749

    </Data>

        <Data>16.0.11727.20244

    </Data>

        <Data>

        </Data>

        <Data>

        </Data>

      </EventData>

    </Event>

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     




    Original Message


  • 5.  RE: Excel Query

    Posted 08-14-2020 22:02
    If it fails consistently with the same criteria and data then I would suspect that MAS 90 is unable to handle the data (maybe toggle the "Null Date" option). If it's inconsistent with the same criteria and the same data then I would suspect Excel. I see a lot of instability with Excel with both (32 & 64 bit) version 2016 which is the same as Office 365 (and more recently 2019).

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Original Message


  • 6.  RE: Excel Query

    Posted 08-17-2020 09:52
    Remove the 64bit Office and install 32bit. 

    We had this with a site that is HEAVILY dependent on Excel queries. The 64bit driver randomly throughs this error. We found no consistency. One workbook in particular has several queries and would work fine for days, then choke on different queries. 

    Installed 32bit Office and no error since.

    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------

    Original Message


Related Content