Microsoft Dynamics AX (Archived)

Microsoft Dynamics AX R2 can not publish online store

(0) Share

Report

Posted on by Irina Pivovarova

285

Hello,

I would appreciate any help on the issue that we are trying to resolve.

We have an issue with Online store publishing. What we have now: Sharepoint is deployed to on VM , while other contains Dynamics AX R2. Both VM(s) in Azure in a single domain. When we are trying to setup upload options for Sync Service messages, Dynamics throws the exceptions with following error messages:

Microsoft.Dynamics.Retail.StoreConnect.Request.SCMonitoring.SCMonitoringRequestHandlerException: Cannot find service information registry
At Microsoft.Dynamics.Retail.StoreConnect.Request.SCMonitoring.SCMonitoringRequestHandler.GetMessageDBConnectionString()
at Microsoft.Dynamics.Retail.StoreConnect.Request.SCMonitoring.SCMonitoringRequestHandler.UpdateMonitoringConfig(SCMonitoringConfigRequest configRequest)
Failed to send down config for Synch Service "AX2012 SYNC SERVICE PROFILE"

We have followed steps in instruction: http://msdn.microsoft.com/en-us/library/hh597264.aspx

But step 10 resulted in exceptions described above.

I would appreciate any of your suggestion how to publish online store.

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (1)

SergeyP 2,928 on at

Like (0)

Report

Hi Irina,

You are not using the VMs which were shipped by Microsoft and instead you have created your own VMs from scratch and you installed there AX and SP, right ?

Technically setting-up or not setting-up those upload options will not change anything in publishing behavior. So, I think you could skip sending The Configuration discussed in that document.That feature is needed only for investigation purposes, for instance, in case you think you experience issues with Sync Service you can upload messages' status (from Messages DB) into AX and then review them in AX's UI. But this is not the only option, you can also see the same status by directly looking into tables of Sync Service's messages DB.

So, if you don't setup the upload options now it will not prevent you from publishing.

If you still would like to set it up now let me ask several questions:

1. What happens if you click the "Test connection" button (in the Commerce Data Exchange: Synch Service profiles form)?

2. Could you please confirm that the values in the fields "Service name" and "Server name" (in the same form) are correct ? Service name should have the value you specified while setting up the Sync Service, to double check you can look into Windows Services->Microsoft Dynamics AX Commerce Data Exchange: Synch Service Settings AX2012R2A->Path to executable. At the very end it should have the service name, for instance you could have something like this:

C:\Program Files (x86)\Microsoft Dynamics AX\60\Commerce Data Exchange\Synch Service\bin\DbServer.exe =AX2012R2A

Was this reply helpful? Yes No
Irina Pivovarova 285 on at

Like (0)

Report

Hello Sergey,

We have fixed issue with sending Config. It appears that service name was different. Thank you for the hints.

But still Online shop can not be published.

When we Publish online store it goes from Draft status into In progress, but never finishes.

We've checked the Job status in Sharepoint (SP Central Administration -> Monitoring –> Timer Job status) and job [RetailPublishingJob] status always failed. It goes for 00:09 sec and fails with message: "No channel has been configured in Microsoft Dynamic AX"

But if you go to Microsoft Dynamic AX Online channel IS configured there.

Configuration is as following:

Name: Ax2012portal

Profile type: Sharepoint Online store

Profile Property:

Publishing site collection URL: http://ax2012portal:40003/sites/RetailPublishingPortal

Catalog site collection URL: http://ax2012portal:40005/sites/RetailProductCatalog

When I click Validate profile - "The channel profile is valid" message is shown

What else can cause Job Failure?

I would appreciate your help very much.

Irina.

Was this reply helpful? Yes No
SergeyP 2,928 on at

Like (0)

Report

This message: "No channel has been configured in Microsoft Dynamic AX" means that CRT DB doesn't have channel information. The fact that you see a channel in AX doesn't necessary mean it is available in CRT DB.

