Failure during SQL configuration. There was an error reading from the pipe: Unrecognized error 109 (0x6d).
search cancel

Failure during SQL configuration. There was an error reading from the pipe: Unrecognized error 109 (0x6d).

book

Article ID: 196184

calendar_today

Updated On: 12-02-2024

Products

IT Management Suite

Issue/Introduction

In this particular scenario, you are trying to upgrade from ITMS 8.5 RU3 to RU4.
Symantec Installation Manager (SIM) is having a hard time configuring the database. It fails with error:


Configuration failed.
A critical error occurred:
The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.

Configuration failed while attempting: Configuring database...

During configuration, under "Processing SQLs from 'C:\Program Files\Altiris\Notification Server\Config\CoreSolution.config'", this error occurs:

Failure during SQL configuration:
There was an error reading from the pipe: Unrecognized error 109 (0x6d).
[System.ServiceModel.CommunicationException @ mscorlib]

Server stack trace:
at System.ServiceModel.Channels.StreamConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)
at System.ServiceModel.Channels.SessionConnectionReader.Receive(TimeSpan timeout)
at System.ServiceModel.Channels.SynchronizedMessageSource.Receive(TimeSpan timeout)
at System.ServiceModel.Channels.TransportDuplexSessionChannel.Receive(TimeSpan timeout)
at System.ServiceModel.Channels.TransportDuplexSessionChannel.TryReceive(TimeSpan timeout, Message& message)
at System.ServiceModel.Dispatcher.DuplexChannelBinder.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at ReflectionProxy.IReflectionProxy.InstallSqlClassNodes(String configFile, Boolean installClasses)
at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL()

The read operation failed, see inner exception.
[System.IO.IOException @ System]
at System.Net.Security.NegotiateStream.ProcessRead(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security.NegotiateStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.ServiceModel.Channels.StreamConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)

There was an error reading from the pipe: Unrecognized error 109 (0x6d).
[System.ServiceModel.CommunicationException @ System.ServiceModel]
at System.ServiceModel.Channels.PipeConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)
at System.ServiceModel.Channels.DelegatingConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)
at System.ServiceModel.Channels.ConnectionStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.Net.FixedSizeReader.ReadPacket(Byte[] buffer, Int32 offset, Int32 count)
at System.Net.Security.NegotiateStream.StartFrameHeader(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security.NegotiateStream.ProcessRead(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)

There was an error reading from the pipe: Unrecognized error 109 (0x6d).
[System.IO.PipeException @ System.ServiceModel]
at System.ServiceModel.Channels.PipeConnection.FinishSyncRead(Boolean traceExceptionsAsErrors)
at System.ServiceModel.Channels.PipeConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)

Exception logged from:
at Symantec.Installation.Logging.LogActivity.ReportException(Int32 severity, String strMessage, String category, Exception exception, String footer)
at Symantec.Installation.Logging.LogActivity.ReportException(String strMessage, String category, Exception exception)
at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL()
at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.<StartImpl>d__5.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.StartImpl()
at Symantec.Installation.NSConfiguration.Tasks.SerialTask.<Start>d__0.MoveNext()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()

-----------------------------------------------------------------------------------------------------
Process: SymantecInstallationManager (5404), Thread ID: 11, Module: SymantecInstallationManager.exe
Priority: 1, Source: Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL

which few seconds later leads to:

Failure during SQL configuration:
The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.
[System.ServiceModel.CommunicationObjectFaultedException @ mscorlib]

Server stack trace:
at System.ServiceModel.Channels.CommunicationObject.ThrowIfDisposedOrNotOpen()
at System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at ReflectionProxy.IReflectionProxy.InstallSqlClassNodes(String configFile, Boolean installClasses)
at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL()

Exception logged from:
at Symantec.Installation.Logging.LogActivity.ReportException(Int32 severity, String strMessage, String category, Exception exception, String footer)
at Symantec.Installation.Logging.LogActivity.ReportException(String strMessage, String category, Exception exception)
at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL()
at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.<StartImpl>d__5.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.StartImpl()
at Symantec.Installation.NSConfiguration.Tasks.SerialTask.<Start>d__0.MoveNext()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()

-----------------------------------------------------------------------------------------------------
Process: SymantecInstallationManager (5404), Thread ID: 9, Module: SymantecInstallationManager.exe
Priority: 1, Source: Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL

 

Note: ITMS 8.6, 8.7

Regarding this error:

There was an error reading from the pipe: The pipe has been ended. (109, 0x6d).

This can happen on any other recent versions as well, especially during an upgrade while trying to configure the database portion:

Entry 1:

Failure during SQL configuration:
There was an error reading from the pipe: The pipe has been ended. (109, 0x6d).
   [System.ServiceModel.CommunicationException @ mscorlib]

