Error in Adjustments and Retirements when using a long search query

Owned by Knowledge Assistant
Nov 04, 2020
1 min read


Description of Issue

Error in Adjustments and Retirements when using a long search query:  Unable to prepare select statement, status -6372 [ISAM -156] Incorrect syntax near the keyword 'as'

Context

Fixed/Capital Assets

Cause

Query was limited to 20,000 characters

Resolution

Install the appropriate work ticket for your version:

  • 11.3.20.0 - MUN-356697
  • 2017.1.17.0 - MUN-375125
  • 2017.3.0.0 - MUN-357126
  • 2018.1.21.0 - MUN-357127

Workaround:  Break up the search criteria into groups of less than 20,000 characters

Additional Information