Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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.


3 Replies
Not applicable

Re: Intermittent Field not found errors with Qlikview publisher

Is there a possiblity that database is being modified, updated when the task fails?

In that case , task will only load what is being accessible from database

chiru_thota
Valued Contributor

Re: Intermittent Field not found errors with Qlikview publisher

I guess column names have been changed recently.

You need to handle them by changing your scripts or renaming to original columns.

maxim_senin
Contributor III

Re: Intermittent Field not found errors with Qlikview publisher

Hi,

The most correct thing to do in this is case is to shrug your shoulders...

I faced with this too using QVD (never saw it with SQL) and my assumption is that the data a not available and/or blocked by some process, since loading of QVD shows that the "not found field" exists in the QVD.

Best regards,

Maxim

Community Browser