COMMUNITY FORUM

One thing I should mention is that I am using CRM 2011 on premise, if that helps anything. Also note that the US Dollar currency in CRM with Currency Code USD is the base currency so I cannot delete or deactivate it.

Tudor,

Use a Tra

Here is the documentation online for how to do that.
http://doc.eonesolutions.com/SmartConnect/smartconnect_translation_table_column.htm

http://doc.eonesolutions.com/SmartConnect/

You can translate it from your GP currency to your CRM Currency.

Lorren

[quote=Lorren]Tudor,

Use a Tra

Here is the documentation online for how to do that.
http://doc.eonesolutions.com/SmartConnect/smartconnect_translation_table_column.htm

http://doc.eonesolutions.com/SmartConnect/

You can translate it from your GP currency to your CRM Currency.

Lorren[/quote]

Thanks Lorren, I managed to get it working without the Translation Table.

All maps were executed successfully. One more question, when I try to select the 'SmartConnect GP Invoice" button on an Order in CRM I see at the bottom left corner of the window it says "Error on page." but no other message and the invoice does not go to GP. What could I be doing wrong? Would it be due to the maps? (these are the sample template maps and there are no errors in any of them)

Thanks again

It looks like none of the Real-Time maps are working, when I create a new Account in CRM, no system job is created and, therefore, no customer in GP. The real time maps are all registered and restarted SmartConnect after doing this.

Nevermind my post above, Rea-Time maps are working but not the ones from CRM to GP, only GP to CRM. So for example, if I create a customer in GP it will be synced to CRM but not synced if I create a CRM account to GP. Any ideas? Maps are registered correctly CRM connector is set up.

Tudor,

You can look at the events in CRM

Go To Settings->System Jobs in CRM and look for eOne.SmartConnect Plugin Failures which should provide the error that is occuring.

If there is no failure there, then go to the machine that has the SmartConnect Web Service installed and look at the SmartConnect Event Log.  This would mean the Plugin is firing but the map is erroring.

Lorren

Thanks Lorren. In CRM I am not able to see any System Jobs for eOne….none failed and none successful. 

I came across this http://www.eonesolutions.com/Support/Knowledge-Base/Knowledge-Base-Article.aspx?articleid=206 and saw that 

"Check “Real Time Data Source Setting Section” to see if you have the correct Web Service set:
Note:
 – Only the HTTP and HTTPS protocols are allowed.
 – Access to local host is not permitted.
 – IP addresses cannot be used. You must use a named Web address that requires DNS name resolution."

I noticed in the CRM 2011 Connector setup that the Call Back Web Service is using 'localhost' in the URL. I tried changing it to the server name, saving, and running maintenance but it always resets back to localhost after. Could this be why the CRM real time maps are not working?

Thanks!

Ok I finally got something to happen, it is now creating system jobs, I tried creating an account in CRM and it creates the system job for account Create but it does not complete, just stays in 'Waiting for Resources status', is this to do with GP or CRM resources?

Ok, I got that working, turns out the Asynchronous CRM Service stopped, restarted it and its good to go, the System Jobs are now 'Succeeded' BUT in GP I cannot get to the Customers screen, it keep freezing each time I try to access it to see if the new customer has been added, tried querying the table as well and no new customer was created there. Any ideas?

(sorry I keep replying, but as I work through small issues I might as well update you with the new one :))

Hi Lorren,

I have the CRM System Jobs completing successfully, however, nothing is being pushed to GP. I have enabled the debugging and logging for the GP_ACC_RT map (pushes a CRM Account to GP) but nothing is logged and the map has no Last Run Date. I'm not too sure what could be going on.

I double checked the web service link in the Connector for both GP and CRM and they are both set to the server name with SmartConnect rather than LocalHost. Any idea why the real time map is not being triggered or where I can see more information about the error (if there is one)??

Thanks

Tudor,

Go to the machine that has the Smart Connect web service loaded and look at the Smart Connect Event Viewer.  That will show the error it is getting trying to send the data to Smart Connect.

You may want to look at the eConnect Event Log and/or the Application Event Log

Lorren

Thanks Lorren! I checked the Event Viewer and I see no errors related to SmartConnect, under either Application, eConnect, and I have no SmartConnect log under Applications and Services Logs. 

