payments solved.

TABLE OF CONTENTS

• Error
• Cause & Results
• Resolution
• Workaround

Error

If you have received the Salesforce error below:

Subject: Courtesy notification from Asperato: Salesforce failed to accept data from Asperato

Asperato attempted to post data to your Salesforce org. Unfortunately Salesforce was unable to accept the data.

The reason text given by Salesforce was:

Not a JSON Object: [{"errorCode":"APEX_ERROR","message":"System.LimitException: c2g:Too many SOQL queries: 101\n\n(c2g)"}] Raw JSON request: {"request":{"putPaymentRequestData":"{\"PutPaymentRequestDetails\":[ 

Cause & Results

The cause of this is the FinancialForce Asperato Integration package attempting to update the Sales Invoice to paid when creating the Cash Entry but hitting the SOQL query limit and the result of this is that Asperato cannot then update your Payment Record in Salesforce even when that payment has been successfully collected from the customer.  

When this happens, you will need to update your Payment Record manually - if you contact our support team (support@asperato.com) they can provide you with the details required to do this.

This error in nature is intermittent and not easily reproducible.

Resolution

A fix is being planned by FinancialForce which will address this in a future version (you will need to contact FinancialForce support directly to determine exact dates when this will be available)

Workaround

If the error is causing you business issues and you would like a workaround - you can set the custom setting (found under Asperato One (FF) custom settings) 'Enable Cash Processing' to be set to FALSE i.e unchecked.  Doing this will cause Payment Worker records to be created rather than Cash Entries, and then you can schedule the FFASP Payment Worker scheduled job to run at intervals which suit your business (for processing more regularly than daily e.g hourly you can have your admin or Salesforce developer set this up via Salesforce developer console)