Data Sync Cache

There is no UI to inspect the cached data except inside the record editor.

What do you want to achieve? Why would you want to compare something?

We are trying to check the data discrepancies between MDM and APPLICATION Data sources. And we need to figure it out where it is going wrong despite DATA SYNC.

"Total Data Sync" failed. Yes, checked in the tomcat-stdout log file. 

2022-07-18 12:46:52,471 [RecordSyncScheduler_Worker-2] ERROR com.appiancorp.record.service.BulkLoadServiceImpl - Unrecoverable error in record data sync: Unable to sync due to a system failure.
2022-07-18 12:46:52,499 [RecordSyncScheduler_Worker-2] ERROR com.appiancorp.record.service.BulkLoadServiceImpl - Error syncing record type with uuid: 366eb36d-ddff-4817-8582-d9f073c70128
com.appiancorp.suiteapi.common.exceptions.AppianException: Unable to sync due to a system failure. (APNX-1-4521-016)
	at com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException.<init>(AppianRuntimeException.java:45)
	at com.appiancorp.record.datasync.error.RecordDataSyncException.<init>(RecordDataSyncException.java:27)
	at com.appiancorp.record.datasync.error.UnretriableRecordDataSyncException.<init>(UnretriableRecordDataSyncException.java:15)
	at com.appiancorp.record.datasync.error.GenericDataSyncException.<init>(GenericDataSyncException.java:13)
	at com.appiancorp.xbr.exceptions.ExpressionSourceExceptionTranslator.translateSourceException(ExpressionSourceExceptionTranslator.java:20)
	at com.appiancorp.xbr.query.ExpressionDataReader.readInner(ExpressionDataReader.java:148)
	at com.appiancorp.xbr.query.ExpressionDataReader.readInner(ExpressionDataReader.java:112)
	at com.appiancorp.xbr.query.ExpressionDataReader.readNext(ExpressionDataReader.java:98)
	at com.appiancorp.xbr.query.ExpressionDataReader.readNext(ExpressionDataReader.java:43)
	at com.appiancorp.record.data.sourceloaders.SequentialBulkLoadController.lambda$readBatch$6(SequentialBulkLoadController.java:446)

What kind of record is this? DB or service backed?

DataBase Stefan Helzle

Is there more information in the logs, like an eventual "caused by" statement below that section? Also can you share what you're seeing the sync history view - does it show failed there as well? To be honest I'm not sure that is the correct error message because it mentions "XBR" in several places, which is an expression-backed record, not database backed.

That was exactly why I was asking for the nature of the record. If this is service backed, it might be an issue with the source expression.

Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.security.authz.AuthorizationException: The user [md429209] does not have sufficient privileges to perform the requested action because they are not in any role. (APNX-1-4188-001)
	at com.appiancorp.security.authz.AppianAuthorizationProvider.authorize(AppianAuthorizationProvider.java:42)
	at com.appiancorp.security.authz.AuthorizationMethodInterceptor.invoke(AuthorizationMethodInterceptor.java:47)
	at com.appiancorp.kougar.services.KougarServiceInvocationHandler.invoke(KougarServiceInvocationHandler.java:324)
	at com.sun.proxy.$Proxy124.getCachedImmutableCredentials(Unknown Source)
	at com.appiancorp.security.auth.GroupMembershipInfoProvider$GroupMembershipInfoProviderGmcImpl.getMemberGroupUuids(GroupMembershipInfoProvider.java:63)
	at com.appiancorp.suiteapi.security.auth.AppianUserDetails.getMemberGroupUuids(AppianUserDetails.java:291)
	at com.appiancorp.suiteapi.security.auth.AppianUserDetails.getRoles(AppianUserDetails.java:328)
	at com.appiancorp.suiteapi.security.auth.AppianUserDetails.getAuthorities(AppianUserDetails.java:230)
	at com.appiancorp.security.auth.SpringSecurityContextHelper.setSpringSecurityContext(SpringSecurityContextHelper.java:87)
	at com.appiancorp.security.auth.SpringSecurityContextHelper.setSpringSecurityContextLazy(SpringSecurityContextHelper.java:69)
	at com.appiancorp.security.auth.SpringSecurityContextHelper.runAs(SpringSecurityContextHelper.java:274)
	at com.appiancorp.security.auth.SpringSecurityContextImpl.runAs(SpringSecurityContextImpl.java:41)
	at com.appiancorp.xbr.evaluator.ExpressionEvaluatorImpl.evaluateToListOfMap(ExpressionEvaluatorImpl.java:212)
	at com.appiancorp.xbr.evaluator.ExpressionEvaluatorImpl.executeInner(ExpressionEvaluatorImpl.java:187)
	at com.appiancorp.xbr.evaluator.ExpressionEvaluatorImpl.execute(ExpressionEvaluatorImpl.java:90)
	at com.appiancorp.xbr.query.ExpressionDataReader.readInner(ExpressionDataReader.java:122)
	... 53 more

If you could post your source expression code, we could help. From the error messages, it looks like you try to check some group membership. This fails because of missing permissions.

Thank you Stefan Helzle.

Does this solve the issue? Is the record DB or service backed?

Next time when posting here, please provide the necessary details in the beginning to get a proper answer much faster.

Not solved yet. But Informed.

Yeah sure Stefan Sorry for the trouble, here onwards will provide all the necessary details. Thanks a million,

Not solved yet. But Informed.

Yeah sure Stefan Sorry for the trouble, here onwards will provide all the necessary details. Thanks a million,