However, I now have the System Job failing in CRM with the following error: 

I tried another account with all of the fields which are mapped in GP_ACC_RT filled in and it is successful in CRM System Jobs but still no accounts created in GP. 

Again, there is no error in the Event Viewer for either Application or eConnect. I'm not sure where else I can look to track down the issue.

Thanks again for the help with this!
Tudor

Hi Tudor,
  I have seen this issue before and found it was related to the web service path in the SmartConnect setup being incorrect.  It was pointing to the wrong location and even when changing it, it was not saving to the DB.  I was on with support when this was discovered and they made a change to a sql table on the backend that I dont recall the name of.  Maybe with this information, they can offer this information to see if this corrects your issue.

Good luck!

Thanks Mike. When you were having this issue was it the Web Service URL under the Web Service tab in SmartConnect Setup? Or was it under one of the Connectors? (CRM/GP)

I can navigate to the Web Service URL which is: http://BSSI-CRM-TEST:5556/SmartConnect/SmartConnect.asmx

I have the same Web Service URL under the GP Connector, however, the CRM connector Call Back Web Service is http://localhost:5556/SmartConnect/SmartConnect.asmx, so the change is that its not using the server name, rather using 'localhost'.

I can navigate to the localhost URL as well, and I know they are technically the same but according to another forum post, 'localhost' is not allowed? but the Setup will not allow me to change it. I change the URL to servername instead of 'localhost' and as soon as I click save, it goes back to 'localhost' if I re-open it….could this be the issue?

Thanks!

Yes this is the same experience I received.  Unfortunately, I dont know the table that we updated to correct the issue.  Once we set the correct URL in the DB and restarted the services, all the lights came on as expected.

Thanks
Mike

[quote=Mike]Yes this is the same experience I received.  Unfortunately, I dont know the table that we updated to correct the issue.  Once we set the correct URL in the DB and restarted the services, all the lights came on as expected.

Thanks
Mike[/quote]

Thanks Mike! Maybe Lorren can fill me in on which table it is that needs modifying.

I gave it a shot in our test environment by editing the MsCrm2011Connector and changing the WebUrl but that keeps getting changed to localhost again so maybe its a different table?

Tudor

Came across this today and tried following it but I can't edit the .dll and have no entry in the Registry for SmartConnect. 

http://www.eonesolutions.com/Support/Knowledge-Base/Knowledge-Base-Article.aspx?articleid=135

Any other ways to change the web service URL?

Also tried what this post (http://www.eonesolutions.com.au/Support/Knowledge-Base/Knowledge-Base-Article.aspx?articleid=207) mentions in point #4 and got this:

I've managed to change the web service URL so it no longer points to localhost and rather the server name. I am still getting a successful system job in CRM, but no data is transferred to GP.

I also don't see any errors in the Event Viewer under Application and I don't have a SmartConnect section to check. It seems the map does not even run, since its Last Run Date in SmartConnect is blank. Any ideas? It is registered on Update/Create and I ran the setup/maintenance already.

Thanks!

Here are my initial thoughs.  Hope they help.

Does the URL include localhost or did you swap in the true path?  
Did you test the SmartConnect web service directly?
Did you unregister/register the map and restart?  

[quote=Mike]Here are my initial thoughs.  Hope they help.

Does the URL include localhost or did you swap in the true path?  
Did you test the SmartConnect web service directly?
Did you unregister/register the map and restart?  [/quote]

The URL is now pointing to the true path of the web service, not localhost. I just ran a map directly from the web service and it was successful. Mind you, this is not the same map that is giving me problems, as that one is a real time map and won't have data if its run from web service…

I did unregister/regeister the map and restarted both GP and SmartConnect and still nothing. I just restarted the whole machine now, and I'm now getting an error in the Event Viewer.

"GP_ACC_RT: Access to the path 'C:UserscrmdemoadminDesktopSmartConnect LogsGP_ACC_RT_1_1.xml' is denied." – going to look into this one now.

Fixed the error message, turns out I had eConnect version 10 installed rather than 11. Installed 11 and now no errors appear in Event Viewer. Again it is successful in CRM but the customer never makes it to GP, tried restarting everyihtng including the machine again.

GP to CRM real time customer map works without any issues, just not CRM to GP.