ERROR

   Buen dia, al intentar facturar en un puesto me aparece "ERROR EN EL NIVEL DEL TRANSPORTE AL RECIBIR LOS RESULTADOS DEL SERVIDOR. (PROVIDER: SESSION PROVIDER, ERROR:19- NO SE PUEDE UTILIZAR LA CONEXION FISICA)

Y, en cuanto al CRM me sale 
"ERROR CARGANDO DATOS DEL CLIENTE. EXECUTEREADER REQUIERE UNA CONNECTION ABIERTA Y DISPONIBLE. EL ESTADO DE LA CONEXION ES CERRADA."

Exception :  Error en el nivel del transporte al recibir los resultados
del servidor. (provider: Session Provider, error: 19 - No se puede utilizar la
conexión física)

Server : PC\AXSQLEXPRESS

Number : -1

LineNumber : 0

Procedure : 

StackTrace :    en
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection, Action`1 wrapCloseInAction)

   en
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection, Action`1 wrapCloseInAction)

   en
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   en
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject
stateObj, UInt32 error)

   en
System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()

   en
System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()

   en
System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()

   en System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte&
value)

   en System.Data.SqlClient.TdsParser.TryRun(RunBehavior
runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj,
Boolean& dataReady)

   en
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

   en System.Data.SqlClient.SqlDataReader.get_MetaData()

   en
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean
forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)

   en
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async,
Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry,
SqlDataReader ds, Boolean describeParameterEncryptionRequest)

   en
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream, String method,
TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean&
usedCache, Boolean asyncWrite, Boolean inRetry)

   en
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream, String method)

   en
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String
method)

   en
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

   en
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

   en (Object )

   en
A.cfc9755a2b61504b6d61b3db50d7946d1.cceae7391979c52b4d11c5e82a867732e(Object
cabd2cdb7946dcb47ffd665069534d376)

   en
Axoft.Platform.DataAccess.SQL.SQLDataAccess.Get(String sql)

   en (Object , String )

   en A.c1088af18aa78cebcd1c91906a265e973.cceae7391979c52b4d11c5e82a867732e(Object
cabd2cdb7946dcb47ffd665069534d376, String cabd2cdb7946dcb47ffd665069534d376)

   en
Axoft.POS.DataAccess.Perfil.PerfilDataAccess.GetPerfilFacturacion(String
codigoPerfil)

   en (Object , String )

   en
A.cb9be4b9f3b4c70e8b1241a0b3822f1dd.cceae7391979c52b4d11c5e82a867732e(Object
cabd2cdb7946dcb47ffd665069534d376, String cabd2cdb7946dcb47ffd665069534d376)

   en
Axoft.POS.Common.ProcesosFactory.AgregarPerfilSeleccionado(IDAcceso idProceso,
String codigoPerfil)

   en
(Object , IDAcceso , String )

   en
A.c497d9a5b7ad9461580d1ef43cd560f00.cceae7391979c52b4d11c5e82a867732e(Object
cabd2cdb7946dcb47ffd665069534d376, IDAcceso c35818d618016a56ec3fde14f4b8a29f4,
String cb8230695fd5c6d4ab3734e3842425c71)

   en
Axoft.POS.Common.ProcesosFactory.SeleccionDePerfilVM_SelectedEvent(Object
sender, RequestSelectedEventArgs e)

   en (Object , Object ,
SeleccionDePerfilViewModelSelectedEventArgs )

   en A.c852d72c9fc24647fe93255577c294ef4.cceae7391979c52b4d11c5e82a867732e(Object
cabd2cdb7946dcb47ffd665069534d376, Object cabd2cdb7946dcb47ffd665069534d376,
SeleccionDePerfilViewModelSelectedEventArgs cabd2cdb7946dcb47ffd665069534d376)

   en
Axoft.POS.ViewModels.Perfil.SeleccionDePerfilViewModel.OnSelectedEvent()

   en (Object )

   en
