Sage 100

 View Only

  • 1.  CI_Item was restored from a Windows Server 2012 using Previous Versions, New Power Queries get Error 1004

    Posted 11-10-2023 10:16
    Edited by Dan Burleson 11-10-2023 11:41

    This can now be removed from Urgent Support!

    Sage 100 2016 Advanced: The restore using Windows Server 2012 "Previous Versions" was done after work hours, to a period 2 hours earlier. Everything seems fine, but, with that file, they cannot create new Excel Power Queries which uses OLEDB. Crystal reports and Excel MS Query can create reports on CI_Item using SOTAMAS90. 

    Things I've tried:
    1. Rebuild Key Files w/Integrity Check - no issue found
    2. Workstation Setup
    3. Verified all file security and permission attributes
    4. Restarted Sage server

    Microsoft Query work



    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    ------------------------------



  • 2.  RE: CI_Item was restored from a Windows Server 2012 using Previous Versions, New Power Queries get Error 1004

    Posted 11-10-2023 10:33

    Is PvxSec32.dll or PvxSec64.dll missing from the \MAS90\ folder or

    Is PvxSec64.dll missing from C:\Windows\System32\ or is PvxSec32.dll missing from C:\Windows\Syswow64\  ?



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: CI_Item was restored from a Windows Server 2012 using Previous Versions, New Power Queries get Error 1004

    Posted 11-10-2023 10:47
    Edited by Dan Burleson 11-10-2023 10:47

    Thanks for the quick response. All 4 files are in the listed folders.



    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    ------------------------------

    Original Message


  • 4.  RE: CI_Item was restored from a Windows Server 2012 using Previous Versions, New Power Queries get Error 1004

    Posted 11-10-2023 10:56

    Have you tried forcing an Excel update?  There have been some recent issues with Excel related to updates that were corrected by MS.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 5.  RE: CI_Item was restored from a Windows Server 2012 using Previous Versions, New Power Queries get Error 1004

    Posted 11-10-2023 11:01

    I'll try that. I've been seeing those, but the issue is only with the one file (CI_Item) that was restored, I'm thinking it has more of an issue with the data dictionary that's different for OLEDB. Also, this is 32-Bit Excel.



    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    ------------------------------

    Original Message


  • 6.  RE: CI_Item was restored from a Windows Server 2012 using Previous Versions, New Power Queries get Error 1004

    Posted 11-10-2023 11:14

    This problem can be taken off Urgent.

    The issue was that the Excel Data Source Settings was pointing to a test CompanyCode that was missing CI_Item.



    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    ------------------------------

    Original Message


Related Content