Auto Reload failure on QMC but ok on QV Client

[simongoodman]

The manual reload works on Qlikview Client but not the automatic reload on the QMC. As you can see it says General Script Error and relates to 'Error. Field not found <AttributeName>'. The database source is Microsoft Dynamics CRM and I have used two stringmaps using Where AttributeName = 'XXX_CallOutcome' and AttributeName = 'StatusCode'  to define each and extract the required data. I haved used Qualify for each stringmap script to avoid duplicate named fields. You can see the script to the calendar just started.

Can anyone help?

16/05/2012 13:42:34: 0096  StatusCode:
16/05/2012 13:42:34: 0097  QUALIFY *
16/05/2012 13:42:34: 0098  UNQUALIFY ObjectTypeCode,StatusCode,StatusReason
16/05/2012 13:42:34: 0099  LOAD 
16/05/2012 13:42:34: 0100      ObjectTypeCode,
16/05/2012 13:42:34: 0101      AttributeName,
16/05/2012 13:42:34: 0102      AttributeValue                 AS        StatusCode,
16/05/2012 13:42:34: 0103  
16/05/2012 13:42:34: 0104  
16/05/2012 13:42:34: 0105      Value                                 AS        StatusReason,    
16/05/2012 13:42:34: 0106  
16/05/2012 13:42:34: 0107      VersionNumber,
16/05/2012 13:42:34: 0108      StringMapId
16/05/2012 13:42:34: 0109  SQL SELECT *
16/05/2012 13:42:34: 0110  FROM "XXXX_MSCRM".dbo.StringMap                      WHERE   AttributeName = 'StatusCode' AND ObjectTypeCode = '4210'
16/05/2012 13:42:35: 0111  UNQUALIFY *
16/05/2012 13:42:35: 0114  Calloutcome:
16/05/2012 13:42:35: 0115  QUALIFY *
16/05/2012 13:42:35: 0116  UNQUALIFY "XXX_CallOutcome",CallReasaon
16/05/2012 13:42:35: 0117  LOAD 
16/05/2012 13:42:35: 0118  
16/05/2012 13:42:35: 0119      AttributeName,
16/05/2012 13:42:35: 0120      AttributeValue                   AS       "XXX_CallOutcome",
16/05/2012 13:42:35: 0121  
16/05/2012 13:42:35: 0122  
16/05/2012 13:42:35: 0123      Value                                   AS       CallReasaon,
16/05/2012 13:42:35: 0124  
16/05/2012 13:42:35: 0125  
16/05/2012 13:42:35: 0126      StringMapId as StringMapId2
16/05/2012 13:42:35: 0127  SQL SELECT *
16/05/2012 13:42:35: 0128  FROM "XXXX_MSCRM".dbo.StringMap                      WHERE   AttributeName = 'XXX_CallOutcome'
16/05/2012 13:42:35: 0129  UNQUALIFY *
16/05/2012 13:42:35: 0132  LET vDateMin = Num(MakeDate(2012,3,13))
16/05/2012 13:42:35: 0133  LET vDateMax = Floor(MonthEnd(Today()))
16/05/2012 13:42:35: 0134  LET vDateToday = Num(Today())
16/05/2012 13:42:35: 0139  TempCalendar:  
16/05/2012 13:42:35: 0140  LOAD 
16/05/2012 13:42:35: 0141  40981 + RowNo() - 1 AS Num,  
16/05/2012 13:42:35: 0142  Date(40981 + RowNo() - 1) AS TempDate  
16/05/2012 13:42:35: 0143  AUTOGENERATE 1  
16/05/2012 13:42:35: 0144  WHILE 40981+IterNo()-1<= 41060
16/05/2012 13:42:35:       Error: Field not found - <AttributeName>
16/05/2012 13:42:35:       General Script Error
16/05/2012 13:42:35:       Execution Failed
16/05/2012 13:42:35:      Execution finished.

[vgutkovsky]

Does the Publisher account have correct permissions on your database?

[simongoodman]

Thanks, it was a datareader permissions issue.

On Wed, May 16, 2012 at 5:42 PM, Vlad Gutkovsky <