Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Explicit joins break X-rays #13112

Closed
Tracked by #21485
jeff-bruemmer opened this issue Aug 13, 2020 · 2 comments
Closed
Tracked by #21485

Explicit joins break X-rays #13112

jeff-bruemmer opened this issue Aug 13, 2020 · 2 comments
Labels
Priority:P2 Average run of the mill bug Querying/Notebook Items specific to the Custom/Notebook query builder Querying/X-rays .Reproduced Issues reproduced in test (usually Cypress) Type:Bug Product defects

Comments

@jeff-bruemmer
Copy link
Member

jeff-bruemmer commented Aug 13, 2020 •
edited by flamber

Describe the bug
When using an explicit join in the notebook editor, X-ray charts fail to load. Implicit joins work as expected.

Logs
Console logs:

A lot of undefined errors. E.g.,

browser console 
app-main.bundle.js?94c2cd9928607894dcfe:5 Error getting setting graph.x_axis.title_text TypeError: Cannot read property 'name' of undefined
    at t.getFriendlyName (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at Object.getDefault (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at g (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.getComputedSettings (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at h (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.value (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.value (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at c.performInitialMount (vendor.bundle.js?94c2cd9928607894dcfe:1)
    at c.mountComponent (vendor.bundle.js?94c2cd9928607894dcfe:1)
    at Object.mountComponent (vendor.bundle.js?94c2cd9928607894dcfe:1)
g @ app-main.bundle.js?94c2cd9928607894dcfe:5
t.getComputedSettings @ app-main.bundle.js?94c2cd9928607894dcfe:5
h @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_createInitialChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_createInitialChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_reconcilerUpdateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateDOMChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_reconcilerUpdateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateDOMChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateRenderedComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_performComponentUpdate @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateRenderedComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_performComponentUpdate @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performUpdateIfNecessary @ vendor.bundle.js?94c2cd9928607894dcfe:1
performUpdateIfNecessary @ vendor.bundle.js?94c2cd9928607894dcfe:1
b @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
M @ vendor.bundle.js?94c2cd9928607894dcfe:1
closeAll @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
batchedUpdates @ vendor.bundle.js?94c2cd9928607894dcfe:1
e @ vendor.bundle.js?94c2cd9928607894dcfe:1
a @ vendor.bundle.js?94c2cd9928607894dcfe:1
enqueueSetState @ vendor.bundle.js?94c2cd9928607894dcfe:1
s.setState @ vendor.bundle.js?94c2cd9928607894dcfe:1
n._updateSize @ app-main.bundle.js?94c2cd9928607894dcfe:5
(anonymous) @ app-main.bundle.js?94c2cd9928607894dcfe:5
Show 32 more frames
app-main.bundle.js?94c2cd9928607894dcfe:5 Error getting setting graph.x_axis._is_histogram TypeError: Cannot read property 'binning_info' of undefined
    at Object.getDefault (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at g (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.getComputedSettings (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at h (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at app-main.bundle.js?94c2cd9928607894dcfe:5
    at app-main.bundle.js?94c2cd9928607894dcfe:5
    at Array.map (<anonymous>)
    at Function.value (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.getVisualizationTransformed (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.value (app-main.bundle.js?94c2cd9928607894dcfe:5)
g @ app-main.bundle.js?94c2cd9928607894dcfe:5
t.getComputedSettings @ app-main.bundle.js?94c2cd9928607894dcfe:5
h @ app-main.bundle.js?94c2cd9928607894dcfe:5
(anonymous) @ app-main.bundle.js?94c2cd9928607894dcfe:5
(anonymous) @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
t.getVisualizationTransformed @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_createInitialChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_createInitialChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_reconcilerUpdateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateDOMChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_reconcilerUpdateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateDOMChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateRenderedComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_performComponentUpdate @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateRenderedComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_performComponentUpdate @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performUpdateIfNecessary @ vendor.bundle.js?94c2cd9928607894dcfe:1
performUpdateIfNecessary @ vendor.bundle.js?94c2cd9928607894dcfe:1
b @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
M @ vendor.bundle.js?94c2cd9928607894dcfe:1
closeAll @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
batchedUpdates @ vendor.bundle.js?94c2cd9928607894dcfe:1
e @ vendor.bundle.js?94c2cd9928607894dcfe:1
a @ vendor.bundle.js?94c2cd9928607894dcfe:1
enqueueSetState @ vendor.bundle.js?94c2cd9928607894dcfe:1
s.setState @ vendor.bundle.js?94c2cd9928607894dcfe:1
n._updateSize @ app-main.bundle.js?94c2cd9928607894dcfe:5
(anonymous) @ app-main.bundle.js?94c2cd9928607894dcfe:5
Show 36 more frames
app-main.bundle.js?94c2cd9928607894dcfe:5 Error getting setting graph.x_axis.title_text TypeError: Cannot read property 'name' of undefined
    at t.getFriendlyName (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at Object.getDefault (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at g (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.getComputedSettings (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at h (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at app-main.bundle.js?94c2cd9928607894dcfe:5
    at app-main.bundle.js?94c2cd9928607894dcfe:5
    at Array.map (<anonymous>)
    at Function.value (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.getVisualizationTransformed (app-main.bundle.js?94c2cd9928607894dcfe:5)
g @ app-main.bundle.js?94c2cd9928607894dcfe:5
t.getComputedSettings @ app-main.bundle.js?94c2cd9928607894dcfe:5
h @ app-main.bundle.js?94c2cd9928607894dcfe:5
(anonymous) @ app-main.bundle.js?94c2cd9928607894dcfe:5
(anonymous) @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
t.getVisualizationTransformed @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_createInitialChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_createInitialChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_reconcilerUpdateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateDOMChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_reconcilerUpdateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateDOMChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateRenderedComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_performComponentUpdate @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateRenderedComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_performComponentUpdate @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performUpdateIfNecessary @ vendor.bundle.js?94c2cd9928607894dcfe:1
performUpdateIfNecessary @ vendor.bundle.js?94c2cd9928607894dcfe:1
b @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
M @ vendor.bundle.js?94c2cd9928607894dcfe:1
closeAll @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
batchedUpdates @ vendor.bundle.js?94c2cd9928607894dcfe:1
e @ vendor.bundle.js?94c2cd9928607894dcfe:1
a @ vendor.bundle.js?94c2cd9928607894dcfe:1
enqueueSetState @ vendor.bundle.js?94c2cd9928607894dcfe:1
s.setState @ vendor.bundle.js?94c2cd9928607894dcfe:1
n._updateSize @ app-main.bundle.js?94c2cd9928607894dcfe:5
(anonymous) @ app-main.bundle.js?94c2cd9928607894dcfe:5
Show 36 more frames
app-main.bundle.js?94c2cd9928607894dcfe:5 Error getting setting graph.x_axis._is_histogram TypeError: Cannot read property 'binning_info' of undefined
    at Object.getDefault (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at g (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.getComputedSettings (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at h (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.value (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.value (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at c.performInitialMount (vendor.bundle.js?94c2cd9928607894dcfe:1)
    at c.mountComponent (vendor.bundle.js?94c2cd9928607894dcfe:1)
    at Object.mountComponent (vendor.bundle.js?94c2cd9928607894dcfe:1)
    at c.performInitialMount (vendor.bundle.js?94c2cd9928607894dcfe:1)
g @ app-main.bundle.js?94c2cd9928607894dcfe:5
t.getComputedSettings @ app-main.bundle.js?94c2cd9928607894dcfe:5
h @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_createInitialChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_createInitialChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_reconcilerUpdateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateDOMChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_reconcilerUpdateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateDOMChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateRenderedComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_performComponentUpdate @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateRenderedComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_performComponentUpdate @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performUpdateIfNecessary @ vendor.bundle.js?94c2cd9928607894dcfe:1
performUpdateIfNecessary @ vendor.bundle.js?94c2cd9928607894dcfe:1
b @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
M @ vendor.bundle.js?94c2cd9928607894dcfe:1
closeAll @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
batchedUpdates @ vendor.bundle.js?94c2cd9928607894dcfe:1
e @ vendor.bundle.js?94c2cd9928607894dcfe:1
a @ vendor.bundle.js?94c2cd9928607894dcfe:1
enqueueSetState @ vendor.bundle.js?94c2cd9928607894dcfe:1
s.setState @ vendor.bundle.js?94c2cd9928607894dcfe:1
n._updateSize @ app-main.bundle.js?94c2cd9928607894dcfe:5
(anonymous) @ app-main.bundle.js?94c2cd9928607894dcfe:5
Show 32 more frames
app-main.bundle.js?94c2cd9928607894dcfe:5 Error getting setting graph.x_axis.title_text TypeError: Cannot read property 'name' of undefined
    at t.getFriendlyName (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at Object.getDefault (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at g (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.getComputedSettings (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at h (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.value (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.value (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at c.performInitialMount (vendor.bundle.js?94c2cd9928607894dcfe:1)
    at c.mountComponent (vendor.bundle.js?94c2cd9928607894dcfe:1)
    at Object.mountComponent (vendor.bundle.js?94c2cd9928607894dcfe:1)
g @ app-main.bundle.js?94c2cd9928607894dcfe:5
t.getComputedSettings @ app-main.bundle.js?94c2cd9928607894dcfe:5
h @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
value @ app-main.bundle.js?94c2cd9928607894dcfe:5
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_createInitialChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performInitialMount @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_createInitialChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
mountComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_reconcilerUpdateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateDOMChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_reconcilerUpdateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateDOMChildren @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateRenderedComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_performComponentUpdate @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
receiveComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_updateRenderedComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
_performComponentUpdate @ vendor.bundle.js?94c2cd9928607894dcfe:1
updateComponent @ vendor.bundle.js?94c2cd9928607894dcfe:1
performUpdateIfNecessary @ vendor.bundle.js?94c2cd9928607894dcfe:1
performUpdateIfNecessary @ vendor.bundle.js?94c2cd9928607894dcfe:1
b @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
M @ vendor.bundle.js?94c2cd9928607894dcfe:1
closeAll @ vendor.bundle.js?94c2cd9928607894dcfe:1
perform @ vendor.bundle.js?94c2cd9928607894dcfe:1
batchedUpdates @ vendor.bundle.js?94c2cd9928607894dcfe:1
e @ vendor.bundle.js?94c2cd9928607894dcfe:1
a @ vendor.bundle.js?94c2cd9928607894dcfe:1
enqueueSetState @ vendor.bundle.js?94c2cd9928607894dcfe:1
s.setState @ vendor.bundle.js?94c2cd9928607894dcfe:1
n._updateSize @ app-main.bundle.js?94c2cd9928607894dcfe:5
(anonymous) @ app-main.bundle.js?94c2cd9928607894dcfe:5
Show 32 more frames
6app-main.bundle.js?94c2cd9928607894dcfe:5 Error getting setting scalar.field TypeError: Cannot read property 'name' of undefined
    at Object.getDefault (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at g (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.getComputedSettings (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at h (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.value (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at t.value (app-main.bundle.js?94c2cd9928607894dcfe:5)
    at c.performInitialMount (vendor.bundle.js?94c2cd9928607894dcfe:1)
    at c.mountComponent (vendor.bundle.js?94c2cd9928607894dcfe:1)
    at Object.mountComponent (vendor.bundle.js?94c2cd9928607894dcfe:1)
    at c.performInitialMount (vendor.bundle.js?94c2cd9928607894dcfe:1)
log stacktraces 
[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:10-07:00 DEBUG metabase.middleware.log GET /api/automagic-dashboards/adhoc/eyJkYXRhYmFzZSI6MSwicXVlcnkiOnsic291cmNlLXRhYmxlIjoxLCJhZ2dyZWdhdGlvbiI6W1siY291bnQiXV0sImJyZWFrb3V0IjpbWyJkYXRldGltZS1maWVsZCIsWyJmaWVsZC1pZCIsMjVdLCJtb250aCJdLFsiam9pbmVkLWZpZWxkIiwiUHJvZHVjdCIsWyJmaWVsZC1pZCIsMTZdXV0sImpvaW5zIjpbeyJmaWVsZHMiOiJhbGwiLCJzb3VyY2UtdGFibGUiOjMsImNvbmRpdGlvbiI6WyI9IixbImZpZWxkLWlkIiwxMF0sWyJqb2luZWQtZmllbGQiLCJQcm9kdWN0IixbImZpZWxkLWlkIiwyXV1dLCJhbGlhcyI6IlByb2R1Y3QifV19LCJ0eXBlIjoicXVlcnkifQ==/cell/WyJhbmQiLFsiPSIsWyJkYXRldGltZS1maWVsZCIsWyJmaWVsZC1pZCIsMjVdLCJtb250aCJdLCIyMDE3LTExLTAxVDAwOjAwOjAwWiJdLFsiPSIsWyJqb2luZWQtZmllbGQiLCJQcm9kdWN0IixbImZpZWxkLWlkIiwxNl1dLCJXaWRnZXQiXV0= 200 824.4 ms (218 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (148 total active threads) Queries in flight: 0 (0 queued)
[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:12-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:10.860398Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["fk->" 5 33]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PEOPLE__via__USER_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:12-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.7 s (10 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (123 total active threads) Queries in flight: 10 (0 queued)
[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:12-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:10.917037Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["binning-strategy" ["fk->" 10 24] "default"]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PRODUCTS__via__PRODUCT_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:12-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.7 s (10 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (148 total active threads) Queries in flight: 9 (0 queued)
[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:12-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:10.899530Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["binning-strategy" ["fk->" 10 27] "default"]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PRODUCTS__via__PRODUCT_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:12-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.9 s (10 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (123 total active threads) Queries in flight: 10 (0 queued)
[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:12-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:10.993902Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["fk->" 5 6]],
:aggregation [["count"]],
:order-by [["desc" ["aggregation" 0]]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PEOPLE__via__USER_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:12-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.9 s (10 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (123 total active threads) Queries in flight: 8 (0 queued)
[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:12-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.075574Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["fk->" 10 12]],
:aggregation [["count"]],
:limit 5,
:order-by [["asc" ["aggregation" 0]]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PRODUCTS__via__PRODUCT_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:12-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.010102Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["fk->" 10 20]],
:aggregation [["count"]],
:limit 5,
:order-by [["desc" ["aggregation" 0]]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PRODUCTS__via__PRODUCT_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:12-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.042047Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["fk->" 5 11]],
:aggregation [["count"]],
:limit 5,
:order-by [["desc" ["aggregation" 0]]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PEOPLE__via__USER_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:12-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.9 s (10 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (148 total active threads) Queries in flight: 9 (0 queued)
[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:12-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.9 s (10 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (148 total active threads) Queries in flight: 8 (0 queued)
[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:12-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.9 s (10 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (148 total active threads) Queries in flight: 7 (0 queued)
[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:12-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.051177Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["fk->" 10 12]],
:aggregation [["count"]],
:limit 5,
:order-by [["desc" ["aggregation" 0]]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PRODUCTS__via__PRODUCT_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:12-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.0 s (10 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (123 total active threads) Queries in flight: 8 (0 queued)
[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.059691Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["fk->" 10 20]],
:aggregation [["count"]],
:limit 5,
:order-by [["asc" ["aggregation" 0]]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PRODUCTS__via__PRODUCT_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.0 s (10 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (123 total active threads) Queries in flight: 7 (0 queued)
[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.179781Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]] ["is-null" ["fk->" 10 16]]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PRODUCTS__via__PRODUCT_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.192723Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:aggregation [["distinct" ["fk->" 10 16]]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PRODUCTS__via__PRODUCT_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.9 s (10 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (148 total active threads) Queries in flight: 6 (0 queued)
[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.107876Z[GMT]",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["fk->" 5 11]],
:aggregation [["count"]],
:limit 5,
:order-by [["asc" ["aggregation" 0]]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["--> query_processor.middleware.resolve_joins$check_join_aliases.invokeStatic(resolve_joins.clj:139)"
"query_processor.middleware.resolve_joins$check_join_aliases.invoke(resolve_joins.clj:133)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719$fn__46723.invoke(resolve_joins.clj:148)"
"query_processor.middleware.resolve_joins$fn__46714$resolve_joins_in_mbql_query__46719.invoke(resolve_joins.clj:142)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invokeStatic(resolve_joins.clj:165)"
"query_processor.middleware.resolve_joins$resolve_joins_in_mbql_query_all_levels.invoke(resolve_joins.clj:163)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invokeStatic(resolve_joins.clj:177)"
"query_processor.middleware.resolve_joins$resolve_joins_STAR_.invoke(resolve_joins.clj:175)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "Bad :joined-field clause: join with alias 'Product' does not exist. Found: #{\"PEOPLE__via__USER_ID\"}",
:row_count 0,
:running_time 0,
:preprocessed nil,
:data {:rows [], :cols []}}

[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.9 s (10 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (123 total active threads) Queries in flight: 5 (0 queued)
[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.0 s (10 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (123 total active threads) Queries in flight: 5 (0 queued)
[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:10.882912Z[GMT]",
:state "42S22",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["binning-strategy" ["field-id" 15092] "default"]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native
{:query
"SELECT ((floor(((\"PUBLIC\".\"ORDERS\".\"DISCOUNT\" - 0.0) / 10)) * 10) + 0.0) AS \"DISCOUNT\", count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) GROUP BY ((floor(((\"PUBLIC\".\"ORDERS\".\"DISCOUNT\" - 0.0) / 10)) * 10) + 0.0) ORDER BY ((floor(((\"PUBLIC\".\"ORDERS\".\"DISCOUNT\" - 0.0) / 10)) * 10) + 0.0) ASC",
:params (#t "2017-11-01T00:00Z[UTC]" #t "2017-12-01T00:00Z[UTC]" "Widget")},
:status :failed,
:class org.h2.jdbc.JdbcSQLException,
:stacktrace
["org.h2.message.DbException.getJdbcSQLException(DbException.java:357)"
"org.h2.message.DbException.get(DbException.java:179)"
"org.h2.message.DbException.get(DbException.java:155)"
"org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:150)"
"org.h2.expression.Comparison.optimize(Comparison.java:177)"
"org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:131)"
"org.h2.command.dml.Select.prepare(Select.java:861)"
"org.h2.command.Parser.prepareCommand(Parser.java:283)"
"org.h2.engine.Session.prepareLocal(Session.java:611)"
"org.h2.engine.Session.prepareCommand(Session.java:549)"
"org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)"
"org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)"
"org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1135)"
"com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)"
"--> driver.sql_jdbc.execute$fn__72458.invokeStatic(execute.clj:239)"
"driver.sql_jdbc.execute$fn__72458.invoke(execute.clj:237)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:257)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:254)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)"
"driver.sql_jdbc$fn__73846.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73846.invoke(sql_jdbc.clj:47)"
"driver.h2$fn__72665.invokeStatic(h2.clj:82)"
"driver.h2$fn__72665.invoke(h2.clj:79)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:69)"
"query_processor.context.default$default_runf.invoke(default.clj:67)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__45532.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__44834.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45697.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47225.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__43455.invoke(annotate.clj:574)"
"query_processor.middleware.permissions$check_query_permissions$fn__44709.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46215.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44907.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error
"Column \"Product.CATEGORY\" not found; SQL statement:\n-- Metabase:: userID: 48 queryType: MBQL queryHash: 34b6ff9d53dd0263c5b27be025dd4cd16fc8a969b900e1b229be5be0f1e44b75\nSELECT ((floor(((\"PUBLIC\".\"ORDERS\".\"DISCOUNT\" - 0.0) / 10)) * 10) + 0.0) AS \"DISCOUNT\", count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) GROUP BY ((floor(((\"PUBLIC\".\"ORDERS\".\"DISCOUNT\" - 0.0) / 10)) * 10) + 0.0) ORDER BY ((floor(((\"PUBLIC\".\"ORDERS\".\"DISCOUNT\" - 0.0) / 10)) * 10) + 0.0) ASC [42122-197]",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:database 1,
:query
{:source-table 1,
:filter
[:and
[:and
[:>= [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-11-01T00:00Z[UTC]" :default]]
[:< [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-12-01T00:00Z[UTC]" :default]]]
[:= [:joined-field "Product" [:field-id 16]] [:value "Widget" {:base_type :type/Text, :special_type :type/Category, :database_type "VARCHAR", :name "CATEGORY"}]]],
:breakout [[:binning-strategy [:field-id 15092] :num-bins nil {:min-value 0.0, :max-value 70.0, :num-bins 8, :bin-width 10}]],
:aggregation [[:aggregation-options [:count] {:name "count"}]],
:order-by [[:asc [:binning-strategy [:field-id 15092] :num-bins nil {:min-value 0.0, :max-value 70.0, :num-bins 8, :bin-width 10}]]]},
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 48,
:context :ad-hoc,
:nested? false,
:query-hash [52, -74, -1, -99, 83, -35, 2, 99, -59, -78, 123, -32, 37, -35, 76, -47, 111, -56, -87, 105, -71, 0, -31, -78, 41, -66, 91, -32, -15, -28, 75, 117]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:data {:rows [], :cols []}}

[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.8 s (7 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (148 total active threads) Queries in flight: 5 (0 queued)
[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:10.938170Z[GMT]",
:state "42S22",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["binning-strategy" ["field-id" 15] "default"]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native
{:query
"SELECT ((floor(((\"PUBLIC\".\"ORDERS\".\"SUBTOTAL\" - 0.0) / 20)) * 20) + 0.0) AS \"SUBTOTAL\", count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) GROUP BY ((floor(((\"PUBLIC\".\"ORDERS\".\"SUBTOTAL\" - 0.0) / 20)) * 20) + 0.0) ORDER BY ((floor(((\"PUBLIC\".\"ORDERS\".\"SUBTOTAL\" - 0.0) / 20)) * 20) + 0.0) ASC",
:params (#t "2017-11-01T00:00Z[UTC]" #t "2017-12-01T00:00Z[UTC]" "Widget")},
:status :failed,
:class org.h2.jdbc.JdbcSQLException,
:stacktrace
["org.h2.message.DbException.getJdbcSQLException(DbException.java:357)"
"org.h2.message.DbException.get(DbException.java:179)"
"org.h2.message.DbException.get(DbException.java:155)"
"org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:150)"
"org.h2.expression.Comparison.optimize(Comparison.java:177)"
"org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:131)"
"org.h2.command.dml.Select.prepare(Select.java:861)"
"org.h2.command.Parser.prepareCommand(Parser.java:283)"
"org.h2.engine.Session.prepareLocal(Session.java:611)"
"org.h2.engine.Session.prepareCommand(Session.java:549)"
"org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)"
"org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)"
"org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1135)"
"com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)"
"--> driver.sql_jdbc.execute$fn__72458.invokeStatic(execute.clj:239)"
"driver.sql_jdbc.execute$fn__72458.invoke(execute.clj:237)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:257)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:254)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)"
"driver.sql_jdbc$fn__73846.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73846.invoke(sql_jdbc.clj:47)"
"driver.h2$fn__72665.invokeStatic(h2.clj:82)"
"driver.h2$fn__72665.invoke(h2.clj:79)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:69)"
"query_processor.context.default$default_runf.invoke(default.clj:67)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__45532.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__44834.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45697.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47225.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__43455.invoke(annotate.clj:574)"
"query_processor.middleware.permissions$check_query_permissions$fn__44709.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46215.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44907.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error
"Column \"Product.CATEGORY\" not found; SQL statement:\n-- Metabase:: userID: 48 queryType: MBQL queryHash: 99b1c0c086dd9e1db1c9700a0951c2acdbf4f3c9b909c610e7f2577a386cb4ae\nSELECT ((floor(((\"PUBLIC\".\"ORDERS\".\"SUBTOTAL\" - 0.0) / 20)) * 20) + 0.0) AS \"SUBTOTAL\", count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) GROUP BY ((floor(((\"PUBLIC\".\"ORDERS\".\"SUBTOTAL\" - 0.0) / 20)) * 20) + 0.0) ORDER BY ((floor(((\"PUBLIC\".\"ORDERS\".\"SUBTOTAL\" - 0.0) / 20)) * 20) + 0.0) ASC [42122-197]",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:database 1,
:query
{:source-table 1,
:filter
[:and
[:and
[:>= [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-11-01T00:00Z[UTC]" :default]]
[:< [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-12-01T00:00Z[UTC]" :default]]]
[:= [:joined-field "Product" [:field-id 16]] [:value "Widget" {:base_type :type/Text, :special_type :type/Category, :database_type "VARCHAR", :name "CATEGORY"}]]],
:breakout [[:binning-strategy [:field-id 15] :num-bins nil {:min-value 0.0, :max-value 160.0, :num-bins 8, :bin-width 20}]],
:aggregation [[:aggregation-options [:count] {:name "count"}]],
:order-by [[:asc [:binning-strategy [:field-id 15] :num-bins nil {:min-value 0.0, :max-value 160.0, :num-bins 8, :bin-width 20}]]]},
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 48,
:context :ad-hoc,
:nested? false,
:query-hash [-103, -79, -64, -64, -122, -35, -98, 29, -79, -55, 112, 10, 9, 81, -62, -84, -37, -12, -13, -55, -71, 9, -58, 16, -25, -14, 87, 122, 56, 108, -76, -82]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:data {:rows [], :cols []}}

[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.8 s (7 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (123 total active threads) Queries in flight: 4 (0 queued)
[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.164300Z[GMT]",
:state "42S22",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native
{:query "SELECT count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?)",
:params (#t "2017-11-01T00:00Z[UTC]" #t "2017-12-01T00:00Z[UTC]" "Widget")},
:status :failed,
:class org.h2.jdbc.JdbcSQLException,
:stacktrace
["org.h2.message.DbException.getJdbcSQLException(DbException.java:357)"
"org.h2.message.DbException.get(DbException.java:179)"
"org.h2.message.DbException.get(DbException.java:155)"
"org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:150)"
"org.h2.expression.Comparison.optimize(Comparison.java:177)"
"org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:131)"
"org.h2.command.dml.Select.prepare(Select.java:861)"
"org.h2.command.Parser.prepareCommand(Parser.java:283)"
"org.h2.engine.Session.prepareLocal(Session.java:611)"
"org.h2.engine.Session.prepareCommand(Session.java:549)"
"org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)"
"org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)"
"org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1135)"
"com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)"
"--> driver.sql_jdbc.execute$fn__72458.invokeStatic(execute.clj:239)"
"driver.sql_jdbc.execute$fn__72458.invoke(execute.clj:237)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:257)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:254)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)"
"driver.sql_jdbc$fn__73846.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73846.invoke(sql_jdbc.clj:47)"
"driver.h2$fn__72665.invokeStatic(h2.clj:82)"
"driver.h2$fn__72665.invoke(h2.clj:79)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:69)"
"query_processor.context.default$default_runf.invoke(default.clj:67)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__45532.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__44834.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45697.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47225.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__43455.invoke(annotate.clj:574)"
"query_processor.middleware.permissions$check_query_permissions$fn__44709.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46215.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44907.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error
"Column \"Product.CATEGORY\" not found; SQL statement:\n-- Metabase:: userID: 48 queryType: MBQL queryHash: b0efc637121791e12b5665bd2118f928c15105044af40890a3d3199f99735a9f\nSELECT count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) [42122-197]",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:database 1,
:query
{:source-table 1,
:filter
[:and
[:and
[:>= [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-11-01T00:00Z[UTC]" :default]]
[:< [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-12-01T00:00Z[UTC]" :default]]]
[:= [:joined-field "Product" [:field-id 16]] [:value "Widget" {:base_type :type/Text, :special_type :type/Category, :database_type "VARCHAR", :name "CATEGORY"}]]],
:aggregation [[:aggregation-options [:count] {:name "count"}]]},
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 48,
:context :ad-hoc,
:nested? false,
:query-hash [-80, -17, -58, 55, 18, 23, -111, -31, 43, 86, 101, -67, 33, 24, -7, 40, -63, 81, 5, 4, 74, -12, 8, -112, -93, -45, 25, -97, -103, 115, 90, -97]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:data {:rows [], :cols []}}

[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.6 s (7 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (123 total active threads) Queries in flight: 3 (0 queued)
[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:10.967469Z[GMT]",
:state "42S22",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["binning-strategy" ["field-id" 18] "default"]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native
{:query
"SELECT ((floor(((\"PUBLIC\".\"ORDERS\".\"TAX\" - 0.0) / 2)) * 2) + 0.0) AS \"TAX\", count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) GROUP BY ((floor(((\"PUBLIC\".\"ORDERS\".\"TAX\" - 0.0) / 2)) * 2) + 0.0) ORDER BY ((floor(((\"PUBLIC\".\"ORDERS\".\"TAX\" - 0.0) / 2)) * 2) + 0.0) ASC",
:params (#t "2017-11-01T00:00Z[UTC]" #t "2017-12-01T00:00Z[UTC]" "Widget")},
:status :failed,
:class org.h2.jdbc.JdbcSQLException,
:stacktrace
["org.h2.message.DbException.getJdbcSQLException(DbException.java:357)"
"org.h2.message.DbException.get(DbException.java:179)"
"org.h2.message.DbException.get(DbException.java:155)"
"org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:150)"
"org.h2.expression.Comparison.optimize(Comparison.java:177)"
"org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:131)"
"org.h2.command.dml.Select.prepare(Select.java:861)"
"org.h2.command.Parser.prepareCommand(Parser.java:283)"
"org.h2.engine.Session.prepareLocal(Session.java:611)"
"org.h2.engine.Session.prepareCommand(Session.java:549)"
"org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)"
"org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)"
"org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1135)"
"com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)"
"--> driver.sql_jdbc.execute$fn__72458.invokeStatic(execute.clj:239)"
"driver.sql_jdbc.execute$fn__72458.invoke(execute.clj:237)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:257)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:254)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)"
"driver.sql_jdbc$fn__73846.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73846.invoke(sql_jdbc.clj:47)"
"driver.h2$fn__72665.invokeStatic(h2.clj:82)"
"driver.h2$fn__72665.invoke(h2.clj:79)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:69)"
"query_processor.context.default$default_runf.invoke(default.clj:67)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__45532.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__44834.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45697.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47225.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__43455.invoke(annotate.clj:574)"
"query_processor.middleware.permissions$check_query_permissions$fn__44709.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46215.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44907.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error
"Column \"Product.CATEGORY\" not found; SQL statement:\n-- Metabase:: userID: 48 queryType: MBQL queryHash: 968ea5940cb97e1cee2afd7dc48467e73281e918203ca9ad6115f042b8f16de0\nSELECT ((floor(((\"PUBLIC\".\"ORDERS\".\"TAX\" - 0.0) / 2)) * 2) + 0.0) AS \"TAX\", count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) GROUP BY ((floor(((\"PUBLIC\".\"ORDERS\".\"TAX\" - 0.0) / 2)) * 2) + 0.0) ORDER BY ((floor(((\"PUBLIC\".\"ORDERS\".\"TAX\" - 0.0) / 2)) * 2) + 0.0) ASC [42122-197]",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:database 1,
:query
{:source-table 1,
:filter
[:and
[:and
[:>= [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-11-01T00:00Z[UTC]" :default]]
[:< [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-12-01T00:00Z[UTC]" :default]]]
[:= [:joined-field "Product" [:field-id 16]] [:value "Widget" {:base_type :type/Text, :special_type :type/Category, :database_type "VARCHAR", :name "CATEGORY"}]]],
:breakout [[:binning-strategy [:field-id 18] :num-bins nil {:min-value 0.0, :max-value 12.0, :num-bins 8, :bin-width 2}]],
:aggregation [[:aggregation-options [:count] {:name "count"}]],
:order-by [[:asc [:binning-strategy [:field-id 18] :num-bins nil {:min-value 0.0, :max-value 12.0, :num-bins 8, :bin-width 2}]]]},
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 48,
:context :ad-hoc,
:nested? false,
:query-hash [-106, -114, -91, -108, 12, -71, 126, 28, -18, 42, -3, 125, -60, -124, 103, -25, 50, -127, -23, 24, 32, 60, -87, -83, 97, 21, -16, 66, -72, -15, 109, -32]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:data {:rows [], :cols []}}

[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.124814Z[GMT]",
:state "42S22",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter
["and"
["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]
["is-null" ["datetime-field" ["field-id" 25] "month"]]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native
{:query
"SELECT count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ? AND parsedatetime(formatdatetime(\"PUBLIC\".\"ORDERS\".\"CREATED_AT\", 'yyyyMM'), 'yyyyMM') IS NULL)",
:params (#t "2017-11-01T00:00Z[UTC]" #t "2017-12-01T00:00Z[UTC]" "Widget")},
:status :failed,
:class org.h2.jdbc.JdbcSQLException,
:stacktrace
["org.h2.message.DbException.getJdbcSQLException(DbException.java:357)"
"org.h2.message.DbException.get(DbException.java:179)"
"org.h2.message.DbException.get(DbException.java:155)"
"org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:150)"
"org.h2.expression.Comparison.optimize(Comparison.java:177)"
"org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:131)"
"org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:130)"
"org.h2.command.dml.Select.prepare(Select.java:861)"
"org.h2.command.Parser.prepareCommand(Parser.java:283)"
"org.h2.engine.Session.prepareLocal(Session.java:611)"
"org.h2.engine.Session.prepareCommand(Session.java:549)"
"org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)"
"org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)"
"org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1135)"
"com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)"
"--> driver.sql_jdbc.execute$fn__72458.invokeStatic(execute.clj:239)"
"driver.sql_jdbc.execute$fn__72458.invoke(execute.clj:237)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:257)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:254)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)"
"driver.sql_jdbc$fn__73846.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73846.invoke(sql_jdbc.clj:47)"
"driver.h2$fn__72665.invokeStatic(h2.clj:82)"
"driver.h2$fn__72665.invoke(h2.clj:79)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:69)"
"query_processor.context.default$default_runf.invoke(default.clj:67)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__45532.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__44834.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45697.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47225.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__43455.invoke(annotate.clj:574)"
"query_processor.middleware.permissions$check_query_permissions$fn__44709.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46215.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44907.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error
"Column \"Product.CATEGORY\" not found; SQL statement:\n-- Metabase:: userID: 48 queryType: MBQL queryHash: 2eaa460c086c4f4350b4863869bea83bb73716f61bc83377aa016cd683fb1ece\nSELECT count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ? AND parsedatetime(formatdatetime(\"PUBLIC\".\"ORDERS\".\"CREATED_AT\", 'yyyyMM'), 'yyyyMM') IS NULL) [42122-197]",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:database 1,
:query
{:source-table 1,
:filter
[:and
[:and
[:>= [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-11-01T00:00Z[UTC]" :default]]
[:< [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-12-01T00:00Z[UTC]" :default]]]
[:= [:joined-field "Product" [:field-id 16]] [:value "Widget" {:base_type :type/Text, :special_type :type/Category, :database_type "VARCHAR", :name "CATEGORY"}]]
[:= [:datetime-field [:field-id 25] :month] [:value nil {:base_type :type/DateTime, :special_type :type/CreationTimestamp, :database_type "TIMESTAMP", :name "CREATED_AT", :unit :month}]]],
:aggregation [[:aggregation-options [:count] {:name "count"}]]},
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 48,
:context :ad-hoc,
:nested? false,
:query-hash [46, -86, 70, 12, 8, 108, 79, 67, 80, -76, -122, 56, 105, -66, -88, 59, -73, 55, 22, -10, 27, -56, 51, 119, -86, 1, 108, -42, -125, -5, 30, -50]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:data {:rows [], :cols []}}

[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.6 s (7 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (123 total active threads) Queries in flight: 2 (0 queued)
[0041822f-21d8-47ba-9032-57f0d940044a] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.8 s (7 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (123 total active threads) Queries in flight: 1 (0 queued)
[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.139463Z[GMT]",
:state "42S22",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:aggregation [["distinct" ["datetime-field" ["field-id" 25] "month"]]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native
{:query
"SELECT count(distinct parsedatetime(formatdatetime(\"PUBLIC\".\"ORDERS\".\"CREATED_AT\", 'yyyyMM'), 'yyyyMM')) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?)",
:params (#t "2017-11-01T00:00Z[UTC]" #t "2017-12-01T00:00Z[UTC]" "Widget")},
:status :failed,
:class org.h2.jdbc.JdbcSQLException,
:stacktrace
["org.h2.message.DbException.getJdbcSQLException(DbException.java:357)"
"org.h2.message.DbException.get(DbException.java:179)"
"org.h2.message.DbException.get(DbException.java:155)"
"org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:150)"
"org.h2.expression.Comparison.optimize(Comparison.java:177)"
"org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:131)"
"org.h2.command.dml.Select.prepare(Select.java:861)"
"org.h2.command.Parser.prepareCommand(Parser.java:283)"
"org.h2.engine.Session.prepareLocal(Session.java:611)"
"org.h2.engine.Session.prepareCommand(Session.java:549)"
"org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)"
"org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)"
"org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1135)"
"com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)"
"--> driver.sql_jdbc.execute$fn__72458.invokeStatic(execute.clj:239)"
"driver.sql_jdbc.execute$fn__72458.invoke(execute.clj:237)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:257)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:254)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)"
"driver.sql_jdbc$fn__73846.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73846.invoke(sql_jdbc.clj:47)"
"driver.h2$fn__72665.invokeStatic(h2.clj:82)"
"driver.h2$fn__72665.invoke(h2.clj:79)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:69)"
"query_processor.context.default$default_runf.invoke(default.clj:67)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__45532.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__44834.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45697.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47225.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__43455.invoke(annotate.clj:574)"
"query_processor.middleware.permissions$check_query_permissions$fn__44709.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46215.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44907.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error
"Column \"Product.CATEGORY\" not found; SQL statement:\n-- Metabase:: userID: 48 queryType: MBQL queryHash: 2d9381c3612b0ef56cb7a4ac382a2966b68c11b39f7a034b317d04602875200c\nSELECT count(distinct parsedatetime(formatdatetime(\"PUBLIC\".\"ORDERS\".\"CREATED_AT\", 'yyyyMM'), 'yyyyMM')) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) [42122-197]",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:database 1,
:query
{:source-table 1,
:filter
[:and
[:and
[:>= [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-11-01T00:00Z[UTC]" :default]]
[:< [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-12-01T00:00Z[UTC]" :default]]]
[:= [:joined-field "Product" [:field-id 16]] [:value "Widget" {:base_type :type/Text, :special_type :type/Category, :database_type "VARCHAR", :name "CATEGORY"}]]],
:aggregation [[:aggregation-options [:distinct [:datetime-field [:field-id 25] :month]] {:name "count"}]]},
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 48,
:context :ad-hoc,
:nested? false,
:query-hash [45, -109, -127, -61, 97, 43, 14, -11, 108, -73, -92, -84, 56, 42, 41, 102, -74, -116, 17, -77, -97, 122, 3, 75, 49, 125, 4, 96, 40, 117, 32, 12]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:data {:rows [], :cols []}}

[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:10.981630Z[GMT]",
:state "42S22",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["binning-strategy" ["field-id" 15093] "default"]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native
{:query
"SELECT ((floor(((\"PUBLIC\".\"ORDERS\".\"QUANTITY\" - 0.0) / 12.5)) * 12.5) + 0.0) AS \"QUANTITY\", count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) GROUP BY ((floor(((\"PUBLIC\".\"ORDERS\".\"QUANTITY\" - 0.0) / 12.5)) * 12.5) + 0.0) ORDER BY ((floor(((\"PUBLIC\".\"ORDERS\".\"QUANTITY\" - 0.0) / 12.5)) * 12.5) + 0.0) ASC",
:params (#t "2017-11-01T00:00Z[UTC]" #t "2017-12-01T00:00Z[UTC]" "Widget")},
:status :failed,
:class org.h2.jdbc.JdbcSQLException,
:stacktrace
["org.h2.message.DbException.getJdbcSQLException(DbException.java:357)"
"org.h2.message.DbException.get(DbException.java:179)"
"org.h2.message.DbException.get(DbException.java:155)"
"org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:150)"
"org.h2.expression.Comparison.optimize(Comparison.java:177)"
"org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:131)"
"org.h2.command.dml.Select.prepare(Select.java:861)"
"org.h2.command.Parser.prepareCommand(Parser.java:283)"
"org.h2.engine.Session.prepareLocal(Session.java:611)"
"org.h2.engine.Session.prepareCommand(Session.java:549)"
"org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)"
"org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)"
"org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1135)"
"com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)"
"--> driver.sql_jdbc.execute$fn__72458.invokeStatic(execute.clj:239)"
"driver.sql_jdbc.execute$fn__72458.invoke(execute.clj:237)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:257)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:254)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)"
"driver.sql_jdbc$fn__73846.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73846.invoke(sql_jdbc.clj:47)"
"driver.h2$fn__72665.invokeStatic(h2.clj:82)"
"driver.h2$fn__72665.invoke(h2.clj:79)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:69)"
"query_processor.context.default$default_runf.invoke(default.clj:67)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__45532.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__44834.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45697.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47225.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__43455.invoke(annotate.clj:574)"
"query_processor.middleware.permissions$check_query_permissions$fn__44709.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46215.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44907.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error
"Column \"Product.CATEGORY\" not found; SQL statement:\n-- Metabase:: userID: 48 queryType: MBQL queryHash: c3665e3dafcf3617f1d8f3222eba4bff0ae4efbc8d7aca841c73c166b732ce33\nSELECT ((floor(((\"PUBLIC\".\"ORDERS\".\"QUANTITY\" - 0.0) / 12.5)) * 12.5) + 0.0) AS \"QUANTITY\", count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) GROUP BY ((floor(((\"PUBLIC\".\"ORDERS\".\"QUANTITY\" - 0.0) / 12.5)) * 12.5) + 0.0) ORDER BY ((floor(((\"PUBLIC\".\"ORDERS\".\"QUANTITY\" - 0.0) / 12.5)) * 12.5) + 0.0) ASC [42122-197]",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:database 1,
:query
{:source-table 1,
:filter
[:and
[:and
[:>= [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-11-01T00:00Z[UTC]" :default]]
[:< [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-12-01T00:00Z[UTC]" :default]]]
[:= [:joined-field "Product" [:field-id 16]] [:value "Widget" {:base_type :type/Text, :special_type :type/Category, :database_type "VARCHAR", :name "CATEGORY"}]]],
:breakout [[:binning-strategy [:field-id 15093] :num-bins nil {:min-value 0.0, :max-value 100.0, :num-bins 8, :bin-width 12.5}]],
:aggregation [[:aggregation-options [:count] {:name "count"}]],
:order-by [[:asc [:binning-strategy [:field-id 15093] :num-bins nil {:min-value 0.0, :max-value 100.0, :num-bins 8, :bin-width 12.5}]]]},
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 48,
:context :ad-hoc,
:nested? false,
:query-hash [-61, 102, 94, 61, -81, -49, 54, 23, -15, -40, -13, 34, 46, -70, 75, -1, 10, -28, -17, -68, -115, 122, -54, -124, 28, 115, -63, 102, -73, 50, -50, 51]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:data {:rows [], :cols []}}

[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:11.121497Z[GMT]",
:state "42S22",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native
{:query "SELECT count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?)",
:params (#t "2017-11-01T00:00Z[UTC]" #t "2017-12-01T00:00Z[UTC]" "Widget")},
:status :failed,
:class org.h2.jdbc.JdbcSQLException,
:stacktrace
["org.h2.message.DbException.getJdbcSQLException(DbException.java:357)"
"org.h2.message.DbException.get(DbException.java:179)"
"org.h2.message.DbException.get(DbException.java:155)"
"org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:150)"
"org.h2.expression.Comparison.optimize(Comparison.java:177)"
"org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:131)"
"org.h2.command.dml.Select.prepare(Select.java:861)"
"org.h2.command.Parser.prepareCommand(Parser.java:283)"
"org.h2.engine.Session.prepareLocal(Session.java:611)"
"org.h2.engine.Session.prepareCommand(Session.java:549)"
"org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)"
"org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)"
"org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1135)"
"com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)"
"--> driver.sql_jdbc.execute$fn__72458.invokeStatic(execute.clj:239)"
"driver.sql_jdbc.execute$fn__72458.invoke(execute.clj:237)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:257)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:254)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)"
"driver.sql_jdbc$fn__73846.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73846.invoke(sql_jdbc.clj:47)"
"driver.h2$fn__72665.invokeStatic(h2.clj:82)"
"driver.h2$fn__72665.invoke(h2.clj:79)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:69)"
"query_processor.context.default$default_runf.invoke(default.clj:67)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__45532.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__44834.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45697.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47225.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__43455.invoke(annotate.clj:574)"
"query_processor.middleware.permissions$check_query_permissions$fn__44709.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46215.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44907.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error
"Column \"Product.CATEGORY\" not found; SQL statement:\n-- Metabase:: userID: 48 queryType: MBQL queryHash: b0efc637121791e12b5665bd2118f928c15105044af40890a3d3199f99735a9f\nSELECT count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) [42122-197]",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:database 1,
:query
{:source-table 1,
:filter
[:and
[:and
[:>= [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-11-01T00:00Z[UTC]" :default]]
[:< [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-12-01T00:00Z[UTC]" :default]]]
[:= [:joined-field "Product" [:field-id 16]] [:value "Widget" {:base_type :type/Text, :special_type :type/Category, :database_type "VARCHAR", :name "CATEGORY"}]]],
:aggregation [[:aggregation-options [:count] {:name "count"}]]},
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 48,
:context :ad-hoc,
:nested? false,
:query-hash [-80, -17, -58, 55, 18, 23, -111, -31, 43, 86, 101, -67, 33, 24, -7, 40, -63, 81, 5, 4, 74, -12, 8, -112, -93, -45, 25, -97, -103, 115, 90, -97]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:data {:rows [], :cols []}}

[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.8 s (7 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (148 total active threads) Queries in flight: 4 (0 queued)
[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.7 s (7 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (148 total active threads) Queries in flight: 3 (0 queued)
[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.7 s (7 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (148 total active threads) Queries in flight: 2 (0 queued)
[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 1,
:started_at #t "2020-08-13T22:00:10.958290Z[GMT]",
:state "42S22",
:json_query
{:type "query",
:database 1,
:query
{:source-table 1,
:filter ["and" ["and" ["=" ["datetime-field" ["field-id" 25] "month"] "2017-11-01T00:00:00Z"] ["=" ["joined-field" "Product" ["field-id" 16]] "Widget"]]],
:breakout [["binning-strategy" ["field-id" 23] "default"]],
:aggregation [["count"]]},
:parameters [],
:middleware {:add-default-userland-constraints? true}},
:native
{:query
"SELECT ((floor(((\"PUBLIC\".\"ORDERS\".\"TOTAL\" - 0.0) / 30)) * 30) + 0.0) AS \"TOTAL\", count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) GROUP BY ((floor(((\"PUBLIC\".\"ORDERS\".\"TOTAL\" - 0.0) / 30)) * 30) + 0.0) ORDER BY ((floor(((\"PUBLIC\".\"ORDERS\".\"TOTAL\" - 0.0) / 30)) * 30) + 0.0) ASC",
:params (#t "2017-11-01T00:00Z[UTC]" #t "2017-12-01T00:00Z[UTC]" "Widget")},
:status :failed,
:class org.h2.jdbc.JdbcSQLException,
:stacktrace
["org.h2.message.DbException.getJdbcSQLException(DbException.java:357)"
"org.h2.message.DbException.get(DbException.java:179)"
"org.h2.message.DbException.get(DbException.java:155)"
"org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:150)"
"org.h2.expression.Comparison.optimize(Comparison.java:177)"
"org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:131)"
"org.h2.command.dml.Select.prepare(Select.java:861)"
"org.h2.command.Parser.prepareCommand(Parser.java:283)"
"org.h2.engine.Session.prepareLocal(Session.java:611)"
"org.h2.engine.Session.prepareCommand(Session.java:549)"
"org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)"
"org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)"
"org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1135)"
"com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)"
"--> driver.sql_jdbc.execute$fn__72458.invokeStatic(execute.clj:239)"
"driver.sql_jdbc.execute$fn__72458.invoke(execute.clj:237)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:257)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:254)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)"
"driver.sql_jdbc$fn__73846.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73846.invoke(sql_jdbc.clj:47)"
"driver.h2$fn__72665.invokeStatic(h2.clj:82)"
"driver.h2$fn__72665.invoke(h2.clj:79)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:69)"
"query_processor.context.default$default_runf.invoke(default.clj:67)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__45532.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__44834.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45697.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47225.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__43455.invoke(annotate.clj:574)"
"query_processor.middleware.permissions$check_query_permissions$fn__44709.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46215.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44907.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error
"Column \"Product.CATEGORY\" not found; SQL statement:\n-- Metabase:: userID: 48 queryType: MBQL queryHash: f18b13ba88158142554c8250b078a27edefe595140217628e027a0705c8847f8\nSELECT ((floor(((\"PUBLIC\".\"ORDERS\".\"TOTAL\" - 0.0) / 30)) * 30) + 0.0) AS \"TOTAL\", count(*) AS \"count\" FROM \"PUBLIC\".\"ORDERS\" WHERE ((\"PUBLIC\".\"ORDERS\".\"CREATED_AT\" >= ? AND \"PUBLIC\".\"ORDERS\".\"CREATED_AT\" < ?) AND \"Product\".\"CATEGORY\" = ?) GROUP BY ((floor(((\"PUBLIC\".\"ORDERS\".\"TOTAL\" - 0.0) / 30)) * 30) + 0.0) ORDER BY ((floor(((\"PUBLIC\".\"ORDERS\".\"TOTAL\" - 0.0) / 30)) * 30) + 0.0) ASC [42122-197]",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:database 1,
:query
{:source-table 1,
:filter
[:and
[:and
[:>= [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-11-01T00:00Z[UTC]" :default]]
[:< [:datetime-field [:field-id 25] :default] [:absolute-datetime #t "2017-12-01T00:00Z[UTC]" :default]]]
[:= [:joined-field "Product" [:field-id 16]] [:value "Widget" {:base_type :type/Text, :special_type :type/Category, :database_type "VARCHAR", :name "CATEGORY"}]]],
:breakout [[:binning-strategy [:field-id 23] :num-bins nil {:min-value 0.0, :max-value 240.0, :num-bins 8, :bin-width 30}]],
:aggregation [[:aggregation-options [:count] {:name "count"}]],
:order-by [[:asc [:binning-strategy [:field-id 23] :num-bins nil {:min-value 0.0, :max-value 240.0, :num-bins 8, :bin-width 30}]]]},
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 48,
:context :ad-hoc,
:nested? false,
:query-hash [-15, -117, 19, -70, -120, 21, -127, 66, 85, 76, -126, 80, -80, 120, -94, 126, -34, -2, 89, 81, 64, 33, 118, 40, -32, 39, -96, 112, 92, -120, 71, -8]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:data {:rows [], :cols []}}

[19c8c714-e7b4-4291-ab1c-fa1b7a19111f] 2020-08-13T15:00:13-07:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 2.9 s (7 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (148 total active threads) Queries in flight: 1 (0 queued)

To Reproduce
Steps to reproduce the behavior:

  1. Create a question using the notebook editor.
  2. Add an explicit join.
  3. X-ray the data.
  4. See the screenshot of the notebook editor below for the specific question used to produce the error.

Expected behavior
X-rays should work with both implicit and explicit joins in the notebook editor.

Screenshots
Question with explicit join:
question-with-explicit-join

Problem loading chart.
problem-loading-chart

Severity
How severe an issue is this bug to you? Is this annoying, blocking some users, blocking an upgrade or blocking your usage of Metabase entirely?
Note: the more honest and specific you are here the more we will take you seriously.

Additional context
Add any other context about the problem here.

Metabase Diagnostic Info

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.105 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.8+10",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.8",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.8+10",
    "os.name": "Linux",
    "os.version": "4.14.186-110.268.amzn1.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "googleanalytics",
      "mysql",
      "druid",
      "postgres",
      "bigquery",
      "redshift",
      "mongo",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "9.6.11"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.8"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2020-08-13",
      "tag": "v0.37.0-snapshot",
      "branch": "master",
      "hash": "81e1e87"
    },
    "settings": {
      "report-timezone": "US/Pacific"
    }
  }
}
@flamber flamber added Priority:P2 Average run of the mill bug Querying/Notebook Items specific to the Custom/Notebook query builder Querying/X-rays and removed .Needs Triage labels Aug 14, 2020
@flamber
Copy link
Contributor

flamber commented Aug 14, 2020 •
edited

Perhaps related to #12839/#12762/#12507, but this is only an issue for explicit joins - implicit joins works.

@flamber flamber mentioned this issue Oct 20, 2020
Closed
@nemanjaglumac nemanjaglumac added this to Backlog in Cypress Testing Dec 10, 2020
nemanjaglumac added a commit that referenced this issue Dec 10, 2020
@nemanjaglumac
Add repro for #13112 [ci skip]
08fc0b8
@nemanjaglumac nemanjaglumac mentioned this issue Dec 10, 2020
Merged
nemanjaglumac added a commit that referenced this issue Dec 11, 2020
@nemanjaglumac
#13112 Repro: X-rays should work on questions with explicit joins (#1…
bc08ac2 
…4043) [ci skip]

* Run each test in isolation

* Add timeout to XHR wait [ci skip]
_X-rays take a long time to finish. We had to extend the default timeout for `cy.wait()` in order to prevent failures in CI due to the timeout._
@nemanjaglumac nemanjaglumac added the .Reproduced Issues reproduced in test (usually Cypress) label Dec 14, 2020
@flamber flamber mentioned this issue Feb 12, 2021
Closed
@flamber
Copy link
Contributor

flamber commented Nov 14, 2021

I cannot reproduce on 0.41.2
image

@flamber flamber closed this as completed Nov 14, 2021
@diogormendes diogormendes mentioned this issue Apr 6, 2022
Open
26 tasks
@flamber flamber mentioned this issue Sep 10, 2022
Closed
@nemanjaglumac nemanjaglumac removed this from Backlog in Cypress Testing Dec 29, 2022
@deploysentinel deploysentinel bot mentioned this issue Jul 14, 2023
Closed
@deploysentinel deploysentinel bot mentioned this issue Jul 27, 2023
Merged
@deploysentinel deploysentinel bot mentioned this issue Aug 8, 2023
Merged
1 task
This was referenced Aug 17, 2023
Merged
Merged
This was referenced Aug 28, 2023
Merged
Closed
Merged
This was referenced Sep 18, 2023
Merged
Merged
This was referenced Apr 30, 2024
Merged
Merged
Merged
Merged
Merged
Merged
Merged
Merged
Merged
Merged
Merged
Merged
Merged
Merged
Merged
Merged
Closed
Merged
Merged
This was referenced May 7, 2024
Merged
Merged
Merged
Closed
Merged
Merged
Merged
Merged
Merged
Merged
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Priority:P2 Average run of the mill bug Querying/Notebook Items specific to the Custom/Notebook query builder Querying/X-rays .Reproduced Issues reproduced in test (usually Cypress) Type:Bug Product defects
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@flamber @jeff-bruemmer @nemanjaglumac