Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Connected Services Framework >> Connected Services Framework

OHSBE Installation issue - OHSBE Monitor windows service generates database access exception.

Hi,

After installation of OH-SBE, when verifying the installation, OHSBE Monitor windows service generates following errors in eventlog:

The errors points out unautorirzed access to database as access to port is denied. It appears that some OHSBE component is trying to access OHSBE database and is denied the access.

I have OHSBE database installed in same syatem as OHSBE.

--
OHSBEMonitor service start up Error
--


Timestamp: 9/13/2006 4:59:33 PM
Message:
**********************************************
Exception Messages:
Type: Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.DatabaseException
Name: GetDBSettings
Nature: IsFailed
Type: System.TypeInitializationException
Name: System.TypeInitializationException
Nature: The type initializer for 'Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess' threw an exception.Type: System.UnauthorizedAccessException
Name: System.UnauthorizedAccessException
Nature: Access to the port is denied.
**********************************************

**********************************************
Detail Message Info:
Type: Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.DatabaseException
Name: GetDBSettings
Nature: IsFailed
Stack:
at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.SbeException.GetMesageInfo(StringBuilder& sbMessageParameters, StringBuilder& sbCompleteMessageInfo)
at Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.SbeException.get_Message()
at Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.SbeException..ctor(ExceptionParameter[] parameterList, Exception innerException)
at Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.DatabaseException..ctor(ExceptionParameter[] exceptionparams, Exception innerException)
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.Properties.Settings.GetDBSettings()
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.MonitorDBStatus.Poller()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Type: System.TypeInitializationException
Name: System.TypeInitializationException
Nature: The type initializer for 'Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess' threw an exception.Stack:
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess.GetSystemConfiguration(Int32& messageResponseTimeoutInMS, Int32& monitorDBPollFrequency, Int32& throttleInterval, String& sessionTemplateManifestFilename, Int32& getOrderListRecordCount, String& mastercontrollerUri, String& identityManagerUri, Int32& numberOfRecordsToProcessPerPoll, String& orderCancelRoleName, String& orderTerminateRoleName, Int32& performanceCounterTimerInterval, String& ohsbeAdminRole, String& ohsbePolicyName, String& serviceCatalogPolicyName, String& identityManagerPolicyName)
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.Properties.Settings.GetDBSettings()
Type: System.UnauthorizedAccessException
Name: System.UnauthorizedAccessException
Nature: Access to the port is denied.Stack:
at System.IO.Ports.InternalResources.WinIOError(Int32 errorCode, String str)
at System.IO.Ports.InternalResources.WinIOError()
at System.Threading.Semaphore..ctor(Int32 initialCount, Int32 maximumCount, String name)
at Microsoft.ConnectedServices.Sbe.OrderHandling.MasterController.Security.DataProtector..ctor(Store tempStore, String certName)
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess..cctor()

**********************************************

Category: General
Priority: 4
EventId: 10205
Severity: Error
Title:Exception
Machine: BLRKEC21593D
Application Domain: OHSBEMonitor.exe
Process Id: 2840
Process Name: C:\Program Files\Microsoft CSF\V3.0\OHSBE\OHSBE30\OHSBE Services\bin\OHSBEMonitor.exe
Win32 Thread Id: 3772
Thread Name:
Extended Properties:

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.


--
OHSBEMonitor service start up Error
--

Timestamp: 9/13/2006 4:59:33 PM
Message:
**********************************************
Exception Messages:
Type: Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.SbeException
Name: Poller
Nature:
**********************************************
Exception Messages:
Type: Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.DatabaseException
Name: GetDBSettings
Nature: IsFailed
Type: System.TypeInitializationException
Name: System.TypeInitializationException
Nature: The type initializer for 'Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess' threw an exception.Type: System.UnauthorizedAccessException
Name: System.UnauthorizedAccessException
Nature: Access to the port is denied.
**********************************************

