AxExport.exe tool is unable to export large amounts of jobs

book

Article ID: 171929

calendar_today

Updated On:

Products

Ghost Solution Suite

Issue/Introduction

While trying to utilize the axexport.exe tool to export over 10,000 jobs from the Ghost solution Suite product you receive an error.

Error executing SQL query:
The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.

Cause

Limitation of the axexport.exe tool

Environment

Ghost Solution Suite 3.x

Resolution

Development is currently aware of this issue and is working towards resolving it.  If you'd like to be notified when this issue has been fixed, please subscribe to this tech article and you'll receive an email notifying you that the issue has been fixed.