Reflection not working

I don’t have that reflection id in sys.reflections.

4f1d1aae-cc2c-4d3d-afc1-3077df76f81d.zip (11.0 KB)

OK, I did this again and attached the profile here. It’s the same reflection.

@wz2020

The log file and profile needs to be in pairs. This time you have only sent me the profile

The ID I gave above to search was a query ID and not reflection ID so please search for the ID I gave before in the jobs page and send me the profile or alternate is to send me the log file for the reflection you just created

I’m really confused now. I don’t see that ID in jobs page other than if it’s the reflection ID. See the screenshot.

OK, I started a new reflection and attached all relevant files:

The reflection seems to be OK and I have also attached the query profile:

But on the dataset screen, you can clearly see reflection is not working with the infamous error message:

f4eaf422-63de-4e1e-9e28-2a06e2efe3a4.zip (89.2 KB) mylog.zip (51.2 KB)

I see this error in the log: Caused by: com.dremio.connector.metadata.DatasetNotFoundException: null
But have no idea why that is. The query without acceleration works fine so all the datasets are there for the query to work.

@wz2020

The code base has changed a lot since 3.2 to 3.3 to 4.0 to 4.1 to 4.2 to 4.3 to 4.5. I am not saying this problem would for sure go away but it is extremely difficult to troubleshoot this with 3.2.

Drop the reflection
Upgrade Dremio
Recreate the reflection

Does it work?

OK, I will give that a try and revert. Thanks.