I keep getting an error when running my DSATs as follows:
Method ‘Run’ of object’_Application failed.
Can anyone shed any light on this?
I have contacted the kpmg helpdesk but have not received a response.
ChrisApril 9, 2013 at 5:12 pm #929
I have just installed the new version and get the same error, so if you get a response from KPMG………….. :0)
AnnelieseApril 10, 2013 at 8:43 am #930
Things you may need to check:
Are Access and Excel from the same Office version (cannot mix 2003/2007/2010).
That Excel was not already open when you started DSAT.
I am using ver.13 on windows 8, no problems.
RegardsApril 10, 2013 at 8:47 am #931
I am getting the same error but it only occurs when I select particular reports on the General Tab.
All others seem ok. The four offenders are 130-01-004, 130-01-008, 130-01-104 and 130-01-108.
Hope that helps.
DerekApril 10, 2013 at 9:28 am #933
Thanks for all your replies. I have still not received a response from kpmg so I will contact them again.April 11, 2013 at 11:01 am #944
I have tried to run DSAT again and I now get the same error as you all report.
The error is generated after the third report and this is shown in the second report where only the first three have a new update date.
I have not updated DSAT since 13 was released so I am wondering if this is an issue from Microsoft updates.
If you are unable to run Excel after this error you may have to end the process through Task Manager.
Looks like a problem for KPMG.
RegardsApril 11, 2013 at 12:36 pm #945
I have had the same problem and reported it to KPMG earlier this week – like you, still awaiting a response.
I have had to revert to DSAT v13.11 to get any DSAT reports.
The Data Service have said that it is a KPMG problem, but to call them again later next week if the issue is still unresolved.April 12, 2013 at 11:44 am #962
I have just rung KPMG and Tim Scarlett is out of the office until Monday when hopefully he will look at this problem.April 12, 2013 at 2:12 pm #973
The error may be an issue with rerunning data as If I complete the following it all works ok and produces all reports from 130-01-04 through to 130-05-812:
From DSAT Utilities
Set Report Path (was set to different to previous)
Select and Run all reports
Tested on R09 with Windows 7 & 8
RegardsApril 15, 2013 at 7:06 am #977
Has anyone else tried Martin’s solution? I tried reloading the LIS_EXE and still get the error.
Would have been good to have a response from KPMG!
ChrisApril 16, 2013 at 7:27 am #983
I have re run all DSAT reports again today to produce the same results as previous.
You may need to change the output path to a new directory using Set Report Directory with a dummy file name to overcome the requirement for an existing file in the directory.
Windows 8 Pro with Office 10April 16, 2013 at 8:24 am #984
Hi I have had the same issue and got the below response from KPMG
We have two major problems with DSAT v13.20.
1) Reports 130-01-104 and 130-01-108 have been corrupted during testing and rectification. This in turn causes Reports 130-01-004 and 130-01-008 to have the same error. If you run DSAT v13.20 without using any of those reports it should run satisfactorily. However, an alternative is to revert to DSAT v13.11 which does not have the same problem but is also missing the cross reporting.
2) The cross reporting is likely to fail owing to data issues. It has been found in relatively common circumstances that some fields used by the cross reporting have not been populated (they just have “null” values in them). Under these conditions the reports fail.
DSAT v13.20 should have been removed from the Data Service website and replaced with DSAT v13.11 but it is noted that this hasn’t happened yet.
DSAT v13.21 correcting the above issues is currently under test and will hopefully be released shortly.April 19, 2013 at 1:06 pm #1004
You must be logged in to reply to this topic.