Error - 'The Transaction will be set to Cancelled. Error in ProcessMessage' when submitting a PIR for approval in FocalPoint

The cause of this error depends on the second part of the error message:

'The SELECT permission was denied on the object [object], database [database], schema dbo.'

The Dimensions user does not have the correct SQL Server permissions on the custom SQL object (most likely a SQL View). The database role AA_DIMENSIONS_R needs to be granted SELECT permissions on that object. If the error is related to FocalPoint integration, ARM_TMS_R may be the required role instead. Ask your SQL Database Administrator to grant the permission. If you do not have someone with the knowledge to do this, contact support. See Get support in Dimensions.

'A network-related or instance-specific error occurred while establishing a connection to SQL Server.'

The issue is likely a SQL Server connection problem between the client PC and the SQL Server. Contact your IT team — they will need to check whether any relevant firewall ports are blocked.

Some other error wording

The issue is likely with the FocalPoint PIR approval settings. Examples of this type of error:

Contact the FocalPoint support team for help with PIR approval settings.