A "Query is too complex" message is displayed when the Insert Symbol By Name tool is selected. Other error messages may also appear and at different times, including at start up or when clicking Apply or OK on Setup.Internal ErrorError Message: Query is too complex.TargetSite: System.Data.DataTable GetTable(Int32, System.String)DeclaringType: MDBProxy.ConnectionManagerAttributes: internalMemberType: Method
The error message indicates that the query for gathering data from the catalogs specified in Setup > Catalog Paths is too long. This can be caused by the long paths of deeply "buried" catalog folders, long folder names in the catalog path, or a large number of catalog paths present in Catalog Paths.
Only keep catalogs necessary for current work in Setup > Catalog Paths. Multiple setup configurations can be created with different sets of catalogs loaded in Catalog Paths. A setup configuration could apply to a type of job, a certain client, a standard, etc.
Consider moving catalog folders so they are less buried and closer to the root, so the paths to them are not as long. The folders would need to be moved using Windows Explorer and then added again to Setup > Catalog Paths.
Consider consolidating catalogs so there are fewer catalogs necessary in Setup > Catalog Paths. For example, all the components of a manufacturer could be in one catalog, or a certain part type from various manufacturers could be in one catalog, or even all the parts for a particular type of job could be in one catalog.
It may be practical to consolidate the items that are used into one catalog and remove the remaining catalogs and the unused items they contain from Catalog Paths. This is frequently applicable when there are many downloaded manufacturer catalogs in Catalog Paths but only some items are used in each.
Copy items to another catalog