Error received when querying by User Status in Assets

Owned by Knowledge Assistant
Last updated: Oct 18, 2021
1 min read





Description of Issue

Error received in Assets after clicking Query, entering search criteria in User Status field, and clicking Execute:

Execute count_Assets failed - status:  -201  [ISAM - 102]
Incorrect syntax near '='.
Incorrect syntax near the keywork 'like'.



Context

Tyler EAM



Cause




Resolution

Install the appropriate work ticket for your version once it's been released:

  • 2019.1.22.0 - MUN-422891

  • 2020.3.0.0 - MUN-423111

  • 2021.1.0.0 - MUN-423112

  • 2021.2.0.0 - MUN-423113

  • 2021.3.0.0 - MUN-423114

  • 2021.4.0.0 - MUN-423115

Workaround:  In Assets, click Search, enter search criteria, and click Accept



Additional Information