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 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 ...
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 ...
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 ...
Steps to enable Google Analytics Connector
1. Stop the Analytics Plus services. 2. Modify the entry under <Analytics Plus home>/reports/conf/app.properties show.create.google.analytics.view=true Note: If the above property is missing, add them. By default the value will be set to 'false' 3. ...