PGS-220000 PostgreSQL错误:关系“t1”不存在
如果您收到错误: PGS-220000 PostgreSQL error: relation "t1" does not exist...,
由Adobe Campaign Classic v7中的跟踪工作流生成,请参阅本文以了解如何解决此问题。
描述 description
环境
Campaign ClassicV7
问题/症状
在最近的内部版本升级9343或更高版本后,跟踪工作流会生成以下错误:
nlmodule PGS-220000 PostgreSQL error: ERROR: relation "t1" does not exist LINE 1: ...t, T3.iArticle, T2.iType FROM NmsTrackingUrl T2, T1 LEFT OU... nlmodule WDB-200001 SQL statement 'SELECT T1.tsLog, T1.iDeliveryId, T1.iUrlId, T1.sSourceType, T3.dAmount, T3.iArticle, T2.iType FROM NmsTrackingUrl T2, T1 LEFT OUTER JOIN NmsWebTrackingLog T3 ON iTrackingLogId = iWebTrackingLogId WHERE T1.tsLog < :#(1)# AND T1.tsLog >= :#(2)# AND T1.iUrlId=T2.iTrackingUrlId ORDER BY T1.tsLog' could not be executed. Param(0)=09/17/2020 8:55:00 PM Param(1)=09/16/2020 8:55:00 PMnlmodule Attribute 'broadLog-id' unknown (see definition of schema 'Tracking logs (nms:trackingLog)').
解决方法 resolution
从详细的跟踪日志中,您可以看到跟踪工作流在整合数据方面最后出现了故障:
00000000 00000000 1 info log Consolidating tracking logs for the period [ 09/16/2020 3:55:00 PM, 09/17/2020 3:55:00 PM[ ...00000000 00000000 1 info wdbc Select: [ 00000000 ] SELECT T1.tsLog, T1.iDeliveryId, T1.iUrlId, T1.sSourceType, T3.dAmount, T3.iArticle, T2.iType FROM NmsTrackingUrl T2, T1 LEFT OUTER JOIN NmsWebTrackingLog T3 ON iTrackingLogId = iWebTrackingLogId WHERE T1.tsLog < :#(1)# AND T1.tsLog >= :#(2)# AND T1.iUrlId=T2.iTrackingUrlId ORDER BY T1.tsLog00000000 00000000 2 info wdbc Param(0)=09/17/2020 8:55:00 PM00000000 00000000 2 info wdbc Param(1)=09/16/2020 8:55:00 PM00000000 00000000 1 error log PGS-220000 PostgreSQL error: ERROR: relation "t1" does not exist\nLINE 1: ...t, T3.iArticle, T2.iType FROM NmsTrackingUrl T2, T1 LEFT OU...\n \n. (iRc=-2006)00000000 00000000 1 error log WDB-200001 SQL statement 'SELECT T1.tsLog, T1.iDeliveryId, T1.iUrlId, T1.sSourceType, T3.dAmount, T3.iArticle, T2.iType FROM NmsTrackingUrl T2, T1 LEFT OUTER JOIN NmsWebTrackingLog T3 ON iTrackingLogId = iWebTrackingLogId WHERE T1.tsLog < :#(1)# AND T1.tsLog >= :#(2)# AND T1.iUrlId=T2.iTrackingUrlId ORDER BY T1.tsLog' could not be executed.\n Param(0)=09/17/2020 8:55:00 PM\n Param(1)=09/16/2020 8:55:00 PM (iRc=-2006)
每次跟踪工作流启动时,它都会提取所有目标映射,并根据配置更新数据。
在这种情况下,一个目标映射导致了问题。 请参阅下文:
基本上, NMS:跟踪日志 架构不应用于监视日志,因为该架构与数据库(SQL)表无关。
总之,问题与升级无关,而是与错误的目标映射配置有关。
recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f