A.c1d8f72ad904a9f551dc457d7b71175f2.c420befa439f6fea4638d926ce8c90de8(Object
cabd2cdb7946dcb47ffd665069534d376)

   en
Axoft.POS.ViewModels.Perfil.SeleccionDePerfilViewModel.SeleccionarPerfilCommandExecute(Object
param)

   en (Object , Object )

   en
A.cf73bf02ecd7a13cb806c795941f67144.c420befa439f6fea4638d926ce8c90de8(Object
cabd2cdb7946dcb47ffd665069534d376, Object c5496257e9b795aeb99dfaa756f861b7c)

   en
Axoft.POS.ViewModels.Perfil.SeleccionDePerfilViewModel.<get_SeleccionarPerfilCommand>b__59_0(Object
param)

   en (Object , Object )

   en
A.c29e61eee872e12dbae1d8ffbbeeb6000.cceae7391979c52b4d11c5e82a867732e(Object
cabd2cdb7946dcb47ffd665069534d376, Object cabd2cdb7946dcb47ffd665069534d376)

   en Axoft.Platform.Common.Commands.RelayCommand.Execute(Object
parameter)

   en
MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource
commandSource, Boolean userInitiated)

   en
System.Windows.Controls.Primitives.ButtonBase.OnClick()

   en System.Windows.Controls.Button.OnClick()

   en
System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs
e)

   en
System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender,
MouseButtonEventArgs e)

   en System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate
genericHandler, Object genericTarget)

   en
System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)

   en
System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target,
RoutedEventArgs routedEventArgs)

   en
System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs
args, Boolean reRaised)

   en
System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender,
RoutedEventArgs args, RoutedEvent newEvent)

   en System.Windows.UIElement.OnMouseUpThunk(Object
sender, MouseButtonEventArgs e)

   en
System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate
genericHandler, Object genericTarget)

   en
System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)

   en
System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target,
RoutedEventArgs routedEventArgs)

   en
System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs
args, Boolean reRaised)

   en System.Windows.UIElement.RaiseEventImpl(DependencyObject
sender, RoutedEventArgs args)

   en
System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)

   en
System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)

   en System.Windows.Input.InputManager.ProcessStagingArea()

   en
System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)

   en
System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)

   en
System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd,
InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y,
Int32 wheel)

   en
System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd,
WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)

   en System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr
hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)

   en MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32
msg, IntPtr wParam, IntPtr lParam, Boolean& handled)

   en MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object
o)

   en
System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback,
Object args, Int32 numArgs)

   en
System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate
callback, Object args, Int32 numArgs, Delegate catchHandler)