**********************************************
Detail Message Info:
Type: Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.DatabaseException
Name: GetDBSettings
Nature: IsFailed
Stack:
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.Properties.Settings.GetDBSettings()
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.MonitorDBStatus.Poller()
Type: System.TypeInitializationException
Name: System.TypeInitializationException
Nature: The type initializer for 'Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess' threw an exception.Stack:
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess.GetSystemConfiguration(Int32& messageResponseTimeoutInMS, Int32& monitorDBPollFrequency, Int32& throttleInterval, String& sessionTemplateManifestFilename, Int32& getOrderListRecordCount, String& mastercontrollerUri, String& identityManagerUri, Int32& numberOfRecordsToProcessPerPoll, String& orderCancelRoleName, String& orderTerminateRoleName, Int32& performanceCounterTimerInterval, String& ohsbeAdminRole, String& ohsbePolicyName, String& serviceCatalogPolicyName, String& identityManagerPolicyName)
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.Properties.Settings.GetDBSettings()
Type: System.UnauthorizedAccessException
Name: System.UnauthorizedAccessException
Nature: Access to the port is denied.Stack:
at System.IO.Ports.InternalResources.WinIOError(Int32 errorCode, String str)
at System.IO.Ports.InternalResources.WinIOError()
at System.Threading.Semaphore..ctor(Int32 initialCount, Int32 maximumCount, String name)
at Microsoft.ConnectedServices.Sbe.OrderHandling.MasterController.Security.DataProtector..ctor(Store tempStore, String certName)
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess..cctor()

**********************************************


Type: Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.SbeException
Name: GetDBSettings
Nature: IsFailed

Type: System.TypeInitializationException
Name: System.TypeInitializationException
Nature: The type initializer for 'Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess' threw an exception.Type: System.UnauthorizedAccessException
Name: System.UnauthorizedAccessException
Nature: Access to the port is denied.
**********************************************

**********************************************
Detail Message Info:
Type: Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.SbeException
Name: Poller
Nature:
**********************************************
Exception Messages:
Type: Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.DatabaseException
Name: GetDBSettings
Nature: IsFailed
Type: System.TypeInitializationException
Name: System.TypeInitializationException
Nature: The type initializer for 'Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess' threw an exception.Type: System.UnauthorizedAccessException
Name: System.UnauthorizedAccessException
Nature: Access to the port is denied.
**********************************************

**********************************************
Detail Message Info:
Type: Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.DatabaseException
Name: GetDBSettings
Nature: IsFailed
Stack:
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.Properties.Settings.GetDBSettings()
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.MonitorDBStatus.Poller()
Type: System.TypeInitializationException
Name: System.TypeInitializationException
Nature: The type initializer for 'Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess' threw an exception.Stack:
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess.GetSystemConfiguration(Int32& messageResponseTimeoutInMS, Int32& monitorDBPollFrequency, Int32& throttleInterval, String& sessionTemplateManifestFilename, Int32& getOrderListRecordCount, String& mastercontrollerUri, String& identityManagerUri, Int32& numberOfRecordsToProcessPerPoll, String& orderCancelRoleName, String& orderTerminateRoleName, Int32& performanceCounterTimerInterval, String& ohsbeAdminRole, String& ohsbePolicyName, String& serviceCatalogPolicyName, String& identityManagerPolicyName)
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.Properties.Settings.GetDBSettings()
Type: System.UnauthorizedAccessException
Name: System.UnauthorizedAccessException
Nature: Access to the port is denied.Stack:
at System.IO.Ports.InternalResources.WinIOError(Int32 errorCode, String str)
at System.IO.Ports.InternalResources.WinIOError()
at System.Threading.Semaphore..ctor(Int32 initialCount, Int32 maximumCount, String name)
at Microsoft.ConnectedServices.Sbe.OrderHandling.MasterController.Security.DataProtector..ctor(Store tempStore, String certName)
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess..cctor()

**********************************************

Stack:
at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.SbeException.GetMesageInfo(StringBuilder& sbMessageParameters, StringBuilder& sbCompleteMessageInfo)
at Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.SbeException.get_Message()
at Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.SbeException..ctor(ExceptionParameter[] parameterList, Exception innerException)
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.MonitorDBStatus.Poller()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

Type: Microsoft.ConnectedServices.Sbe.OrderHandling.Exceptions.SbeException
Name: GetDBSettings
Nature: IsFailed

