Biztalk/Integration Issues
I have set up multiple Biztalk integrations with Commerce Server all using PassThruTransmit and dropping in XML files. I am updating both the Catalogs (2 Catalogs) and Inventory. I have staggered the files so there is a delay in dropping them in Biztalk pick up directory. Also, the files are small in size.
I am getting an error message in the Event Viewer stating that a CatalogImport is currently in progress and that it will be retried. This eventually seems to fill up and hang the Biztalk Server ie suspend all importing. I have the Biztalk service to just retry 3 times. I also tried creating a job that deletes the Catalog Import Status in Commerce Server but all to no avail.
Any help would be greatly appreciated.
[778 byte] By [
Xcel] at [2008-1-9]
Once a document is "suspended" in BizTalk Server, you can open the BizTalk Administration Console and open the suspended instance to see the error that caused the document to suspend. If your BizTalk send port is setup to retry three times and then suspend, the event log message may also give you a clue as to why this is happening.
Post the actual error message from BizTalk or your event log and I'll try to help diagnose the issue.
Jeff Lynch
MVP Windows Server System - Commerce Server
http://codebetter.com/blogs/jeff.lynch
Jeff,
This issue creates 3 events in the Event Viewer as detailed below:
Event Type: Warning
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5743
Date: 8/20/2007
Time: 10:00:07 AM
User: N/A
Computer: ECOMMERCE1
Description:
The adapter failed to transmit message going to send port "CSInventoryImport" with URL "CommerceServerInventorySend://CSInventory/http://192.168.97.9/CatalogWebService/catalogwebservice.asmx". It will be retransmitted after the retry interval specified for this Send Port. Details:"Web Service call CommerceServerInventoryImport failed. Message: This operation cannot be performed because an import operation is currently in progress.. Stack ' at Microsoft.CommerceServer.ServiceAgent.TryHandleWebMethodException(Exception ex, SoapHttpClientProtocol serviceProxy)
at Microsoft.CommerceServer.Catalog.WebService.Proxies.CatalogWebService.AuthorizedInvoke(String methodName, Object[] parameters)
at Microsoft.CommerceServer.Catalog.WebService.Proxies.CatalogWebService.ImportInventoryXml(Guid token, InventoryImportOptions inventoryImportOptions)
at Microsoft.CommerceServer.Catalog.CatalogAgentContext.ImportXml(InventoryImportOptions importOptions, String fileName)
at Microsoft.CommerceServer.Inventory.InventoryContext.ImportXml(InventoryImportOptions importOptions, String fileName)
at Microsoft.CommerceServer.Adapter.Inventory.InventorySendBatch.Import(SendAdapterProperties properties, TransmitterMessage message, Boolean getResponse, IBaseMessage& responseMessage)'.".
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Error
Event Source: Commerce Server Inventory Send Adapter
Event Category: None
Event ID: 0
Date: 8/20/2007
Time: 10:00:07 AM
User: N/A
Computer: ECOMMERCE1
Description:
Web Service call CommerceServerInventoryImport failed. Message: This operation cannot be performed because an import operation is currently in progress.. Stack ' at Microsoft.CommerceServer.ServiceAgent.TryHandleWebMethodException(Exception ex, SoapHttpClientProtocol serviceProxy)
at Microsoft.CommerceServer.Catalog.WebService.Proxies.CatalogWebService.AuthorizedInvoke(String methodName, Object[] parameters)
at Microsoft.CommerceServer.Catalog.WebService.Proxies.CatalogWebService.ImportInventoryXml(Guid token, InventoryImportOptions inventoryImportOptions)
at Microsoft.CommerceServer.Catalog.CatalogAgentContext.ImportXml(InventoryImportOptions importOptions, String fileName)
at Microsoft.CommerceServer.Inventory.InventoryContext.ImportXml(InventoryImportOptions importOptions, String fileName)
at Microsoft.CommerceServer.Adapter.Inventory.InventorySendBatch.Import(SendAdapterProperties properties, TransmitterMessage message, Boolean getResponse, IBaseMessage& responseMessage)'.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type: Error
Event Source: Commerce Server Web Services
Event Category: None
Event ID: 1
Date: 8/20/2007
Time: 10:00:07 AM
User: N/A
Computer: ECOMMERCE1
Description:
An exception occurred in the 'CatalogWebService' Web service. Exception details follow:
System.Exception: This operation cannot be performed because an import operation is currently in progress.
Server stack trace:
at Microsoft.CommerceServer.Catalog.ICatalogImport.WebServiceImport(String siteName, Guid token, Boolean inventoryImport, String importOptionsXml, Boolean ignoreInventorySystem, String userName, String authorizationPolicyPath)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
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 Microsoft.CommerceServer.Catalog.ICatalogImport.WebServiceImport(String siteName, Guid token, Boolean inventoryImport, String importOptionsXml, Boolean ignoreInventorySystem, String userName, String authorizationPolicyPath)
at Microsoft.CommerceServer.Catalog.Internal.CatalogServerContextBase.Import(Guid token, ImportOptions importOptions)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
