Database Connector Enhancements
All database connector import calls were done with SQLs. This was resulting in issues when values are imported to BLOB columns or large values are imported to CLOB columns. This was handled by supporting a prepared statement option for import. The new option is controlled by the below configuration property to avoid any issue with the existing workflows. The BLOB columns were not supported on export and lookup. As part of this enhancement, export and lookup are enhanced to support BLOB columns. The BLOB columns can have characters which are not in the valid range of XML characters. So the value is base-64 encoded during export and import is expecting a base-64 encoded value for BLOB columns.
ServiceNow Request Enhancements
ServiceNow Request data format is enhanced to support batched sub calls to fetch request item variables. The batch limit set for request item variable fetching is 40. Before this enhancement, request item variable details were fetched per variable during export and lookup. This was huge overhead when there are many request item variables for a request. During a Request modify, all request item variable details were fetched in a single call after including a condition for each request item variable. This resulted in creating a request which exceed the GET call limit.
Request item variables in Request data format is under request item. So the modify type is applied only on request item and not on request item variable. This resulted in a requirement of providing all variables even to manage a single variable. To avoid this limitation, introduced a changeType attribute at the request item variable level so that individual variables can be managed easily. The values supported for changeType are add, modify and delete. If any one of the request item variable has a change type, all request item variables are processed by change type. A change type of add is taken for all variables which doesn't have a change type.
SAP GRC Request Queuing Configuration
When SAP GRC request queuing was introduced, SAP GRC processor was always doing that. This is modified to process based on the below configuration property. This option will allow to skip the queuing when some request processing is stuck at some unexpected status.
List of defects reported by customers or implementation, does not contain defects raised internally.
- Fixed issue in managing telephoneNumber for AzureAD. The telephoneNumber attribute should be provided as an array node, which connector was not doing. Made changes in connector to provide it properly.
- Fix post alias management workflow listing. Made changes to list workflows of type normal and resource. Prior to this, it could only be normal.
- Fix SAP GRC status processing. Fixed issue of SAP GRC status processor getting stuck after status processing is failed with unexpected exceptions.
- Modified validation in Alias management to support accented characters in the alias portion. accented characters are not supported in the deliverables feature of alias management.