-
-
esen_4QBPI1VXAV 初学数据Lv2
发表于2024-10-23 16:03
悬赏6
未解决
楼主
计算浮动表元 GRID35->A2 (MK_DAYMTBA.HostName)时出错：com.esen.jdbc.pool.impl.mssql.MssqlPooledSQLException: Invalid object name 'MK_Header'.
创建主题表时测试通过，可以正常计算出数据，但是在数据分析计算中报以上错误。
完整主题表sql如下：
select
D.DateTime,
D.ErrCou,
D.RunTime,
D.Utilisation,
h. *
from
MK_Header h
left join (
select
MD. *,
isnull(AC.ALCou, 0) ErrCou
from
(
select
DateTime,
RunTime,
Utilisation,
HostName
from
MK_MTBADay
) MD
left join (
select
CAST(al.StartTime as date) DateTime,
HostName,
count(0) ALCou
from
(
select
StartTime,
Describe,
HostName
from
MK_DataAlarm
where
Describe NOT IN (
select
BlackListItem
from
MK_BlackListTable
)
and Describe NOT IN (
SELECT
ProductItem
FROM
MK_ProductBlackList
)
and SimAlarms > 0
) al
group by
CAST(al.StartTime as date),
HostName
) AC on MD.DateTime = AC.DateTime
AND MD.HostName = AC.HostName
) D on h.HostName = D.HostName
where
D.DateTime is not null
以上sql创建出了一张sql主题表。但是创建分析表是，
运行报错“计算浮动表元 GRID35->A2 (MK_DAYMTBA.HostName)时出错：com.esen.jdbc.pool.impl.mssql.MssqlPooledSQLException: Invalid object name 'MK_Header'.”
创建主题表时测试通过，可以正常计算出数据，但是在数据分析计算中报以上错误。
完整主题表sql如下：
select
D.DateTime,
D.ErrCou,
D.RunTime,
D.Utilisation,
h. *
from
MK_Header h
left join (
select
MD. *,
isnull(AC.ALCou, 0) ErrCou
from
(
select
DateTime,
RunTime,
Utilisation,
HostName
from
MK_MTBADay
) MD
left join (
select
CAST(al.StartTime as date) DateTime,
HostName,
count(0) ALCou
from
(
select
StartTime,
Describe,
HostName
from
MK_DataAlarm
where
Describe NOT IN (
select
BlackListItem
from
MK_BlackListTable
)
and Describe NOT IN (
SELECT
ProductItem
FROM
MK_ProductBlackList
)
and SimAlarms > 0
) al
group by
CAST(al.StartTime as date),
HostName
) AC on MD.DateTime = AC.DateTime
AND MD.HostName = AC.HostName
) D on h.HostName = D.HostName
where
D.DateTime is not null
以上sql创建出了一张sql主题表。但是创建分析表是，
运行报错“计算浮动表元 GRID35->A2 (MK_DAYMTBA.HostName)时出错：com.esen.jdbc.pool.impl.mssql.MssqlPooledSQLException: Invalid object name 'MK_Header'.”
