1. Home
  2. Support
Article - CS154496

Error "java.sql.SQLException: The query processor ran out of internal resources" when executing a WTDocument extract with Windchill Bulk Migrator 2.1

Modified: 19-Dec-2013   


Applies To

  • Windchill Bulk Migrator (WBM) 2.1 M010

Description

  • Following error is receive after executing  windchill com.ptc.windchill.migration.wbm.wc2wc.extractor.client.WindchillDataExtractor -o wt.doc.Document when SQL Server is used

There might be some error in the SQL: SELECT  *
 FROM (
SELECT  distinct WTDocumentMaster.idA2A2 masterId
 FROM WTDocumentMaster,WTDocument
 WHERE  WTDocumentMaster.idA2A2 = WTDocument.idA3masterReference
 AND WTDocumentMaster.markForDeleteA2 = 0
 AND WTDocument.markForDeleteA2 = 0
 AND WTDocument.updateStampA2 > '2013-09-01 00:00:00.000'
 AND WTDocument.updateStampA2 < '2013-09-30 00:00:00.000') MasterIds
 WHERE  1=1
 AND  ( masterId IN ( Very long list of ida2a2)
OR masterId IN (Very long list of ida2a2)
...
com.ptc.windchill.migration.wbm.wc2wc.util.WBMException: java.sql.SQLException: 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.
    at com.ptc.windchill.migration.wbm.wc2wc.util.WBMExceptionHandler.throwException(WBMExceptionHandler.java:33)
    at com.ptc.windchill.migration.wbm.wc2wc.extractor.client.Extractor.executeQuery(Extractor.java:310)
    at com.ptc.windchill.migration.wbm.wc2wc.extractor.client.Extractor.extract(Extractor.java:160)
    at com.ptc.windchill.migration.wbm.wc2wc.extractor.client.WindchillDataExtractor.main(WindchillDataExtractor.java:90)
Caused by: java.sql.SQLException: 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.
    at com.ptc.windchill.migration.wbm.wc2wc.util.wbmutil.JDBCUtil.getResultSet(JDBCUtil.java:311)
    at com.ptc.windchill.migration.wbm.wc2wc.util.wbmutil.JDBCUtil.getResultSet(JDBCUtil.java:297)
    at com.ptc.windchill.migration.wbm.wc2wc.extractor.client.Extractor.executeQuery(Extractor.java:299)
    ... 2 more
 
  • Following error is recieved when Oracle is used:
No more data to read from socket
 
This is a printer-friendly version of Article 154496 and may be out of date. For the latest version click CS154496