We have a dashboard we reload and distribute via Qlikview publisher. The dashboard has been publishing with no errors for quite some time and no changes have been made lately. Recently we have started receiving the field not found error. We rerun the publisher task a bit later with no changes to the dashboard and the dashboard reloads fine. Here are a couple of days results from our logs which show the error. Note I did not include a successful log just to save some space.
Location of the failure is somewhat variable as well as illustrated in the two days of logs below. Any suggestions would be appreciated. We are on version 11.0.11282.0.
Day 1 log
3/25/2014 6:30:01 AM: Execution started.
3/25/2014 6:30:01 AM: QlikView Version:11.00.11282.0
3/25/2014 6:30:01 AM: CPU Target x64
3/25/2014 6:30:01 AM: Operating System Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)
3/25/2014 6:30:01 AM: Wow64 mode Not using Wow64
3/25/2014 6:30:01 AM: MDAC Version 6.1.7601.17514
3/25/2014 6:30:01 AM: MDAC Full Install Version 6.1.7601.17514
3/25/2014 6:30:01 AM: PreferredCompression 2
3/25/2014 6:30:01 AM: EnableParallelReload 1
3/25/2014 6:30:01 AM: ParallelizeQvdLoads 1
3/25/2014 6:30:01 AM: AutoSaveAfterReload 0
3/25/2014 6:30:01 AM: BackupBeforeReload 0
3/25/2014 6:30:01 AM: EnableFlushLog 0
3/25/2014 6:30:01 AM: SaveInfoWhenSavingFile 0
3/25/2014 6:30:01 AM: UserLogfileCharset 0
3/25/2014 6:30:01 AM: OdbcLoginTimeout -1
3/25/2014 6:30:01 AM: OdbcConnectionTimeout -1
3/25/2014 6:30:01 AM: ScriptWantsDbWrite false
3/25/2014 6:30:01 AM: ScriptWantsExe false
3/25/2014 6:30:01 AM: LogFile CodePage Used: 1252
3/25/2014 6:30:02 AM: 0002 SET ThousandSep=','
3/25/2014 6:30:02 AM: 0003 SET DecimalSep='.'
3/25/2014 6:30:02 AM: 0004 SET MoneyThousandSep=','
3/25/2014 6:30:02 AM: 0005 SET MoneyDecimalSep='.'
3/25/2014 6:30:02 AM: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'
3/25/2014 6:30:02 AM: 0007 SET TimeFormat='h:mm:ss TT'
3/25/2014 6:30:02 AM: 0008 SET DateFormat='M/D/YYYY'
3/25/2014 6:30:02 AM: 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'
3/25/2014 6:30:02 AM: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
3/25/2014 6:30:02 AM: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
3/25/2014 6:30:02 AM: 0022 BarBchTransactions:
3/25/2014 6:30:02 AM: 0023 LOAD
3/25/2014 6:30:02 AM: 0024 FactBarBchTransactionBatchID,
3/25/2014 6:30:02 AM: 0025 FactBarBchTransactionTxnNumberID,
3/25/2014 6:30:02 AM: 0026 FactBarBchTransactionItemSeqID,
3/25/2014 6:30:02 AM: 0027 FactBarBchTransactionAmount,
3/25/2014 6:30:02 AM: 0028 Date(FactBarBchTransactionServiceDateTime,'MM/DD/YYYY') as [Bar Bch Trans DOS],
3/25/2014 6:30:02 AM: 0029 FactBarBchTransactionBarProcedureDescription as [Bar Bch Proc Desc],
3/25/2014 6:30:02 AM: 0030 FactBarBchTransactionBarProcedureType,
3/25/2014 6:30:02 AM: 0031 FactBarBchTransactionBarTransDesc,
3/25/2014 6:30:02 AM: 0032 FactBarBchTransactionBarTransType,
3/25/2014 6:30:02 AM: 0033 FactBarBchTransactionDimAbstractKey,
3/25/2014 6:30:02 AM: 0034 FactBarBchTransactionItemInsurance,
3/25/2014 6:30:02 AM: 0035 FactBarBchTransactionItemInsuranceID,
3/25/2014 6:30:02 AM: 0036 FactBarBchTransactionPatientMRNUnitNumber,
3/25/2014 6:30:02 AM: 0037 FactBarBchTransactionPatientName,
3/25/2014 6:30:02 AM: 0038 FactBarBchTransactionProcedureID,
3/25/2014 6:30:02 AM: 0039 Date(FactBarBchTransactionBatchDateTime, 'MM/DD/YYYY') as [Bar Batch Date],
3/25/2014 6:30:02 AM: 0040 FactBarBchTransactionItemInsSubscriberPolicyNo,
3/25/2014 6:30:02 AM: 0041 FactBarBchTransactionDimBarVisitKey,
3/25/2014 6:30:02 AM: 0042 FactBarBchTransactionInsurance,
3/25/2014 6:30:02 AM: 0043 FactBarBchTransactionInsSubscriberPolicyNo
3/25/2014 6:30:02 AM: 0045 SQL
3/25/2014 6:30:02 AM: 0046 SELECT
3/25/2014 6:30:02 AM: 0047 a.FactBarBchTransactionBatchID,
3/25/2014 6:30:02 AM: 0048 a.FactBarBchTransactionTxnNumberID,
3/25/2014 6:30:02 AM: 0049 a.FactBarBchTransactionItemSeqID,
3/25/2014 6:30:02 AM: 0050 a.FactBarBchTransactionAmount,
3/25/2014 6:30:02 AM: 0051 CASE WHEN a.FactBarBchTransactionServiceDateTime = '01/01/1900' THEN Null ELSE a.FactBarBchTransactionServiceDateTime END as FactBarBchTransactionServiceDateTime,
3/25/2014 6:30:02 AM: 0052 a.FactBarBchTransactionBarProcedureDescription,
3/25/2014 6:30:02 AM: 0053 a.FactBarBchTransactionBarProcedureType,
3/25/2014 6:30:02 AM: 0054 a.FactBarBchTransactionBarTransDesc,
3/25/2014 6:30:02 AM: 0055 a.FactBarBchTransactionBarTransType,
3/25/2014 6:30:02 AM: 0056 a.FactBarBchTransactionDimAbstractKey,
3/25/2014 6:30:02 AM: 0057 a.FactBarBchTransactionItemInsurance,
3/25/2014 6:30:02 AM: 0058 a.FactBarBchTransactionItemInsuranceID,
3/25/2014 6:30:02 AM: 0059 a.FactBarBchTransactionPatientMRNUnitNumber,
3/25/2014 6:30:02 AM: 0060 a.FactBarBchTransactionPatientName,
3/25/2014 6:30:02 AM: 0061 a.FactBarBchTransactionProcedureID,
3/25/2014 6:30:02 AM: 0062 CASE WHEN a.FactBarBchTransactionBatchDateTime = '01/01/1900' THEN Null ELSE a.FactBarBchTransactionBatchDateTime END as FactBarBchTransactionBatchDateTime,
3/25/2014 6:30:02 AM: 0063 b.SubscriberPolicyNo as FactBarBchTransactionItemInsSubscriberPolicyNo,
3/25/2014 6:30:02 AM: 0064 a.FactBarBchTransactionDimBarVisitKey,
3/25/2014 6:30:02 AM: 0065 a.FactBarBchTransactionInsurance,
3/25/2014 6:30:02 AM: 0066 c.SubscriberPolicyNo as FactBarBchTransactionInsSubscriberPolicyNo
3/25/2014 6:30:02 AM: 0067 FROM "DW_DDS"."bi_dds"."vwFactBarBchTransaction_QV" a
3/25/2014 6:30:02 AM: 0068 LEFT JOIN "DW_DDS"."bi_dds"."BridgeBarVisitToIns" b
3/25/2014 6:30:02 AM: 0069 ON a.FactBarBchTransactionBillingID = b.BillingID AND a.FactBarBchTransactionDimIitemMisInsuranceKey = b.DimMisInsuranceKey
3/25/2014 6:30:02 AM: 0070 LEFT JOIN "DW_DDS"."bi_dds"."BridgeBarVisitToIns" c
3/25/2014 6:30:02 AM: 0071 ON a.FactBarBchTransactionBillingID = c.BillingID AND a.FactBarBchTransactionDimMisInsuranceKey = c.DimMisInsuranceKey
3/25/2014 6:30:04 AM: 20 fields found: FactBarBchTransactionBatchID, FactBarBchTransactionTxnNumberID, FactBarBchTransactionItemSeqID, FactBarBchTransactionAmount, Bar Bch Trans DOS, Bar Bch Proc Desc, FactBarBchTransactionBarProcedureType, FactBarBchTransactionBarTransDesc, FactBarBchTransactionBarTransType, FactBarBchTransactionDimAbstractKey, FactBarBchTransactionItemInsurance, FactBarBchTransactionItemInsuranceID, FactBarBchTransactionPatientMRNUnitNumber, FactBarBchTransactionPatientName, FactBarBchTransactionProcedureID, Bar Batch Date, FactBarBchTransactionItemInsSubscriberPolicyNo, FactBarBchTransactionDimBarVisitKey, FactBarBchTransactionInsurance, FactBarBchTransactionInsSubscriberPolicyNo, 673,938 lines fetched
3/25/2014 6:30:13 AM: 0079 BarVisit:
3/25/2014 6:30:13 AM: 0080 LOAD
3/25/2014 6:30:13 AM: 0081 DimBarVisitKey,
3/25/2014 6:30:13 AM: 0082 DimBarVisitKey as FactBarBchTransactionDimBarVisitKey,
3/25/2014 6:30:13 AM: 0083 DATE(BarVisitServiceDate, 'MM/DD/YYYY') as [Bar Visit Service Date]
3/25/2014 6:30:13 AM: 0085 SQL SELECT
3/25/2014 6:30:13 AM: 0086 a.DimBarVisitKey,
3/25/2014 6:30:13 AM: 0087 CASE WHEN b.FullDate = '01/01/1900' THEN Null ELSE b.FullDate END as BarVisitServiceDate
3/25/2014 6:30:13 AM: 0088 FROM "DW_DDS"."bi_dds".DimBarVisit a
3/25/2014 6:30:13 AM: 0089 LEFT JOIN "DW_DDS"."bief_dds".DimDate b
3/25/2014 6:30:13 AM: 0090 ON a.BarVisitServiceDateKey = b.DateKey
3/25/2014 6:30:13 AM: 0094 Set QVDPath = "C:\QVDFiles\"
3/25/2014 6:30:13 AM: 0095 Set QVDName = "FactDiagnosisQVD.qvd"
3/25/2014 6:30:13 AM: 0096 Set TableName = "FactDiagnosis"
3/25/2014 6:30:13 AM: 0104 FactDiagnosis:
3/25/2014 6:30:13 AM: 0105 LOAD
3/25/2014 6:30:13 AM: 0106 FactDiagnosisKey,
3/25/2014 6:30:13 AM: 0107 DiagnosisDimPatientKey,
3/25/2014 6:30:13 AM: 0108 DiagnosisProviderFullName as [Diagnosis Claim Provider],
3/25/2014 6:30:13 AM: 0109 DiagnosisClaimNumber as [Diagnosis Claim Number],
3/25/2014 6:30:13 AM: 0110 DiagnosisName as [Diagnosis Name],
3/25/2014 6:30:13 AM: 0111 DiagnosisCode as [Diagnosis Code],
3/25/2014 6:30:13 AM: 0112 DiagnosisFacilityName as [Diagnosis Facility],
3/25/2014 6:30:13 AM: 0113 DiagnosisFacilityGroupName as [Diagnosis Facility Group],
3/25/2014 6:30:13 AM: 0114 DATE(DiagnosisInvoiceDate, 'MM/DD/YYYY') AS [Diagnosis Claim Date],
3/25/2014 6:30:13 AM: 0115 DATE(DiagnosisServiceDate, 'MM/DD/YYYY') as [Diagnosis Service Date],
3/25/2014 6:30:13 AM: 0116 DiagnosisPrimaryFlag as [Primary Diagnosis],
3/25/2014 6:30:13 AM: 0117 DiagnosisOrder,
3/25/2014 6:30:13 AM: 0118 DiagnosisClaimBillTo,
3/25/2014 6:30:13 AM: 0119 DiagnosisClaimBillToInsuranceName,
3/25/2014 6:30:13 AM: 0120 DiagnosisClaimBillToInsuranceGroup,
3/25/2014 6:30:13 AM: 0121 DiagnosisClaimInsurance1_GroupNo,
3/25/2014 6:30:13 AM: 0122 DiagnosisClaimInsurance1_SubscriberNo,
3/25/2014 6:30:13 AM: 0123 DiagnosisClaimInsurance1_InsuranceName,
3/25/2014 6:30:13 AM: 0124 DiagnosisClaimInsurance1_InsuranceGroup,
3/25/2014 6:30:13 AM: 0125 DiagnosisClaimInsurance2_GroupNo,
3/25/2014 6:30:13 AM: 0126 DiagnosisClaimInsurance2_SubscriberNo,
3/25/2014 6:30:13 AM: 0127 DiagnosisClaimInsurance2_InsuranceName,
3/25/2014 6:30:13 AM: 0128 DiagnosisClaimInsurance2_InsuranceGroup,
3/25/2014 6:30:13 AM: 0129 DiagnosisClaimVoidFlag,
3/25/2014 6:30:13 AM: 0130 FactDiagnosisID
3/25/2014 6:30:13 AM: 0131 From C:\QVDFiles\FactDiagnosisQVD.qvd (qvd)
3/25/2014 6:30:13 AM: 0132 WHERE DiagnosisClaimDeleteFlag = 'N'
3/25/2014 6:30:13 AM: Error: Field not found - <DimBarVisitKey>
3/25/2014 6:30:13 AM: General Script Error
3/25/2014 6:30:13 AM: Execution Failed
3/25/2014 6:30:13 AM: Execution finished.
Day 2 log
3/26/2014 6:30:14 AM: 0045 SQL
3/26/2014 6:30:14 AM: 0046 SELECT
3/26/2014 6:30:14 AM: 0047 a.FactBarBchTransactionBatchID,
3/26/2014 6:30:14 AM: 0048 a.FactBarBchTransactionTxnNumberID,
3/26/2014 6:30:14 AM: 0049 a.FactBarBchTransactionItemSeqID,
3/26/2014 6:30:14 AM: 0050 a.FactBarBchTransactionAmount,
3/26/2014 6:30:14 AM: 0051 CASE WHEN a.FactBarBchTransactionServiceDateTime = '01/01/1900' THEN Null ELSE a.FactBarBchTransactionServiceDateTime END as FactBarBchTransactionServiceDateTime,
3/26/2014 6:30:14 AM: 0052 a.FactBarBchTransactionBarProcedureDescription,
3/26/2014 6:30:14 AM: 0053 a.FactBarBchTransactionBarProcedureType,
3/26/2014 6:30:14 AM: 0054 a.FactBarBchTransactionBarTransDesc,
3/26/2014 6:30:14 AM: 0055 a.FactBarBchTransactionBarTransType,
3/26/2014 6:30:14 AM: 0056 a.FactBarBchTransactionDimAbstractKey,
3/26/2014 6:30:14 AM: 0057 a.FactBarBchTransactionItemInsurance,
3/26/2014 6:30:14 AM: 0058 a.FactBarBchTransactionItemInsuranceID,
3/26/2014 6:30:14 AM: 0059 a.FactBarBchTransactionPatientMRNUnitNumber,
3/26/2014 6:30:14 AM: 0060 a.FactBarBchTransactionPatientName,
3/26/2014 6:30:14 AM: 0061 a.FactBarBchTransactionProcedureID,
3/26/2014 6:30:14 AM: 0062 CASE WHEN a.FactBarBchTransactionBatchDateTime = '01/01/1900' THEN Null ELSE a.FactBarBchTransactionBatchDateTime END as FactBarBchTransactionBatchDateTime,
3/26/2014 6:30:14 AM: 0063 b.SubscriberPolicyNo as FactBarBchTransactionItemInsSubscriberPolicyNo,
3/26/2014 6:30:14 AM: 0064 a.FactBarBchTransactionDimBarVisitKey,
3/26/2014 6:30:14 AM: 0065 a.FactBarBchTransactionInsurance,
3/26/2014 6:30:14 AM: 0066 c.SubscriberPolicyNo as FactBarBchTransactionInsSubscriberPolicyNo
3/26/2014 6:30:14 AM: 0067 FROM "DW_DDS"."bi_dds"."vwFactBarBchTransaction_QV" a
3/26/2014 6:30:14 AM: 0068 LEFT JOIN "DW_DDS"."bi_dds"."BridgeBarVisitToIns" b
3/26/2014 6:30:14 AM: 0069 ON a.FactBarBchTransactionBillingID = b.BillingID AND a.FactBarBchTransactionDimIitemMisInsuranceKey = b.DimMisInsuranceKey
3/26/2014 6:30:14 AM: 0070 LEFT JOIN "DW_DDS"."bi_dds"."BridgeBarVisitToIns" c
3/26/2014 6:30:14 AM: 0071 ON a.FactBarBchTransactionBillingID = c.BillingID AND a.FactBarBchTransactionDimMisInsuranceKey = c.DimMisInsuranceKey
3/26/2014 6:30:19 AM: Error: Field not found - <FactBarBchTransactionBatchID>
3/26/2014 6:30:19 AM: General Script Error
3/26/2014 6:30:19 AM: Execution Failed
3/26/2014 6:30:19 AM: Execution finished.
