Filed under BPI
Tagged as BizTalk, SQL
I received the next message in the EventLog:
The following stored procedure call failed: " { call [dbo].[bts_UpdateMsgbox_BizTalkServerApplication]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server returned error string: "Warning: The join order has been enforced because a local join hint is used.;Warning: The join order has been enforced because a local join hint is used.;Duplicate key was ignored.".
It seems that when SQL Server is very busy, these errors can occur. I’m working with BizTalk Server 2009, SQL Server 2008 and Windows Server 2008. When I solved the performance problem, these messages disappeared.
Filed under BPI
Tagged as BizTalk, BPI, ESB, SQL
When I opened the ESB.Portal (BizTalk ESB Guidance 2.0) in Internet Explorer I ran into the next problem:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 27-3-2009 20:26:37
Event time (UTC): 27-3-2009 19:26:37
Event ID: f5247af6841e45349be4dbd365417ff9
Event sequence: 99
Event occurrence: 4
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/ESB.Portal-1-128826538435234595
Trust level: Full
Application Virtual Path: /ESB.Portal
Application Path: C:\projects\microsoft.practices.esb\Source\Samples\Management Portal\ESB.Portal\
Machine name: myMachine
Process information:
Process ID: 5752
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: SqlException
Exception message: 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: TCP Provider, error: 0 – No connection could be made because the target machine actively refused it.)
Request information:
Request URL: http://localhost/ESB.Portal/Lists/RegistrySummaryContainer.aspx
Request path: /ESB.Portal/Lists/RegistrySummaryContainer.aspx
User host address: ::1
User: myMachine\user
Is authenticated: Trueetc etc |
To fix this you must make sure your SQL connections are configured properly, like:
TCP/IP must be enabled!
