Hi,
I have a test that has just 1 row of data (via excel) bound to it.
When I run on my desktop it executes no worries but when run on the remote execution server it isn't picking up the bound data. My execution results show 0/0 (PASSED/TOTAL).
Any ideas why this would be happening?
Thanks
Adrian
2 Answers, 1 is accepted
0
Hi Adrian,
I'm sorry that you are experiencing such a misbehavior.
In order to find the root cause of it, we'll need some additional information. Could you kindly provide us with the following:
- The test log for the failing test it can be obtained as outlined below:
- The logs from execution machines,which can be attained according to these guidelines.
Kindly keep in mind that this forum thread is public, hence, we recommend to raise a private support ticket in case the logs contain sensitive data.
Looking forward to your response.
Kind Regards,
Stoyan
Progress Telerik
Virtual Classroom is the free self-paced technical training portal that gets you up to speed with Telerik and Kendo UI products including Telerik Test Studio! Check it out at https://learn.telerik.com/.
Adrian
commented on 18 Apr 2023, 11:37 PM
Top achievements
Rank 2
Iron
Iron
Iron
Rank 2
Iron
Iron
Iron
Hi Stoyan,
Test Log;
Overall Result: NotRun
------------------------------------------------------------
'17/04/2023 4:19:04 PM' - Executing test: 'Add a New Truck and make Inactive', path: '02. DEV\SIMS\301 (SIT)\API's\Test Scenarios\Grower\Preferences\My Trucks\Add a New Truck and make Inactive.tstest.'
'17/04/2023 4:19:04 PM' - Using .Net Runtime version: '4.0.30319.42000' for test execution. Build version is '2021.3.1103.0'.
'17/04/2023 4:19:04 PM' - Starting execution....
------------------------------------------------------------
------------------------------------------------------------
'17/04/2023 4:19:13 PM' - Detected DataDriven Test. Starting data iterations.
'17/04/2023 4:19:13 PM' - There is no data to execute the test with.
------------------------------------------------------------
'17/04/2023 4:19:13 PM' - Overall Result: NotRun
'17/04/2023 4:19:13 PM' - Duration: [0 min: 0 sec: 3 msec]
------------------------------------------------------------
'17/04/2023 4:19:13 PM' - Test completed!
Execution Server;
[04/17 16:18:52,Telerik.TestStudio.RemoteExecutor.exe(900:3)] First trace message from pool unnamed thread (managed ID = 3, native ID = 6068).[04/17 16:18:52,Telerik.TestStudio.RemoteExecutor.exe(900:3),Execution] CloudStorageProjectOpener.DownloadAndSaveTestsAsync() : ------- Function End -------
[04/17 16:18:52,Telerik.TestStudio.RemoteExecutor.exe(900:3),Warning] CloudRunnableGUITestBuilder.CreateLocalCacheAsync() : Finished getting project from storage
[04/17 16:19:00,Telerik.TestStudio.RemoteExecutor.exe(900:17),TestStudio] <>c__DisplayClass35_0.<LoadInternal>b__1() : Extract elements time: 00:00:06.2308097
[04/17 16:19:02,Telerik.TestStudio.RemoteExecutor.exe(900:17),TestStudio] <>c__DisplayClass35_0.<LoadInternal>b__1() : Merge elements time: 00:00:01.6271726
[04/17 16:19:02,Telerik.TestStudio.RemoteExecutor.exe(900:17),TestStudio] <>c__DisplayClass35_0.<LoadInternal>b__1() : Total Elements count: 6194
[04/17 16:19:03,ArtOfTest.Runner.exe(4248:3)] First trace message from process 4248: "C:\Program Files (x86)\Progress\Test Studio\Bin\ArtOfTest.Runner.exe" /controller /parentprocesshandle=3796
[04/17 16:19:03,ArtOfTest.Runner.exe(4248:3)] First trace message from foreground thread "Remote.ArtOfTest.Runner.Listener" (managed ID = 3, native ID = 964).
[04/17 16:19:03,ArtOfTest.Runner.exe(4248:3),TestStudio] Loader.LoadTranslatorGroups() : ------- Function Start -------
[04/17 16:19:04,ArtOfTest.Runner.exe(4248:3),TestStudio] Loader.LoadTranslatorGroups() : ------- Function End -------
[04/17 16:19:05,ArtOfTest.Runner.exe(4248:4)] First trace message from pool unnamed thread (managed ID = 4, native ID = 3872).
[04/17 16:19:05,ArtOfTest.Runner.exe(4248:4),TestStudio] Manager.GetDialogMatchProvider() : The dialog matches assembly 'Telerik.TestStudio.DialogMatches.dll' with version '2021.3.1103.0' loaded successfully.
[04/17 16:19:05,ArtOfTest.Runner.exe(4248:4),Framework] Manager.KillNonAutomatedBrowsers() : Closing non-automated 'chrome' browser instances
[04/17 16:19:05,Telerik.TestingFramework.Hosts.Manager.exe(6320:1)] First trace message from process 6320: "C:\Program Files (x86)\Progress\Test Studio\Bin\Telerik.TestingFramework.Hosts.Manager.exe"
[04/17 16:19:05,Telerik.TestingFramework.Hosts.Manager.exe(6320:1)] First trace message from foreground unnamed thread (managed ID = 1, native ID = 8012).
[04/17 16:19:05,Telerik.TestingFramework.Hosts.Manager.exe(6320:1),WebSocket] HostsManager constructor : Starting a web socket server to communicate with the browser extension...
[04/17 16:19:05,Telerik.TestingFramework.Hosts.Manager.exe(6320:1),WebSocket] HostsManager constructor : A web socket server was successfully started on port: 51555.
[04/17 16:19:05,Telerik.TestingFramework.Hosts.Manager.exe(6320:1),WebSocket] HostsManager constructor : Starting a file server to host the start page of the browser extension...
[04/17 16:19:05,Telerik.TestingFramework.Hosts.Manager.exe(6320:1),WebSocket] HostsManager constructor : A file server to host the start page of the browser extension was successfully started on: http://localhost:51556/webui/.
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:13)] First trace message from pool unnamed thread (managed ID = 13, native ID = 544).
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:13),Framework] Manager.AddNewBrowser() : Added client ID "f2659bd7-17b5-439d-ad84-a044b9d0b5db" (now there is/are 1 total).
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:4),Execution] ExecutionEngine.InternalExecuteTest() : Executing test: 'Add a New Truck and make Inactive', path: '02. DEV\SIMS\301 (SIT)\API's\Test Scenarios\Grower\Preferences\My Trucks\Add a New Truck and make Inactive.tstest.'
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:4),Execution] ExtensionsManager.LoadExtensions() : ------- Function Start -------
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:4),Uncategorized] ExtensionsManager.LoadExtensions() : Got 9 plugin(s) in folder "C:\Program Files (x86)\Progress\Test Studio\Bin\Plugins".
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:4),Uncategorized] ExtensionsManager.LoadExtensions() : Loaded assembly "LibGit2Sharp.dll" from plugins folder.
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:4),Uncategorized] ExtensionsManager.LoadExtensions() : Loaded assembly "Telerik.TestStudio.Jira.BugTracking.dll" from plugins folder.
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:4),Uncategorized] ExtensionsManager.LoadExtensions() : Loaded assembly "Telerik.TestStudio.OTA.Interop.dll" from plugins folder.
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:4),Uncategorized] ExtensionsManager.LoadExtensions() : Loaded assembly "Telerik.TestStudio.Plugins.dll" from plugins folder.
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:4),Uncategorized] ExtensionsManager.LoadExtensions() : Loaded assembly "Telerik.TestStudio.ScreenRecorderExtension.dll" from plugins folder.
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:4),Uncategorized] ExtensionsManager.LoadExtensions() : Loaded assembly "Telerik.TestStudio.Shared.dll" from plugins folder.
[04/17 16:19:12,ArtOfTest.Runner.exe(4248:4),Uncategorized] ExtensionsManager.LoadExtensions() : Loaded assembly "Telerik.TestStudio.SourceControl.dll" from plugins folder.
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),Uncategorized] ExtensionsManager.LoadExtensions() : Loaded assembly "Telerik.TestStudio.SourceControl.Git.dll" from plugins folder.
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),Uncategorized] ExtensionsManager.LoadExtensions() : Loaded assembly "Telerik.TestStudio.SourceControl.Git.TS.dll" from plugins folder.
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),Execution] ExtensionsManager.LoadExtensions() : ------- Function End -------
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),Error] ExcelDataSource.GetDataUnfiltered() : EXCEPTION! (see below)
Situation: Error reading from Excel database.
Outer Exception Type: System.InvalidOperationException
Message: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
HRESULT: 0x80131509 (Official ID (if app.) = COR_E_INVALIDOPERATION, Error Bit = FAILED, Facility = FACILITY_URT, Code = 5385)
Call Stack:
at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at ArtOfTest.Common.Design.Data.ExcelDataSource.GetDataUnfiltered(DataInfo testBindingInfo)
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),TestStudio] VisualDebugger.ShutDown() : VisualDebbuger::ShutDown::Start
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),TestStudio] VisualDebugger.ShutDown() : VisualDebbuger::ShutDown::End
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),Framework] BrowserProvisioner.EndService() : Connecting to the provisioning pipe "Pipe.ArtOfTest.WebAii.BrowserProvisioner_-485202330" in order to unblock and eventually terminate it...
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),Framework] BrowserProvisioner.EndService() : Provisioning pipe connected.
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:7)] First trace message from background thread "Pipe.ArtOfTest.WebAii.BrowserProvisioner" (managed ID = 7, native ID = 8820).
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:7),Framework] BrowserProvisioner.ServiceThread() : A new client has connected to the provisioning pipe but this will be treated as a termination cue.
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),Framework] BrowserProvisioner.EndService() : Provisioning thread terminated.
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),DialogPlayback] DialogMonitor.AddDialog() : Added {OnBeforeUnloadDialog(Dismiss=OK)} for monitoring.
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),Framework] Manager.RemoveBrowser() : Removed client ID "f2659bd7-17b5-439d-ad84-a044b9d0b5db" (0 remaining).
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),Framework] Manager.SetActiveBrowser() : Active browser is now null.
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),Warning] Manager.RemoveBrowser() : Attempted to remove a client ID "f2659bd7-17b5-439d-ad84-a044b9d0b5db" that was not in the list.
[04/17 16:19:13,ArtOfTest.Runner.exe(4248:4),DialogPlayback] DialogMonitor.Stop() : Dialog monitoring is being halted.
[04/17 16:19:14,Telerik.TestStudio.RemoteExecutor.exe(900:14)] First trace message from background thread "Callback Listener Thread" (managed ID = 14, native ID = 6104).
[04/17 16:19:14,Telerik.TestStudio.RemoteExecutor.exe(900:14),Execution] TestPlatform.FinishTestRunAndPublishResultsAsync() : Finished running test platform - attempting publish
0
Hi Adrian,
Thank you for getting back with the requested details.
Based on the given logs, it appears that the execution machine does not have installed neither Microsoft excel, neither Microsoft Access Database Engine, hence cannot open the excel file to read the data.
"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."
As described in this article, install Microsoft Access Database Engine and the data driven tests should run smoothly.
Let me know if this works for you.
Kind Regards,
Stoyan