When you said that you published a channel, could you please confirm that you not only clicked Publish on a channel but also executed Created Actions and then executed the job A-1075-OC (only these actions will actually send the data from AX DB into CRT DB)?

Was this reply helpful? Yes No
Irina Pivovarova 285 on at

Like (0)

Report

Yes, Sergey,

We did exactly what you said. But still Job fails.

Any other ideas?

Irina.

Was this reply helpful? Yes No
SergeyP 2,928 on at

Like (0)

Report

1. Once you executed job A-1075-OC - did it show status (in the Scheduler jobs) Successful ... or Failed ... ?

2. Please look into the table [AxRetailSP].[dbo].[RETAILCHANNELCONFIGURATION], I expect it to be empty in your case. If it is then most likely Sync Service is misconfigured, to narrow that down please look into the following tables in Messages DB:

IncomingMessages

OutgoingMessages

while querying them you might want to order results by the PackageNo field in descending order to make sure that newest messages are on top. Successful messages should have Status 1, for others (if you have them) have a look into ServerMsg for possible errors.

In addition look for errors in the same folder where Sync Service was deployed, it has subfolder Logs where you should be able to find possible errors as well (I assume that you configured an appropriate logging level while setting up Sync Service).

Please also don't forget to look into standard Event Viewer for possible errors from Dynamics AX there.

Was this reply helpful? Yes No
Irina Pivovarova 285 on at

Like (0)

Report

After some magic, Job RetailPublishingJob started to fail with different error message (Object reference not set to an instance of the object.)

what we did: we changed parameters for products and prices parameters, added test connector as payment method, then deployed dataset.

we still have job fail but now message is different and duration of the job goes up to 10 secs rather then 9 prev time.

Was this reply helpful? Yes No
SergeyP 2,928 on at

Like (0)

Report

If you look into Event Viewer, or in SharePoint log file you should see there full stack trace of the exception - can you paste it here ?

Was this reply helpful? Yes No
Irina Pivovarova 285 on at

Like (0)

Report

Sergey, thank you so much for spending time on our issue.

here are errors that I copied from Even Viewer (Windows Logs > Application) from VM with Axapta:

//////////////////////////////////////////Error 1//////////////////////////////////////////////////////

System

- Provider

[ Name] AX2012SERVER

- EventID 0

[ Qualifiers] 0

Level 2

Task 1

Keywords 0x80000000000000

- TimeCreated

[ SystemTime] 2013-04-11T03:18:43.000000000Z

EventRecordID 967839

Channel Application

Computer ax2012server.corp.axapta.azure

Security

- EventData

