The query processor could not produce a query plan

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
nagarjuna900
Participant
Posts: 35
Joined: Mon Dec 29, 2008 2:22 am
Location: chennai

The query processor could not produce a query plan

Post by nagarjuna900 »

Hi,

am getting the following error. How can i solve this.
[DataDirect][ODBC SQL Server Driver][SQL Server]Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.

Thanks,
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Contact Customer Support Services?

Could it be that the executing user lacks sufficient database/table privileges to be able to create a query plan? Could it be that the table where query plans are recorded does not exist?

It is unlikely that the problem is internal to either DataStage or the ODBC driver.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply