question

ValterPrykri-7717 avatar image
0 Votes"
ValterPrykri-7717 asked DianGermishuizen-5071 published

What does the error message "This query should be recompiled with the hinted DOPP. Please resubmit." in Synapse Serverless mean?

Error message in title. I changed the definition and underlying data for a openrowset view (Serverless pool), and a view referencing this view started producing this error. Same error appears when running the query in the view. I tried rebuilding the views but that did not fix the error. What can I do to fix this error?

azure-synapse-analytics
· 3
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PRADEEPCHEEKATLA-MSFT avatar image PRADEEPCHEEKATLA-MSFT ·

Hello @ValterPrykri-7717,

Thanks for the question and using MS Q&A platform.

Could you please let me know the following details:

  • Is this the first time you are observing this issue for this same query? Are you also observing the same issue when running any other query?

  • Are you using any client tool such as SSMS? It would be interesting to evaluate if your query is failing in both Synapse Studio and SSMS.

  • Are you running this query against the built-in master database or any other serverless pool that you have created?

  • Could you please share the query statement that you are running so I can have more context on the use case

Much appreciated in advance for your collaboration, I'm looking forward to your reply.

0 Votes 0 ·
ValterPrykri-7717 avatar image ValterPrykri-7717 PRADEEPCHEEKATLA-MSFT ·

  1. Yes, first time.

  2. Same issue with SSMS, Data Studio and Synapse studio

  3. Built in pool, created database (not master)

  4. Cannot share, fairly complicated query. Basically a Fact view that joins to Dimension views to lookup surrogate keys. So something like:
    SELECT *
    FROM
    OPENROWSET (...)
    LEFT JOIN dbo.DimCustomer
    ON ...
    LEFT JOIN dbo.DimSector
    ON..

Would be easier if you could find out what the error message means?

0 Votes 0 ·
ValterPrykri-7717 avatar image ValterPrykri-7717 ValterPrykri-7717 ·

The issue seems to have disappeared now. I would like to know if this is a bug or if there is something I can do if I recounter the issue?

0 Votes 0 ·

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
1 Vote"
PRADEEPCHEEKATLA-MSFT answered DianGermishuizen-5071 published

Hello @ValterPrykri-7717,

Thanks for the question and using MS Q&A platform.

Thanks for reporting this issue. We have mitigated this issue from our backend.

Hope this will help. Please let us know if any further queries.

  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DianGermishuizen-5071 avatar image DianGermishuizen-5071 ·

Please note, I am now receiving this issue at the moment as well. Please confirm the bug has been resolved in the backed as stated.
Thank you!

0 Votes 0 ·