FAILURE :Exception in creating table in Analytics. JSON Out of Range error
When synchronizing from Servicedesk Plus to Advanced Analytics fresh installation of build 3100 we get the error:
FAILURE :Exception in creating table in Analytics.
The issue seems with the synchronization of request additional fields.
Here is the solution,
- Stop Analytics Plus services and take a backup of <AnalyticsPlus Home>\reports\webapps\ROOT\WEB-INF\securityxmls\security-api.xml
- Download and replace the attached file (security-api.xml) to the same location.
- Start Analytics Plus services and resync the data.
New to ADSelfService Plus?
Related Articles
Unable to sync between Servicedesk Plus and Analytics Plus - ATKey error
Issue: Unable to configure integration/sync between ServiceDesk Plus and Analytics Plus ERROR Message: FAILURE :Not able to get ATKey from Server. You can obtain the error log files from Support tab by clicking on the Support File link in the ...
Sync issue between SDP MSP and Aplus
Issue: Sync fails between ServiceDesk Plus MSP and AnalyticsPlus, after upgrading the SDP to 14730. Cause: An example of a case mismatch issue is when Analytics Plus seeks column alias names such as BillID, but MSP returns BILLID instead. This is a ...
Sync getting stuck in In-progress state
Issue: Sync getting stuck in In-progress state. Usually, when the data type mismatch is present, this issue occurs. Logs required: <AnalyticsPlus>/pgsql/data/pg_log/ Check for the error trace by searching "ERROR: invalid input syntax for" Sample ...
Unable to integrate SDP MSP with Analytics Plus after applying SSL
Note: This problem occurs only with self signed certificates in Analytics Plus. Issue: [10:23:16:526]|[09-05-2020]|[SYSERR]|[INFO]|[68]|: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: ...
Query table throws error upon execute query - Linux - 4400 and above
Issue: Query table's 'execute query' will throw an error as shown below. Even when executing 'select 1', we might get this error. Build affected: 4400, 4410 and 4420 Only on Linux installations Cause: It is due to internal code changes and will be ...