Auto Reload failure on QMC but ok on QV Client

simongoodman — Wed, 16 May 2012 16:14:50 GMT

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.

Auto Reload failure on QMC but ok on QV Client

vgutkovsky — Wed, 16 May 2012 16:42:27 GMT

Does the Publisher account have correct permissions on your database?

Re: Auto Reload failure on QMC but ok on QV Client

simongoodman — Fri, 18 May 2012 11:13:50 GMT

Thanks, it was a datareader permissions issue.

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

topic Re: Auto Reload failure on QMC but ok on QV Client in QlikView

Auto Reload failure on QMC but ok on QV Client

Auto Reload failure on QMC but ok on QV Client

Re: Auto Reload failure on QMC but ok on QV Client