3 Replies Latest reply: Dec 5, 2014 2:54 AM by Maxim Senin RSS

    Intermittent Field not found errors with Qlikview publisher

      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.