Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • FAQs
  • AssetCloud & InventoryCloud (web and On-Premise): large number of custom fields causes labels or reports to time out
Subscribe Download PDF

AssetCloud & InventoryCloud (web and On-Premise): large number of custom fields causes labels or reports to time out

Scott Leonard
2022-02-15
in FAQs

This article applies to AssetCloud and InventoryCloud, both the web and On-Premise editions.

It is possible to create a large number of custom fields that overwhelms the system, and causes label and/or report printing to time out. The message "No more than 3000000 SPAssetViewsWithCustomFields records allowed in the web" may be seen.

When the custom fields are not needed in the label or report, you can edit the label/report layout and remove the SpAssetViewsWithCustomFields query, which will simplify the processing of the label/report. (For InventoryCloud, this will be called SpItemViewsWithCustomFields.)

  1. In the left menu, click Reports, All Reports, and expand until you find the desired report. Click the Design Report button to the right.
  2. In the report designer, at the left, expand Data Sources, then WaspDB2012 [MS SQL]. (Refer to the screenshot below.)
  3. In the label/report layout, click to select the blue data band called "DataSpAssetViewsWithCustomFields". Click Delete in the top toolbar (or press the Delete key on the keyboard).
  4. At the left, click to select "SpAssetViewsWithCustomFields" under WaspDB2012 [MS SQL]. Click the red X button in the small toolbar just above (or press the Delete key on the keyboard). Click Yes to the confirmation dialog.
  5. File menu, Save As with a new name, or optionally just do Save to keep the same label/report name.
  6. Close the report designer.

report-custom-fields.png

Rate the quality of this page

This page was helpful :) :( This page was not helpful

Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro