Forum Discussion
larolsen
12 years agoContributor
Hi
The error is actully stated as "Unspecificed Error"... And then the script execution stops. This is partly what makes this so difficult to debug.
We have narrowed it down to a few machines that almost always fail with this, so it is not completely random.
The code that fails is actually this simple:
Function DdtGlobal(P_strSheetName)
if aqFile.Exists(G_strTables) = false then
log.Error("Excelworkbook could not be found at: " & G_strTables)
else
Set DdtGlobal = DDT.ExcelDriver(G_strTables, P_strSheetName, TRUE)
end if
End Function
G_strTables contains the correct path to the worbook
P_strSheetName contains the name of the sheet in the workbook
Both of these variables are filled with correct information.
Best regards
Lars Lund Olsen
The error is actully stated as "Unspecificed Error"... And then the script execution stops. This is partly what makes this so difficult to debug.
We have narrowed it down to a few machines that almost always fail with this, so it is not completely random.
The code that fails is actually this simple:
Function DdtGlobal(P_strSheetName)
if aqFile.Exists(G_strTables) = false then
log.Error("Excelworkbook could not be found at: " & G_strTables)
else
Set DdtGlobal = DDT.ExcelDriver(G_strTables, P_strSheetName, TRUE)
end if
End Function
G_strTables contains the correct path to the worbook
P_strSheetName contains the name of the sheet in the workbook
Both of these variables are filled with correct information.
Best regards
Lars Lund Olsen