Server stack trace: 
   at System.ServiceModel.Channels.StreamConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)
   at System.ServiceModel.Channels.SessionConnectionReader.Receive(TimeSpan timeout)
   at System.ServiceModel.Channels.SynchronizedMessageSource.Receive(TimeSpan timeout)
   at System.ServiceModel.Channels.TransportDuplexSessionChannel.Receive(TimeSpan timeout)
   at System.ServiceModel.Channels.TransportDuplexSessionChannel.TryReceive(TimeSpan timeout, Message& message)
   at System.ServiceModel.Dispatcher.DuplexChannelBinder.Request(Message message, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at ReflectionProxy.IReflectionProxy.InstallSqlClassNodes(String configFile, Boolean installClasses)
   at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL()

The read operation failed, see inner exception.
   [System.IO.IOException @ System]
   at System.Net.Security.NegotiateStream.ProcessRead(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.NegotiateStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.ServiceModel.Channels.StreamConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)

There was an error reading from the pipe: The pipe has been ended. (109, 0x6d).
   [System.ServiceModel.CommunicationException @ System.ServiceModel]
   at System.ServiceModel.Channels.PipeConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)
   at System.ServiceModel.Channels.DelegatingConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)
   at System.ServiceModel.Channels.ConnectionStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.Net.FixedSizeReader.ReadPacket(Byte[] buffer, Int32 offset, Int32 count)
   at System.Net.Security.NegotiateStream.StartFrameHeader(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.NegotiateStream.ProcessRead(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)

There was an error reading from the pipe: The pipe has been ended. (109, 0x6d).
   [System.IO.PipeException @ System.ServiceModel]
   at System.ServiceModel.Channels.PipeConnection.FinishSyncRead(Boolean traceExceptionsAsErrors)
   at System.ServiceModel.Channels.PipeConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)

Exception logged from: 
   at Symantec.Installation.Logging.LogActivity.ReportException(Int32 severity, String strMessage, String category, Exception exception, String footer)
   at Symantec.Installation.Logging.LogActivity.ReportException(String strMessage, String category, Exception exception)
   at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL()
   at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.<StartImpl>d__5.MoveNext()
   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.StartImpl()
   at Symantec.Installation.NSConfiguration.Tasks.SerialTask.<Start>d__0.MoveNext()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()


-----------------------------------------------------------------------------------------------------
Process: SymantecInstallationManager (9316), Thread ID: 16, Module: SymantecInstallationManager.exe
Priority: 1, Source: Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL

Entry 2:

Failure during SQL configuration:
The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.
   [System.ServiceModel.CommunicationObjectFaultedException @ mscorlib]

Server stack trace: 
   at System.ServiceModel.Channels.CommunicationObject.ThrowIfDisposedOrNotOpen()
   at System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at ReflectionProxy.IReflectionProxy.InstallSqlClassNodes(String configFile, Boolean installClasses)
   at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL()

Exception logged from: 
   at Symantec.Installation.Logging.LogActivity.ReportException(Int32 severity, String strMessage, String category, Exception exception, String footer)
   at Symantec.Installation.Logging.LogActivity.ReportException(String strMessage, String category, Exception exception)
   at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL()
   at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.<StartImpl>d__5.MoveNext()
   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   at Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.StartImpl()
   at Symantec.Installation.NSConfiguration.Tasks.SerialTask.<Start>d__0.MoveNext()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()


-----------------------------------------------------------------------------------------------------
Process: SymantecInstallationManager (9316), Thread ID: 11, Module: SymantecInstallationManager.exe
Priority: 1, Source: Symantec.Installation.NSConfiguration.Tasks.InstallSQLTask.InstallSQL

Environment

ITMS 8.5 RU4, 8.6, 8.7

Cause

Known issue. It was caused by pipe termination on idle timeout. 10 minutes is a default timeout. We set 60 minutes in SIM but proxy side configures pipe with default 10 minutes.
We updated ReflectionProxy.exe with 60 minutes idle timeout configured. 

ITMS 8.6, 8.7

We noted that NetPipeActivator service was also failing to start.

This matter was escalated to Microsoft by the customer and addressed by updating .NET which effectively resolved problem with SIM and pipe error.

Resolution

A fix has been added to our SIM next release (Post-8.5 RU4). Make sure you have the most recent version of SIM.

There is a workaround only available for ITMS 8.5 RU4 (SIM version 8.5.5701):

Please download the file called "ReflectionProxy.zip" attached to this article.

On your SMP server (the one that you are upgrading to ITMS 8.5 RU4),
1. Make sure SIM is not open.
2. go to "...\Program Files\Altiris\Symantec Installation Manager".
3. Rename the existing file to "ReflectionProxy.exe_old".
4. Place the new one that you downloaded.
5. Start SIM.
6. Run a reconfigure (SIM>Repair Installed Products>Reconfigure Installed Products)

This updated "ReflectionProxy.exe" should avoid the 10min time out that our proxy portion has.

ITMS 8.6, 8.7

As a workaround, the customer ran a repair using SIM when the upgrade failed and the repair successfully upgraded the SMP server without the mentioned original error.

Attachments

ReflectionProxy.zip get_app