Record Error in stdout log every min

Certified Senior Developer
We are getting the following error every minute in the stdout.log.
java.util.concurrent.ExecutionException: com.appian.data.client.AdsUserInputException: APNX-3-1100-022: Query target must be a valid table reference. Invalid: "df_records"."10414987-1995-45eb-9baf-eebaf764386a_live" at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:205) at com.appiancorp.record.query.ads.ComplexSyncedRecordQueryRunner.runQuery(ComplexSyncedRecordQueryRunner.java:156) at com.appiancorp.record.query.semanticsearch.LowLevelSearchDecorator.runQuery(LowLevelSearchDecorator.java:46) at com.appiancorp.record.data.sourcedataaccessors.RecordReplicaDataAccessor.lambda$getRecordsInner$2(RecordReplicaDataAccessor.java:132) at com.appiancorp.record.data.sourcedataaccessors.RecordReplicaDataAccessor.getRecordsOptimistically(RecordReplicaDataAccessor.java:176)
Sync has not been scheduled for the record. (UUID: 10414987-1995-45eb-9baf-eebaf764386a) and no error in Sync Record.
Has anyone experienced this error before.
Thanks

  Discussion posts and replies are publicly visible

  • 0
    Certified Lead Developer

    As per my understanding, the error occurs because Appian is trying to query a synced table that doesn't exist since sync was never scheduled.
    To fix: Either enable and schedule sync for this record type (UUID: 10414987-1995-45eb-9baf-eebaf764386a) to create the missing table,
    or disable sync completely and update all queries to non-synced format.
    The error repeats every minute because something (likely a timer/process) keeps querying this missing table.

    Just give a try and let me know if that works for you