Skip to main content
Question

FSM 6 Update 10 - Request Sync Rule

  • February 17, 2022
  • 2 replies
  • 63 views

Forum|alt.badge.img+6

Hi everyone, Related to FSM 6 UPD10, we realized that the REQUEST syncrule (Initial query) is mentioning two database views (‘task_assigment_view2’ and ‘task1_view’) that seems does not exist. 

If I query for the related views  I get the next error:

 

Please, see attached document with the XML SYNCRULE. 

Can someone help me on this?

Thanks and regards,

This topic has been closed for replies.

2 replies

brian.gummin
Hero (Employee)
Forum|alt.badge.img+15
  • Hero (Employee)
  • February 18, 2022

Those <table> references are defined as aliases in metadata.  They do no exist in the data schema.  You can find those table_name values on the FSM Metadata screen (if using a STUDIO license).  Aliases are a mechanism in metadata to allow joining to the same table or view multiple times.


Jon Reid
Hero (Employee)
Forum|alt.badge.img+18
  • Hero (Employee)
  • February 18, 2022

To further clarify Brian’s comment, these views are metadata-only and do not exist in the database.  There are used in the server code only to process hierarchy selects referencing the same table/view more than once in the same query.