[4/11/2013 - 3:18:43 AM] - SCMonitoring: Error: System.ServiceModel.CommunicationObjectFaultedException: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state. Server stack trace: at System.ServiceModel.Channels.CommunicationObject.Close(TimeSpan timeout) 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 System.ServiceModel.ICommunicationObject.Close(TimeSpan timeout) at System.ServiceModel.ClientBase`1.System.ServiceModel.ICommunicationObject.Close(TimeSpan timeout) at System.ServiceModel.ClientBase`1.Close() at System.ServiceModel.ClientBase`1.System.IDisposable.Dispose() at SCMonitoring.MessageUploader.UploadMessageToTS(DataSet messages) at SCMonitoring.MessageUploader.Run()

///////////////////////////Error2///////////////////////////////////////

- System

- Provider

[ Name] AX2012SERVER

- EventID 0

[ Qualifiers] 0

Level 2

Task 1

Keywords 0x80000000000000

- TimeCreated

[ SystemTime] 2013-04-11T03:18:43.000000000Z

EventRecordID 967838

Channel Application

Computer ax2012server.corp.axapta.azure

Security

- EventData

[4/11/2013 - 3:18:43 AM] - UploadMessageToTS: Error: Failed to upload messages to Transaction Service

Here are more errors from VM with Sharepoint.

The same Event Viewer (Application tab)

//////////Critical error///////////////////////

Microsoft-SharePoint Products-SharePoint Foundation

[ Guid] {6FB7E0CD-52E7-47DD-997A-241563931FC2}

EventID 6398

Version 15

Level 1

Task 12

Opcode 0

Keywords 0x4000000000000000

- TimeCreated

[ SystemTime] 2013-04-11T03:27:12.107029200Z

EventRecordID 42336

- Correlation

[ ActivityID] {EA94109C-F560-508B-3DEA-0A4B1BA09A41}

- Execution

[ ProcessID] 15836

[ ThreadID] 5808

Channel Application

Computer AX2012PORTAL.corp.axapta.azure

- Security

[ UserID] S-1-5-20

- EventData

string0 Microsoft.Dynamics.Retail.SP.CommonFeatures.RetailPublishingJob

string1 6e9950a6-e87f-4aa6-9a19-9c5c892af3b6

string2 Object reference not set to an instance of an object.

///////////////////////////Error///////////////////

- System

- Provider

[ Name] Dynamics AX Retail

- EventID 1

[ Qualifiers] 0

Level 2

Task 0

Keywords 0x80000000000000

- TimeCreated

[ SystemTime] 2013-04-11T03:27:11.000000000Z

EventRecordID 42334

Channel Application

Computer AX2012PORTAL.corp.axapta.azure

Security

- EventData

Failed to load connectors with following error Could not load file or assembly 'Microsoft.Dynamics.Retail.TestConnector, Version=6.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

////////////////Error///////////////////////////////

System

- Provider

[ Name] Dynamics AX Retail

- EventID 1

[ Qualifiers] 0

Level 2

Task 0

Keywords 0x80000000000000

- TimeCreated

[ SystemTime] 2013-04-11T03:27:11.000000000Z

EventRecordID 42335

Channel Application

Computer AX2012PORTAL.corp.axapta.azure

Security

- EventData

System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Dynamics.Commerce.Runtime.Services.PricingEngine.DiscountParameters.GetDiscountParameters(IPricingDataManager pricingDataManager) at Microsoft.Dynamics.Commerce.Runtime.Services.PricingService.Initialize(CommerceRuntime runtime) at Microsoft.Dynamics.Commerce.Runtime.CompositionLoader.Compose(CommerceRuntime runtime) at Microsoft.Dynamics.Commerce.Runtime.CommerceRuntime.Create(CommerceRuntimeConfiguration configuration, IRequestHandlerFactory factory) at Microsoft.Dynamics.Commerce.Runtime.CommerceRuntimeFactory.CreateCommerceRuntime(CommerceRuntimeConfiguration configuration, IRequestHandlerFactory factory) at Microsoft.Dynamics.Retail.SharePoint.Common.Utilities.CreateCommerceRuntimeInternal(String connectionString, Configuration appConfiguration) at Microsoft.Dynamics.Retail.SharePoint.Connector.PublishingEntry.Publish(Configuration appConfig, Guid destinationId)

All errors are very fresh. Last three repeats most of the time.

Thank you very much for your help!

Irina.

Was this reply helpful? Yes No
SergeyP 2,928 on at

Like (0)

Report

Looking at the NullReferenceException (in your message above) I suspect you are not using CU1 update, could you please confirm it?

If you go (in SP) to Central Administration->System Settings->Manage Farm Solutions

what packages are there?

Was this reply helpful? Yes No
Irina Pivovarova 285 on at

Like (0)

Report

Sergey,

here is what I have there:

Name Status Deployed To

commerceruntime.wsp Deployed Globally deployed.

commonfeatures.wsp Deployed Globally deployed.

contosodemodata.wsp Deployed Globally deployed.

retailjobs.wsp Deployed Globally deployed.

storefront.wsp Deployed http://server:40002/

Was this reply helpful? Yes No