External component has thrown an exception.

[mharps]

Hi All,

I am getting to be somewhat frustrated with UFT.
This morning I started the development of a new test.
I had run 11 other tests using UFT 11.5) on a Win XP system and IE 8.
All those 11 test were able to be opened and still can be.

The one I have started development on this morning was closed approx 2 hours ago when I went to lunch. No issues with shutting down UFT.

After coming back from lunch, I started UFT and attempted to open the test I was developing.

Unfortunately I am not able to. Uft throws up a "External component has thrown an exception." error and I am unable to open that test.

The test is being stored in a seperate local folder not on a LAN drive.
I am not using QC to store and run the test.

I have tried copying the folder to another PC and the same issue occurs.
It does not appear to be a hardware problem.

The strange thing is that sometimes it will randomly open but all that is displayed in the window that shows the run order diagram, is the "Start" and "End" ovals with an arrow between - none of the developed Actions are being displayed.


Details from the error window are as follows:

Exception of type: System.Runtime.InteropServices.SEHException. Source: IPrmBookLib. Occured in Void set_ReadOnly(Boolean) method
Exception message is: External component has thrown an exception.
Exception trace is: at IPrmBookLib.ISheet3.set_ReadOnly(Boolean pVal)
at HP.QTP.Backend.Entities.DataTable.DataTableSheet.set_ReadOnly(Boolean value)
at HP.QTP.Backend.Common.Utils.DataTableUtils.AddExternalActionDataSheetToTestDT(IDataTableBook testBook, IExternalActionDocument extAction, IDataTableBook extBook)
at HP.QTP.Backend.Entities.DataTable.DataTableResource.LoadTestExternalActionsData(IQTCollectionItem testDocument)
at HP.QTP.Backend.Entities.DataTable.DataTableResource.UpdateActiveContext(IQTCollectionItem contextDoc)
at HP.QTP.Backend.Entities.DataTable.DataTableProxy.UpdateContext()
at HP.QTP.Backend.Entities.DataTable.DataTableProxy.get_Resource()
at HP.QTP.Backend.Entities.DataTable.DataTableProxy.Initialize(IDataTableResource resource)
at HP.QTP.Backend.Features.DataTableFeature.DataTableFeature.TryLoadDataTable(DataTableDependencyInfo dtInfo, Boolean openInReadOnlyMode)
at HP.QTP.Backend.Features.DataTableFeature.DataTableFeature.LoadDataTable(DataTableDependencyInfo dtInfo, Boolean bUseFallBack, Boolean openInReadOnlyMode)
at HP.QTP.Backend.Builders.ItemBuilders.TestBuilderBase`2.LoadDataTable(TInfo testInfo, TItem item, Boolean openInReadOnlyMode)
at HP.QTP.Backend.Builders.ItemBuilders.TestBuilder.LoadTestBaseDependencies(TestInfo testInfo, TestDocument test, Boolean openInReadOnlyMode)
at HP.QTP.Backend.Builders.ItemBuilders.TestBuilderBase`2.Load(String path, IQTCollectionItem owner, Boolean openInReadOnlyMode)
at HP.QTP.Backend.Builders.ItemBuilders.ItemBuilderBase`2.HP.QTP.Backend.Common.IQTItemBuilder.Load(String path, IQTCollectionItem owner, Boolean openInReadOnlyMode)
at HP.QTP.Backend.Collections.QTCollectionBase.InternalLoad(String path, IQTCollectionItem owner, Boolean openInReadOnlyMode, String baselineId)
at HP.QTP.Backend.Collections.QTCollectionBase.Load(String rawPath, IQTCollectionItem owner, Boolean openInReadOnlyMode, Boolean forceUpdateCache, String baselineId)
at HP.QTP.Backend.Collections.QTCollectionBase.Load(String rawPath, IQTCollectionItem owner, Boolean openInReadOnlyMode, String baselineId)
at HP.QTP.BackEndServices.BackEndManager.<>c__DisplayClass15.<OpenTest>b__12(Object dummyLoadInfo)
at HP.UFT.Common.Cache`2.GetOrCreate[TCreationInfo](TIdentifier identifier, Func`2 objectGenerator, TCreationInfo creationInfo)
at HP.QTP.BackEndServices.BackEndManager.OpenTest(String testPath, Boolean openInReadOnlyMode, String baselineId)
at HP.QTP.ProjectSystem.QtpProjectService.LoadTestProject(LocationInfo locationInfo)
at HP.UFT.Common.Cache`2.GetOrCreate[TCreationInfo](TIdentifier identifier, Func`2 objectGenerator, TCreationInfo creationInfo)
at HP.QTP.ProjectSystem.QtpProjectService.LoadProject(ProjectLoadInformation projectLoadInfo)

SharpDevelop Version : 4.1.1.0-00000000
.NET Version : 4.0.30319.1022
OS Version : Microsoft Windows NT 5.1.2600 Service Pack 3
Current culture : English (New Zealand) (en-NZ)
Working Set Memory : 278576kb
GC Heap Memory : 17982kb


Unexpected error while loading '{0}'. Please contact support.

---- Post-error application state information:
Installed 3rd party AddIns: [${res:Addin.UFT.File.Dialog.UFT.Only} 11.50.0.0], [ActiveScreenPane 0.0.0.0], [QTP DataTable Addin], [QTP Debugger addin based on UT Debugger 0.0.0.0], [QTP FileDialog 0.0.0.0], [HP QTP Property Tabs 0.0.0.0], [ALM Storage 11.50.0.0], [HP Basic Extensibility 11.50.0.0], [HP Designer UI Extensibility 11.50.0.0], [HP SOAReplayAPI Extensibility 11.50.0.0], [${res:HP_Async} 11.50.0.0], [${res:HP_Checkpoints} 11.50.0.0], [${res:STDataProvider_HP_Data_Providers} 11.50.0.0], [${res:BasicActivity_HP_Basic_Activities} 11.50.0.0], [${res:HP_BPT_Integration} 11.50.0.0], [HP CSharp Translation Layer 11.50.0.0], [${res:HP_Database_Activities} 11.50.0.0], [${res:HP_Standard_Import_Technologies} 11.50.0.0], [HP Framework Upgraders 11.50.0.0], [${res:HP_FTP_Activities} 11.50.0.0], [ST Debugger addin based on UT Debugger 11.50.0.0], [${res:HTTP_Activity} 11.50.0.0], [${res:HP_Receiver_Activity} 11.50.0.0], [Run Step Pad 11.50.0.0], [${res:HP_Java_Call_Addin} 11.50.0.0], [${res:HP_JMS_Technology} 11.50.0.0], [${res:HP_LoadRunner_Integration} 11.50.0.0], [${res:HP_MQ_Activities} 11.50.0.0], [${resropertySheet_HP_Basic_Property_Sheet} 11.50.0.0], [${res:HP_Rest_Technology} 11.50.0.0], [${res:HP_UFT_STM} 11.50.0.0], [${res:HP_Service_Test_runner} 11.50.0.0], [HP Basic Framework 11.50.0.0], [Toolbox Default Presenter 11.50.0.0], [HP Toolbox UI Extensibility 11.50.0.0], [${res:HP_Transform_JSON_Addin} 11.50.0.0], [${res:HP_Transform_Xml_Addin} 11.50.0.0], [${res:HP_QTP_test_runner} 11.50.0.0], [${res:HP_Validate_Xml_Addin} 11.50.0.0], [VTD Extensibility 11.50.0.0], [${res:HP_Run_Vugen_Addin} 11.50.0.0], [${res:Wait_Activity} 11.50.0.0], [${res:WSImportTechnology_HP_Standard_Import_Technologies} 11.50.0.0], [HP Shell Services 11.50.0.0], [${res:Addin.UFT.Data.Explorer} 11.50.0.0], [UTT Configuration UI 11.50.0.0], [Debug Pad Wrapper Extension addin for UTT 11.50.0.0], [UTT Debug Basic implementation addin for UTT 11.50.0.0], [UTT File Dialog 11.50.0.0], [${res:Addin.UFT.File.System} 11.50.0.0], [${res:Addin.UFT.ALM} 11.50.0.0], [UTT Connection Addin 11.50.0.0], [HPUttIdeCommands 11.50.0.0], [UttBookmarkPad 11.50.0.0], [UttErrorListPad 11.50.0.0], [UttOutputPad 11.50.0.0], [UttTaskListPad 11.50.0.0]
Workbench.ActiveContent: HP.UFT.StartPage.StartPageViewContent
ProjectService.OpenSolution: <null>
ProjectService.CurrentProject: <null>

---- Recent SharpDevelop log messages:

---- Recent Utt log messages:

===================================

Can anyone help with the above error?

Thanks for your help.
Mike

[mharps]

Hi All,

We have been able to work out what has been causing the issue.
The "Default.xls" found in the root folder for the test, is being corrupted for some reason.
The work around is to replace that "Default.xls" with a good one.
I have created a dummy test that has a clean "Default.xls".
I replaced the corrupt one with that clean one and it now opens with no issues.

Cheers,
Mike