• PO archive and upgrade?

    Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…
  • Table and Field Naming mode - JDBC2Pervasive query

    I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB. In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db. Class name is: com.pervasive.jdbc.v2.Driver. URL is in…
  • Anyone running Sage CRE 300 2017 on Windows Server 2008 R2 SP1?

    We need to upgrade to Sage 2017 for end of year updates and are not prepared to upgrade our server at this time. Has anyone been able to upgrade from 16 to 17 on Server 2008 R2 w/SP1? We are looking to do this temporarily until we can upgrade our…
  • Database Schema for Sage 300 CRE?

    FormerMember
    FormerMember
    Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…
  • Why can't I open company files after updating to 17.1

    FormerMember
    FormerMember
    After successfully upgrading sage 300 to 17.1 on a server, I go through the process of updating the company files from 15.1 without any issues. I can open all files except the main file and I get an error saying that " upgrade cannot continue due to consistency…