Facing issue in RightFax web API authentication

Options

We are trying to integrate RightFax web API (Version RightFax 21.2) for Send and Receive Fax in our web application.

While accessing RigthFax API methods through API URL (eg: "https://localhost/RightFax/API/Users/"), its asking for username and password, we have supplied admin credentials and its showing below error:

{"Message":"An error occurred while executing the command definition. See the inner exception for details.\r\n● Invalid column name 'TimeStart'.\r\nInvalid column name 'TimeEnd'.","Links":[]}

We have tried below steps also in our Fax server:

1. Access RightFax web app URL: https://localhost/RightFax/signin/basic?action=signin

2. Its asking to enter user name and password, entered admin account's credentials.

3. Here also, its showing the same error. 

"An error occurred while executing the command definition. See the inner exception for details. ● Invalid column name 'TimeStart'. Invalid column name 'TimeEnd'."

Is it due to some missing installation or configs which are not updated correctly? Please suggest a solution. Any suggestion would be appreciated.

Comments

  • Hello,

    This is a known bug (OpenText bug RF-30999) and involves a bit of a peculiar interaction with RightFax 21.2 web api and SQL 2016, and some web functionality that relies upon SQL functionality not present in SQL 2016.

    Our recommendation at this time is to install a fresh* (*a SQL upgrade has proven unreliable in our testing) copy of SQL 2017 or higher.

    This should resolve the issue.