Hi all,
I have a problem with BAM database. When we access BAM ****tal we obtain
the
following error:
"Server Error in '/BAM' Application.
________________________________________
System.Web.Services.Protocols.SoapException: There are instances with
duplicate ID '10094870_1.1' in activity 'O2CProcessActivity'. The
duplicates
must be removed from the database to fix this problem.
at
Microsoft.BizTalk.Bam.WebServices.Query.BamQueryService.GetInstanceData(String
viewName, String activityName, InstanceQuery query, Int32 timeout)
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.
Exception Details: System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: There are instances with
duplicate ID '10094870_1.1' in activity 'O2CProcessActivity'. The
duplicates
must be removed from the database to fix this problem.
at
Microsoft.BizTalk.Bam.WebServices.Query.BamQueryService.GetInstanceData(String
viewName, String activityName, InstanceQuery query, Int32 timeout)
Source Error:
An unhandled exception was generated during the execution of the current
web
request. Information regarding the origin and location of the exception
can
be identified using the exception stack trace below.
Stack Trace:
[SoapException: System.Web.Services.Protocols.SoapException: There are
instances with duplicate ID '10094870_1.1' in activity
'O2CProcessActivity'.
The duplicates must be removed from the database to fix this problem.
at
Microsoft.BizTalk.Bam.WebServices.Query.BamQueryService.GetInstanceData(String
viewName, String activityName, InstanceQuery query, Int32 timeout)]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)
+533462
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +204
Microsoft.BizTalk.Bam.WebServices.QueryService.BamQueryService.GetInstanceData(String
viewName, String activityName, InstanceQuery query, Int32 timeout) +111
Microsoft.BizTalk.Bam.****tal.DataAccess.QueryResultsObjectDataSource.ExecuteQuery(SQLQuery
query) +47
Microsoft.BizTalk.Bam.****tal.DataAccess.QueryResultsObjectDataSource.EnsureData(SQLQuery
query) +111
Microsoft.BizTalk.Bam.****tal.DataAccess.QueryResultsObjectDataSource.QueryResults(SQLQuery
query) +5
BAM****tal.Search_aspx.ExecuteQuery() +101
BAM****tal.Search_aspx.executeQueryButton_Click(Object sender,
CommandEventArgs e) +15
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String
eventArgument)
+163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+174
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
________________________________________
Version Information: Microsoft .NET Framework Version:2.0.50727.832;
ASP.NET
Version:2.0.50727.832"
I know it means that there are instances with duplicate ID in the activity
we were searching (we have introduced some duplicate activities when we
have
loaded a lot of hystorical data into the system).
I suppose the only way to solve the problem is to restore a backup copy of
BAM database (but it is time consuming because we need to reload all the
data
we have already in BAM database) in fact I haven't found any way to delete
the activity that is causing the error using BAM API.
Can someone help me out with this problem avoiding to restore a backup
copy
of the database not corrupted?
Thanks.
Regards,
Alessio
Alessio Lorefice
Avanade - Italy | cell +39 3489590297 | email alessiol@[EMAIL PROTECTED]
|
instant
messaging a.lorefice@[EMAIL PROTECTED]
|
