There are 3 possibilities depending on the wording of the second part of the error message:
The SELECT permission was denied on the object '<customSQLobject>', database '<databaseName>', schema 'dbo'.
The problem is that the Dimensions User does not have the right SQL Server side permissions to the custom SQL Object. In this case it's most likely a SQL View.
It's very likely that to fix this the Database Role AA_DIMENSIONS_R will need to be granted SELECT permissions from the custom SQL Object (View). If the message came up due to Focalpoint integration then it's possible that ARM_TMS_R would be the Database Role required instead.
Please ask your SQL Database Administrator to do this for you.
If you do not have anyone with the knowledge to do this, then please raise a new case online and reference the title of this article. Please also include the error message in your new case description.
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or
The problem is likely related to the SQL Server connection between your local (the client) PC and the SQL (server) PC.
You should consult your IT for further assistance with this as they will need to check that there are no relevant Firewall ports being blocked.
Some other wording
The probability is that the issue is with the FocalPoint PIR approval settings.
An example of an Error Message related to FocalPoint PIR approval settings would be:
The Transaction will be set to Cancelled. Error in ProcessMessage: Object reference not set to an instance of an object
OR
The Transaction will be set to Cancelled. Error in ProcessMessage: No default approver configured
If this is the case, please see contact the FocalPoint support team