Stack:
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.Properties.Settings.GetDBSettings()
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.MonitorDBStatus.Poller()
Type: System.TypeInitializationException
Name: System.TypeInitializationException
Nature: The type initializer for 'Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess' threw an exception.Stack:
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess.GetSystemConfiguration(Int32& messageResponseTimeoutInMS, Int32& monitorDBPollFrequency, Int32& throttleInterval, String& sessionTemplateManifestFilename, Int32& getOrderListRecordCount, String& mastercontrollerUri, String& identityManagerUri, Int32& numberOfRecordsToProcessPerPoll, String& orderCancelRoleName, String& orderTerminateRoleName, Int32& performanceCounterTimerInterval, String& ohsbeAdminRole, String& ohsbePolicyName, String& serviceCatalogPolicyName, String& identityManagerPolicyName)
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMonitor.Service.Properties.Settings.GetDBSettings()
Type: System.UnauthorizedAccessException
Name: System.UnauthorizedAccessException
Nature: Access to the port is denied.Stack:
at System.IO.Ports.InternalResources.WinIOError(Int32 errorCode, String str)
at System.IO.Ports.InternalResources.WinIOError()
at System.Threading.Semaphore..ctor(Int32 initialCount, Int32 maximumCount, String name)
at Microsoft.ConnectedServices.Sbe.OrderHandling.MasterController.Security.DataProtector..ctor(Store tempStore, String certName)
at Microsoft.ConnectedServices.Sbe.OrderHandling.SbeMasterControllerDatabaseAccess..cctor()

**********************************************

Category: General
Priority: 4
EventId: 10201
Severity: Error
Title:Exception
Machine: BLRKEC21593D
Application Domain: OHSBEMonitor.exe
Process Id: 2840
Process Name: C:\Program Files\Microsoft CSF\V3.0\OHSBE\OHSBE30\OHSBE Services\bin\OHSBEMonitor.exe
Win32 Thread Id: 3772
Thread Name:
Extended Properties:

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

Can any body help me understand the cause of errors and how to resolve them?

Thanks,

Ashish Malhotra

[15417 byte] By [AshishMalhotra] at [2008-2-3]
«« Compiler related?
»» 3-pane explorer: docking existing split container in new split container
# 1

Hi Ashish,

Thanks for your note - I've been helping Vasu and yourself on a different forum - is your team still facing this issue? Please let me know...

After installation, the OHSBE WSE web service (http://localhost/OHSBE30/orderhandling.ashx) and the OHSBE Monitor Windows Service should both be running under the "DomainName\OHSBE-Service" account. The CSFOHSBE30 database, the OHSBE-Service account, and the application pool are all created by the CSF OHSBE 3.0 installer.

Here are some analysis steps:

(1) Have you encountered these issues only on one server, or have you tried another server?

(2) Is SQL Server hosted on the same machine as the OHSBE?

(3) Are you using SQL Server authentication, or Windows authentication? (By default, the OHSBE uses Windows authentication, and that's what we continue to recommend...)

(4) If you are still facing this issue, can you send me the Application, System, and OHSBE event logs?

Many Thanks, Ashish!!

-Rob.

Rob-MSFT at 2007-10-8 > top of Msdn Tech,Connected Services Framework,Connected Services Framework...
# 2

Hi Rob,

We continue to face issues with OHSBE. We have checked and confirm the following:

  1. OHSBE WSE web service (http://localhost/OHSBE30/orderhandling.ashx) and the OHSBE Monitor Windows Service both run under the "DomainName\OHSBE-Service" account.
  2. The CSFOHSBE30 database, the OHSBE-Service account, and the application pool are all created by the CSF OHSBE 3.0 installer.
  3. We have not tried this on multiple servers, We have tried on only one servre but many times now.
  4. SQL server is hosted on same machine as OHSBE.
  5. We are using default settings for database access and believe Windows authentocation is getting used.

I'll be sending you across the Application, System, and OHSBE event logs separately.

Thanks,

Ashish Malhotra

AshishMalhotra at 2007-10-8 > top of Msdn Tech,Connected Services Framework,Connected Services Framework...
# 3

Hi Rob,

We continue to face issues with OHSBE. We have checked and confirm the following:

1. OHSBE WSE web service (http://localhost/OHSBE30/orderhandling.ashx) and the OHSBE Monitor Windows Service both run under the "DomainName\OHSBE-Service" account.

2. The CSFOHSBE30 database, the OHSBE-Service account, and the application pool are all created by the CSF OHSBE 3.0 installer.

3. We have not tried this on multiple servers, We have tried on only one servre but many times now.

4. SQL server is hosted on same machine as OHSBE.

5. We are using default settings for database access and believe Windows authentocation is getting used.

I'll be sending you across the Application, System, and OHSBE event logs separately.

Thanks,

Ashish Malhotra

AshishMalhotra at 2007-10-8 > top of Msdn Tech,Connected Services Framework,Connected Services Framework...
Connected Services Framework

Connected Services Framework Hot Topic

Connected Services Framework

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified