Moneris returns "SQL Problem" on all transaction requests.

This typically arises when there is an issue with the credentials that have been provided. It is an error message thrown by the gateway when attempting to transact or add a payment method to a customer in Fusebill. The error message is what Moneris sends back to Fusebill. 

• Check to make sure the provided credentials are in the correct case (upper and lower) as they are case sensitive.
• Check to make sure that the country of your Moneris account matches the country used to configure the credentials. 
  • There is such a thing as a Canadian account that transacts in USD, for which you will need to configure a "Moneris - Canada" account in Fusebill, but label it and request routing for USD transactions in Fusebill to go that gateway.