Solved

SAP ByDesign Connection suddenly stopped working

  • 4 August 2020
  • 1 reply
  • 26 views

Hi Guys, 

I had an ODX connection to a SAP ByDesign instance that suddenly stopped at the end of last week and spit out the below error log. I am looking for any ideas on the direction to go. From how I am reading the error, I am assuming its originating at the ByDesign end, and I need to find a location to whitelist DiscoveryHub. (doesn't explain why it was working then suddenly not working without any other changes).

 

Thanks for any help.

 

 

If you need assistance, please submit this with your ticket.

Service request failed: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> rds190C.vX: HTTP protocol error. 401 Unauthorized. ---> rds190C.vX: HTTP protocol error. 401 Unauthorized. ---> rds190C.IX: HTTP protocol error. 401 Unauthorized.
at rds190C.ERZ.q(String , String , FR , ERk , String , Boolean , String )
at rds190C.ERZ.o(Boolean )
at rds190C.FZZ.K(WDn )
at rds190C.WaZ.q(Wg , WDt )
at rds190C.WaZ.A(Wg , Wan )
--- End of inner exception stack trace ---
at rds190C.WaZ.A(Wg , Wan )
at rds190C.Wan.T(WlC , WDC , Dh , WDC , WDC , String )
at rds190C.Wan.W(Wg , WDC , Dh , WDC , WDC )
at rds190C.WDt.R(String , Wg , Wap , jC )
at rds190C.WDt.sN(Wg , Wap , jC )
at rds190C.FZt.h(WDn )
at rds190C.WaZ.q(Wg , WDt )
at rds190C.WaZ.A(Wg , Wan )
--- End of inner exception stack trace ---
at rds190C.Wkk.k(vX , Wan )
at rds190C.Wkk.u(Wkk , Wan )
at rds190C.Wkk.mw(Wan )
at rds190C.Wkk.mw(Wan )
at rds190C.WQD.mK(Wan )
at rds190C.hp.h(WDn , hY )
at rds190C.kt.DU()
at rds190C.kM.DU()
at rds190C.hZ.O(SQLQuery , QueryParameterCollection , Int32 , Object , WoR , Int32 , jk )
at rds190C.ka.TestConnection()
at rds190C.kl.TestConnection()
at rds190C.pR.TestConnection()
at rds190C.UR.TestConnection()
at rds190C.gR.b()
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at DataSourceEngine.CData.CDataSourceEngine.<TestConnection>b__26_0()
at DataSourceEngine.CData.CDataSourceEngine.TestConnection()

Details:

Service request failed: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> rds190C.vX: HTTP protocol error. 401 Unauthorized. ---> rds190C.vX: HTTP protocol error. 401 Unauthorized. ---> rds...
Module: TimeXtender.ODX.Engine
TimeXtender.ODX.Engine.ODXFaultException
at TimeXtender.ODX.Engine.ODXEngine.SendServiceRequest[C](WcfServerSettings serverSettings, ProjectInformation projectInformation, Action`2 action)
at TimeXtender.ODX.Engine.DataSourceController`1.TestConnection(DataSourceModel dataSourceModel)
at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy)

Service request failed: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> rds190C.vX: HTTP protocol error. 401 Unauthorized. ---> rds190C.vX: HTTP protocol error. 401 Unauthorized. ---> rds...
Module: timeXtender
TimeXtender.DataManager.ExceptionWrapperException
at TimeXtender.DataManager.ConnectingThread.HandleError()
at TimeXtender.DataManager.ConnectingThread.Execute(String title, Int32 progressSteps, List`1 actions)
at TimeXtender.DataManager.ConnectingThread.ExecuteFastAction(String title, Action action, IWin32Window parentForm, CancelBehaviors cancelBehavior, ErrorBehaviors errorBehavior, String callerName)
at TimeXtender.DataManager.AddEditODXDataSourceCDataCommand.Dialog_TestConnection(Object sender, EventArgs e)

Time: 2020-07-30 22:34:43
UTC: 2020-07-30 22:34:43
Title: CORP - TimeXtender 20.5.5.64
Application: 20.5.5.64
Repository: 20.5.5.64
SQL Server: Microsoft SQL Server 15.0.2070.41 NT x64
User: mbock
Domain: CARLISLE
OS: Microsoft Windows Server 2019 Datacenter
OS version: Microsoft Windows NT 6.2.9200.0
Machine name: DH-WORKSPACE
CPU count: 4
Build: 64 bit

icon

Best answer by Syed Yousuf 20 January 2023, 01:09

View original

1 reply

Userlevel 3
Badge +3

The “HTTP protocol error. 401 Unauthorized” points to an authentication issue.  Verify login credentials, URL used and whitelist IP address.  In addition, try the latest provider and TimeXtender components.

Reply