Symptoms
When starting k2 blackpearl service it cannot connect to the sql server database
Diagnoses
When the K2 blackpearl service is started it is getting an error saying that it cannot connect to the sql server database.
Here is what has happened:
We have moved the K2 server and the sql server database server to a new datacenter.
The ip address of both of these has changed but the server names have not changed.
Here is one of the errors (there are others) that I'm seeing in the Event Log:
Log Name: Application
Source: SourceCode.Logging.Extension.EventLogExtension
Date: 8/26/2015 2:14:28 PM
Event ID: 63004
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: dlx.denallix.com
Description:
63004 Failed to compose object: System.ComponentModel.Composition.CompositionException: The composition produced a single composition error. The root cause is provided below. Review the CompositionException.Errors property for more detailed information.
1) A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Resulting in: An exception occurred while calling the 'OnImportsSatisfied' method on type 'SourceCode.MessageBus.SmartActions.SmartActionListener'.
Resulting in: Cannot activate part 'SourceCode.MessageBus.SmartActions.SmartActionListener'.
Element: SourceCode.MessageBus.SmartActions.SmartActionListener --> SourceCode.MessageBus.SmartActions.SmartActionListener --> DirectoryCatalog (Path='D:Program Files (x86)K2 blackpearlHost ServerBinExtensionsSmartActions')
Resulting in: Cannot get export 'SourceCode.MessageBus.SmartActions.SmartActionListener (ContractName='SourceCode.MessageBus.IMessageListener')' from part 'SourceCode.MessageBus.SmartActions.SmartActionListener'.
Element: SourceCode.MessageBus.SmartActions.SmartActionListener (ContractName='SourceCode.MessageBus.IMessageListener') --> SourceCode.MessageBus.SmartActions.SmartActionListener --> DirectoryCatalog (Path='D:Program Files (x86)K2 blackpearlHost ServerBinExtensionsSmartActions')
Resulting in: An exception occurred while calling the 'OnImportsSatisfied' method on type 'SourceCode.MessageBus.Server.MessageBusRuntime'.
Resulting in: Cannot activate part 'SourceCode.MessageBus.Server.MessageBusRuntime'.
Element: SourceCode.MessageBus.Server.MessageBusRuntime --> SourceCode.MessageBus.Server.MessageBusRuntime
Server stack trace:
at System.ComponentModel.Composition.CompositionResult.ThrowOnErrors(AtomicComposition atomicComposition)
at System.ComponentModel.Composition.Hosting.ComposablePartExportProvider.Compose(CompositionBatch batch)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Objectc] args, Object server, Objectc]and outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
Exception rethrown at t0]:
at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageDataand msgData)
at System.Action`3.EndInvoke(IAsyncResult result)
at SourceCode.Server.Extensibility.CompositionExtensions.EndComposePartsInternal(IAsyncResult result)
Event Xml:
63004
2
0
0x80000000000000
2190016
Application
dlx.denallix.com
63004 Failed to compose object: System.ComponentModel.Composition.CompositionException: The composition produced a single composition error. The root cause is provided below. Review the CompositionException.Errors property for more detailed information.
1) A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Resulting in: An exception occurred while calling the 'OnImportsSatisfied' method on type 'SourceCode.MessageBus.SmartActions.SmartActionListener'.
Resulting in: Cannot activate part 'SourceCode.MessageBus.SmartActions.SmartActionListener'.
Element: SourceCode.MessageBus.SmartAc
Resolution
The issue was resolved after testing/confirming the "SQL serverInstance,Port" and performing a K2 blackpearl Setup Manager > Reconfigure with this value.
