What would be the reasons for task failures

[#1]

Hi floks

Could you please let me know what would be the reasons for tasks failures in QMC..It usually runs fine very day.

The log says

(2015-05-20 01:00:09) Error: The task "DATA_BACKBONE\OPERATIONAL DATA & FORECASTS\SALES FOR PPMs" failed. Exception:

(2015-05-20 01:00:09) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=G:\QlikView\01.Repository\98.TRANSFORMED\Data Backbone\1.2. DATA MANAGEMENT PROCESS FILES (QVW Files)\1.2.2. OPERATIONAL DATA AND FORECASTS\Sales for PPMs.qvw.

(2015-05-20 01:00:09) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2015-05-20 01:00:09) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-05-20 01:00:09) Error: --- End of inner exception stack trace ---

(2015-05-20 01:00:09) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-05-20 01:00:09) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-05-20 01:00:09) Error: --- End of inner exception stack trace ---

(2015-05-20 01:00:09) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-05-20 01:00:09) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2015-05-20 01:00:09) Information: Task Execute Duration=00:04:03.5628000

Please help me out

Regards

Anoop

[Clever_Anjos]

Please check the application log, it can be more usefull

[#3]

Hi Clever

the application log shows like this

20/05/2015 00:58:59: 0105  LOAD Distinct

20/05/2015 00:58:59: 0106   Hash128([Plant Code], [Material Code], [Sales Org Code], [Division Code], [Sold-to Party Code], MonthName(Date)) as [Plant/Material/SalesOrg/Division/Sold-to/MONTH Key],

20/05/2015 00:58:59: 0107   [Plant Code],

20/05/2015 00:58:59: 0108   [Material Code],

20/05/2015 00:58:59: 0109   [Sales Org Code],

20/05/2015 00:58:59: 0110   [Division Code],

20/05/2015 00:58:59: 0111   [Sold-to Party Code],

20/05/2015 00:58:59: 0112   MonthName(Date) as [MONTH],

20/05/2015 00:58:59: 0113   Sum([Salue (LCu)] * USD) as [Sales Value (USD)]

20/05/2015 00:58:59: 0114  Resident COPA

20/05/2015 00:58:59: 0115  Group By Hash128([Plant Code], [Material Code], [Sales Org Code], [Division Code], [Sold-to Party Code], MonthName(Date)), [Plant Code], [Material Code], [Sales Org Code], [Division Code], [Sold-to Party Code], MonthName(Date)

20/05/2015 00:59:56:       8 fields found: Plant/Material/SalesOrg/Division/Sold-to/MONTH Key, Plant Code, Material Code, Sales Org Code, Division Code, Sold-to Party Code, MONTH, Sales Value (USD), 1,916,668 lines fetched

20/05/2015 01:00:07: 0117  DROP Tables COPA

20/05/2015 01:00:07: 0121  Store * from [Sales Values for PPMs] into 'G:\QlikView\01.Repository\98.TRANSFORMED\Data Backbone\1.3. PROCESSED DATA (QVD Files)\1.3.2. OPERATIONAL DATA AND FORECASTS\PPMs\Sales Values for PPMs.qvd' (qvd)

20/05/2015 01:00:08:       General Script Error

20/05/2015 01:00:08:       Execution Failed

20/05/2015 01:00:08:      Execution finished.

[#4]

Check to see if you are able to rename that QVD file. I have had instances where the file was being tied up by QV so it was "read-only" and could not be over written.

[Anonymous]

That General Script Error after a Store can be a right pain.  I suspect it happens when disk writes are slow.

Try putting a Sleep(10000) as in 10 seconds after the Store.

[Clever_Anjos]

I would surround your path with brackets

Store * from [Sales Values for PPMs] into (qvd)

[ToniKautto]

The QVD is targeted fro G: drive. If this is a mapped network drive, the issue could be related to network problems. In a persistent problem, try writing the QVD to local disk to confirm if the target folder is the issue.

If you are using a mapped drive, also make sure the service account running your reload has the same mapped drive. For network drives it can be easier to simple write the full path instead of using a mapped drive.

[ramoncova06]

another thing you want to check are antivirus software clashing with you task reloads

[Siva_Sankar]

Anoop, Looks like the path is not accessible to store the QVD file. Check the path 'G:\QlikView\01.Repository\98.TRANSFORMED\Data Backbone\1.3. PROCESSED DATA (QVD Files)\1.3.2. OPERATIONAL DATA AND FORECASTS\PPMs is accessible from where the server where you are running. Or try changing the path to store the QVD as mentioned by Toni.