Symptom: When running a list or analysis query that uses an Optional(Right Join) Link Group combined with other Link Groups, this error is returned from ClayCentral. For example, an Analysis query that uses a right-joined Link Group as the Series, and a normal Link Group as a filter.

Causes: This is due to a limitation in MDB/Jet databases that disallows specific combinations of right with left/normal joins in the same query.

Solutions:

• If possible, use only right-joined Link Groups in the query in all columns, filters and dimensions.
• Upgrade to SQL Server.