Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I was wondering if someone could help me on a issue that I'm experience at the moment?
I currently have all my Qlikview taks set up on a SSIS-EDX execution plan. Everything was running fine for the last 25 days until now.
There was 1 task that could not be successfully executed. (Please find attached the Tasklog file deailing the Task progress).
In order to stop the task I had to restart all Qlikview services.
I was wondering if anyone has come across this issue before? I have the latest version of Qlikview Installed (11.011440.0 SR2) and the Qlikview Server has 40 CPU and 512 gigs of Ram. Any help on this would be greatly appreciated. Thanks very much.
Kind Regards
Eamonn
Hi
Although I do not know why this issue occurs. I did discover code for the C# EDX execution application that will abort the Task exceed the specified Timeout.
An If condition stating the timeout paramentar
if (Data_Layer.Contains("_Raw"))
{
_timeout = 3600; /* 60 minutes For Raw Layer */
Console.WriteLine(_timeout);
}
Qlikview C# API command to abort the executiong task.
client.AbortTask(result.TaskId);
If you have any quereis please let me know.
Cheers
Eamonn
Hello
my method of error finding:
1. run by hand from server and with log (error in log: data problems, connections problems)
2 run by hand task
3 run by hand from SSIS
4 run all SSIS by hand
Not find reason ?
Error possible due to count of parallel proccess of QVB simultaneously running- In SSIS change how many tasks can run simultaniously.
Best regards
Hugo
Hi Hugo
Thanks for getting back to me.
I believe this issue might have been a rare occurrence as it has not resurfaced for the last 4 days.
I do believe it is somehow related to an issue with SSIS and the QlikView reload engine where mutual exclusion can occur where 2 SSIS tasks can call a QlikView Reload engine at exactly the same time.
This usually ends with 1 of the task failing but the above can occur as well if the CPU is under high duress.
Please let me know what you think?
Thanks very much.
Eamonn
Hi
In QMC chech how many can be simultaneously QVB processes -no more than 9. (if you are not changed registry to resolve MS limitation)
Also tasks from SSIS can start reading (or writing) in the same moment to the same file (qvd, qvw).
Best regards
Hugo
Hi
Although I do not know why this issue occurs. I did discover code for the C# EDX execution application that will abort the Task exceed the specified Timeout.
An If condition stating the timeout paramentar
if (Data_Layer.Contains("_Raw"))
{
_timeout = 3600; /* 60 minutes For Raw Layer */
Console.WriteLine(_timeout);
}
Qlikview C# API command to abort the executiong task.
client.AbortTask(result.TaskId);
If you have any quereis please let me know.
Cheers
Eamonn