New article
Recently updated
Ideagen Internal Audit (Aura): Error: A problem occurred attempting to initialise the data mapper. See Errors for details
Issue
When accessing the application the user receives the following error:
Protocol exception:
Universal Time: (2019-09-18 15:57:18) Local Time: (2019-09-18 16:57:18) TimeZone: (01:00:00 DST)
Version: 5.4.0.4
The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (application/soap+xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 1024 bytes of the response were: '<!DOCTYPE html>
<html>
<head>
<title>A problem occurred attempting to initialise the data mapper. See Errors for details</title>
With inner exception:
Universal Time: (2019-09-18 11:24:47) Local Time: (2019-09-18 11:24:47) TimeZone: (00:00:00 )
Version: 5.4.0.4
The remote server returned an error: (500) Internal Server Error.
In addition, when browsing to the service (http://[servername]/[virtualfolder]/service/TngService.svc) the following error is shown:
Server Error in '/[path]/Service' Application.
A problem occurred attempting to initialise the data mapper. See Errors for details
The service log file contains the following error:
The SELECT permission was denied on the object 'DataTable', database 'Pentana54', schema 'dbo'.
Solution
The database user configured for the application does not have the correct roles. Check that the database user has at least:
db_datareader
db_datawriter
Note that if the system is in the initial implementation phase then it may be necessary to add dbo as well, until configuration is complete.