Quickbooks Enterprise 13 and Above How To Increase Cache Size

by Joe Payne 7. November 2013 20:16

These steps apply when the full program is installed on the hosting computer (server) and QuickBooks Enterprise Solutions is on R6 release or later.

  1. Go to the computer (server) hosting the company file.
  2. Go to the QBW.ini file in the Intuit folder:
    • Windows Vista and later: C:\ProgramData\Intuit
    • Windows XP or Windows Server 2003: C:\Document and Settings\All Users\Application Data\Intuit\
  3. Click the QBW file. Note: This file is different from the one you can access directly from the program.
    • Use the information below to add a [DBSERVEROPTIONS] section with your chosen values.
      [DBSERVEROPTIONS]
      InitialCache=256 (if set to 0, meaning “None”)
      MaxCache=512 (if set to 0, meaning ‘Unlimited’)
      Notes about InitialCache: The initial cache setting is used only until the first company file is opened. The initial cache adjusts at that time. Setting it to 0 or none should have no impact on performance.
      Notes about MaxCache: The max cache is the maximum amount of memory QuickBooks database manager can use to communicate with the Sybase database file (company file). Increasing this can improve performance. Setting this to 0 makes it "Unlimited". It is not truly unlimited but actually "Database managed" and can use more memory when needed.
  4. Save the file.
  5. Important! For the .ini file settings you entered to "take affect" you need to turn off Hosting from the file menu and turn it back on.  This will disconnect any user's sessions that are running at the time.
  6. If you have a "server only install" you can do the steps below:
    1. From the command prompt, type: net stop QuickBooksDB23 (or QuickbooksDB24)
    2. From the command prompt, type: net stop QBCFMonitorService
    3. From the command prompt, type: net start QBCFMonitorService

Tags: , ,

QuickBooks Connector | Tech Support

SOAPException error Maximum Request Length Exceeded

by Joe Payne 2. January 2009 13:22

Came across an interesting issue this week.  A customer encountered an unexpected error with the QuickBooks Web Connector after functioning just fine for months.  Based on the Log files, the system was throwing an exception when it tried to read the customers from QuickBooks and transfer the list to the AC7 web service.

After some really deep digging, the exception message was noted and revealed a curious limitation.  By default, SOAP commands/responses are limited to 4Mb in size.  Anything larger will throw an exception on the site.   This could easily happen on larger QB company files with a big customer or product list.

The solution is pretty simple: 

  1. MAKE A BACKUP OF YOUR WEB.CONFIG FILE FIRST! 
  2. Modify the Web.config file in the root of the site
  3. Find the <system.web> section and add a new line below it.
  4. Insert the command <httpRuntime maxRequestLength="8192" />
  5. Save the web.config file

The 8192 value represents an 8Mb limitation.  If this isn't enough, simply make it large enough to handle your particular needs.

 

Tags: , ,

AC7 Articles | Personal | QuickBooks Connector | Tech Support

Month List