Error Occured

struct
column4
datasourceHUGEDOMAINSHITS
detailDatabase reported: Table 'hugedomainshits.hits_monthly_201610' doesn't exist
errorcodeerrorCode.sqlError
extendedinfo[empty string]
line576
messageGeneral SQL Error
nativeerrorcode1146
queryErrorTable 'hugedomainshits.hits_monthly_201610' doesn't exist
sql( select prod_id, dt.dateTableDate as hit_date, hit_profile, hit_cart from common.dateTable dt left join hits_monthly_201610 h on ( (dt.dateTableDate = h.hit_date) and (prod_id = 4928944) and (dt.dateTableDate >= '2016-10-01') and (dt.dateTableDate < '2016-10-01') ) where (dt.dateTableDate >= '2016-10-01') and (dt.dateTableDate < '2016-10-01') ) UNION ( select prod_id, dt.dateTableDate as hit_date, hit_profile, hit_cart from common.dateTable dt left join hits_monthly_201609 h on ( (dt.dateTableDate = h.hit_date) and (prod_id = 4928944) and (dt.dateTableDate >= '2016-09-01') and (dt.dateTableDate < '2016-10-01') ) where (dt.dateTableDate >= '2016-09-01') and (dt.dateTableDate < '2016-10-01') ) order by hit_date
sqlstate42S02
tagcontext
array
1
struct
column4
idCFQUERY
line576
templateD

Please note we have encountered an error number DBGOTPUTERR.


Please contact HugeDomains at 1-303-893-0552 or through domains@hugedomains.com. Thank you.