Problem When clicking on a sample job/event, the following error occurs:
Incorrect syntax near the keyword 'Group'. Line 1: Incorrect syntax near ')'. Line 1: Incorrect syntax near ')'. The ORDER BY position number 2 is out of range of the items in the select list. Statement(s) could not be prepared.
1. Go to the ODBC settings in
Control Panel under
2. Open the ODBC Data Source Administrator window and click on the system
3. Highlight "Altiris eXpress Database", and click on
Next through the next two screens and make sure that "Use ANSI quoted Identifiers" and "Use ANSI nulls, paddings and warnings" are checked.
check mark by both of these boxes will solve the issue.
Rate this Article
This is machine translated content
Login to Subscribe
Please login to set up your subscription.
Didn't find the article you were looking for? Try these resources.