NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm

Data Matrix or other SQL errors when opening the Pricing Console

Owned by Tony Hayes
Last updated: Jun 20, 2018
1 min read

Problem

You attempt to open the pricing console and receive SQL errors relating to Arithmetic Overflow.

Cause

Field value is not properly set or way outside normal parameters.  Something such as the Admin % field being set to 150000%.  Downstream calculations that use this number will fail.

Solution

Fix erroneous data

  1.  Find the erroneous field on one of the Pricing Forms - either Batch, State or Code. 
  2. Since you cannot access these forms through the Pricing Console, you need to go to the Workspace in Question and Access Dataforms   from the Workspace Action Menu
  3. Navigate to the forms in question, find the offending field and correct the value

 Pricing Error: "An error occurred executing the business rule: RecalculatePricing"                            

                 


NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm