Monday 10 September 2018

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database

Steps today are
1. httpRuntime executionTimeout
added executionTimeout to ...\Reporting\web.config Line now reads
<httpRuntime executionTimeout = "10800" maxRequestLength="51200" />
2. ASP Script timeout
increased this from 00:01:30 to 00:05:00
IIS Manger -> server -> sites -> Sharepoint Web Services. find the reporting service by right click -> Manage Application -> Advanced Settings -> Physical Path. Then open ASP in right pane, expand Limits properties, Script Time-Out click apply (top right pane)
3. Changed processing options on individual reports
5.45am Report - processing timeout changed to 3600 (was previously default value)
5.53am Report - processing timeout changed to never (was previously default value)
4. Stopped and Restarted IIS
__________________________
Browse the reporting service -> site setting -> general tab -> change the time out value

Making Price to 4 decimals


First make price EDT to 4 decimal then 
General Ledger ->Setup->Currencies->currency

select the currency and make the rounding rule to 0.0001

Access denied to method validateDataContracts in class SysOperationFarmeworkService AX 2012

The permission is included in AifEssentials privilege and the privilege is normally included in SystemUser role (through SysServerAXBasicMaintain duty). Therefore it seems that you forget to add the user to SystemUser role.

Read-only DocuRef form for Auditors

The most common problem encounters while auditing period in companies is not to allow auditors to attach or delete attachments from DocuRef form. However, there is no out of the box role in AX, but it can be achieved with small customizations and by applying the modified duplicated copy of system role and privilege.

STEP 1


Make duplicate copy of “SystemUser” role and “DocumentHandlingEssentials” privilege. In my case, I have duplicated with the name “MySystemUser” and MyDocumentHandlingEssentials”.

STEP 2

In “MyDocumentHandlingEssentials” remove all entry points accept “DocuView”.

STEP 3

Now assign “MyDocumentHandlingEssentials” privilege to “MySystemUser” role and make sure“DocumentHandlingEssentials” is not overriding it.

STEP 4

Now go to “DocuView” form and change the “NeedPermission” property for both “New” and “Delete”command buttons to “Delete”.



You are done with the changes, now assign this customized “MySystemUser” to Auditor user and remove the default “SystemUser” role.



Note: In some AX builds you may find a privilege with name “ClientEssentials”, it too contains all“DocuRef” entry points, so if you find one in your build, apply the same process of duplicating and removal of all “DocuRef” related entry points from it. 

User and roles report

There is a query in AX called SysSecRolesForUser that gives this data. You can simply create a view from it and export to excel.