Autor	Mensaje Topic Buscar Opciones de tema Responder Crear tema Version imprimible Traducir Topic
S.ORRICO Perfil buscar Mensajes del usuario SinSoporte Unio: 22/Noviembre/2023 Localidad: SAN JUSTO Estado: Offline Puntos: 20	Opciones de Mensaje Responder Quote S.ORRICO Reportar Mensaje Gracias(0) Quote Responder Topic: ERROR Posteo: 13/Junio/2024 en 3:33pm
	Buen dia, al intentar facturar en un puesto me aparece "ERROR EN EL NIVEL DEL TRANSPORTE AL RECIBIR LOS RESULTADOS DEL SERVIDOR. (PROVIDER: SESSION PROVIDER, ERROR:19- NO SE PUEDE UTILIZAR LA CONEXION FISICA) Y, en cuanto al CRM me sale "ERROR CARGANDO DATOS DEL CLIENTE. EXECUTEREADER REQUIERE UNA CONNECTION ABIERTA Y DISPONIBLE. EL ESTADO DE LA CONEXION ES CERRADA." Exception : Error en el nivel del transporte al recibir los resultados del servidor. (provider: Session Provider, error: 19 - No se puede utilizar la conexión física) Server : PC\AXSQLEXPRESS Number : -1 LineNumber : 0 Procedure : StackTrace : en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) en System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) en System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) en System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() en System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() en System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() en System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) en System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) en System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() en System.Data.SqlClient.SqlDataReader.get_MetaData() en System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) en System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) en System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) en System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) en System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() en (Object ) en A.cfc9755a2b61504b6d61b3db50d7946d1.cceae7391979c52b4d11c5e82a867732e(Object cabd2cdb7946dcb47ffd665069534d376) en Axoft.Platform.DataAccess.SQL.SQLDataAccess.Get(String sql) en (Object , String ) en A.c1088af18aa78cebcd1c91906a265e973.cceae7391979c52b4d11c5e82a867732e(Object cabd2cdb7946dcb47ffd665069534d376, String cabd2cdb7946dcb47ffd665069534d376) en Axoft.POS.DataAccess.Perfil.PerfilDataAccess.GetPerfilFacturacion(String codigoPerfil) en (Object , String ) en A.cb9be4b9f3b4c70e8b1241a0b3822f1dd.cceae7391979c52b4d11c5e82a867732e(Object cabd2cdb7946dcb47ffd665069534d376, String cabd2cdb7946dcb47ffd665069534d376) en Axoft.POS.Common.ProcesosFactory.AgregarPerfilSeleccionado(IDAcceso idProceso, String codigoPerfil) en (Object , IDAcceso , String ) en A.c497d9a5b7ad9461580d1ef43cd560f00.cceae7391979c52b4d11c5e82a867732e(Object cabd2cdb7946dcb47ffd665069534d376, IDAcceso c35818d618016a56ec3fde14f4b8a29f4, String cb8230695fd5c6d4ab3734e3842425c71) en Axoft.POS.Common.ProcesosFactory.SeleccionDePerfilVM_SelectedEvent(Object sender, RequestSelectedEventArgs e) en (Object , Object , SeleccionDePerfilViewModelSelectedEventArgs ) en A.c852d72c9fc24647fe93255577c294ef4.cceae7391979c52b4d11c5e82a867732e(Object cabd2cdb7946dcb47ffd665069534d376, Object cabd2cdb7946dcb47ffd665069534d376, SeleccionDePerfilViewModelSelectedEventArgs cabd2cdb7946dcb47ffd665069534d376) en Axoft.POS.ViewModels.Perfil.SeleccionDePerfilViewModel.OnSelectedEvent() en (Object ) en A.c1d8f72ad904a9f551dc457d7b71175f2.c420befa439f6fea4638d926ce8c90de8(Object cabd2cdb7946dcb47ffd665069534d376) en Axoft.POS.ViewModels.Perfil.SeleccionDePerfilViewModel.SeleccionarPerfilCommandExecute(Object param) en (Object , Object ) en A.cf73bf02ecd7a13cb806c795941f67144.c420befa439f6fea4638d926ce8c90de8(Object cabd2cdb7946dcb47ffd665069534d376, Object c5496257e9b795aeb99dfaa756f861b7c) en Axoft.POS.ViewModels.Perfil.SeleccionDePerfilViewModel.<get_SeleccionarPerfilCommand>b__59_0(Object param) en (Object , Object ) en A.c29e61eee872e12dbae1d8ffbbeeb6000.cceae7391979c52b4d11c5e82a867732e(Object cabd2cdb7946dcb47ffd665069534d376, Object cabd2cdb7946dcb47ffd665069534d376) en Axoft.Platform.Common.Commands.RelayCommand.Execute(Object parameter) en MS.Internal.Commands.CommandHelpers.CriticalExecuteCommandSource(ICommandSource commandSource, Boolean userInitiated) en System.Windows.Controls.Primitives.ButtonBase.OnClick() en System.Windows.Controls.Button.OnClick() en System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e) en System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e) en System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget) en System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target) en System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) en System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) en System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent) en System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e) en System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget) en System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target) en System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs) en System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised) en System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args) en System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args) en System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted) en System.Windows.Input.InputManager.ProcessStagingArea() en System.Windows.Input.InputManager.ProcessInput(InputEventArgs input) en System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport) en System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel) en System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled) en System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) en MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) en MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o) en System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) en System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)