Skip to content
+1-888-319-3663

COMMUNITY FORUM

CRM-GP Map: CRM_CURR_BK error!

Tudor asked 8 years ago
I'm trying to implement SmartConnect and trying to use the CRM-GP templates available. All maps were run, however, the CRM_CURR_BK map returns an error.

"The exchange rate of the base currency cannot be modified. For entity 'transactioncurrency' where 'isocurrencycode=USD,' in organization 'orgname'.

I'm guessing this has to do with the fact that the CRM default currency is USD and the GP currency is Z-US$?

What can I do to solve this? Because of this issue the products and pricelists are created from GP into CRM but they are not lined, as in the products are not under a pricelist.

Thanks!
Tudor replied 8 years ago

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.

Lorren replied 8 years ago

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

Tudor replied 8 years ago

[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

Tudor replied 8 years ago

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.

Tudor replied 8 years ago

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.

Lorren replied 8 years ago

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

Tudor replied 8 years ago

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!

Tudor replied 8 years ago

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?

Tudor replied 8 years ago

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 :))

Tudor replied 8 years ago

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

Lorren replied 8 years ago

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

Tudor replied 8 years ago

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: 

"Web service call failed : Request for the permission of type 'System.Net.WebPermission, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."

Any idea what this could be? I will try to investigate this further today and see what I can come up with. I can access the web service URL without any issues and my account that I used for GP and CRM connectors has full permissions on this server. GP, CRM and SmartConnect are all on the same server.

Tudor replied 8 years ago

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

Mike replied 8 years ago

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!

Tudor replied 8 years ago

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!

Mike replied 8 years ago

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

Tudor replied 8 years ago

[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

Tudor replied 8 years ago

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?

Tudor replied 8 years ago

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:

RealTimeId                                                                                                                         TablePhysicalName
f187ed9e-c3b5-46cb-9a9a-a1e700ad01f3                                                                 SY03300
f187ed9e-c3b5-46cb-9a9a-a1e700ad01f3                                                                 SY03300
6ded0491-86af-4d70-9657-a1e700ad0205                                                                 SY03000
6ded0491-86af-4d70-9657-a1e700ad0205                                                                 SY03000
77fd89db-ba5d-482a-b91d-a1e700ad0205                                                                 IV00101
dd0d324b-f23d-4a68-a181-a1e700ad020f                                                                 RM00101
dd0d324b-f23d-4a68-a181-a1e700ad020f                                                                 RM00101
5bb7c5b0-cd2d-410f-ab80-a1e700ad020f                                                                 IV40800
5bb7c5b0-cd2d-410f-ab80-a1e700ad020f                                                                 IV40800
d2cd8a65-099e-42c1-83bb-a1e700ad021d                                                                 RM00102
d2cd8a65-099e-42c1-83bb-a1e700ad021d                                                                 RM00102
e57e0abe-aaeb-48e4-bfce-a1e700ad021d                                                                 RM00201
e57e0abe-aaeb-48e4-bfce-a1e700ad021d                                                                 RM00201
d8ff81f6-2676-4853-9092-a1e700ad022b                                                                 RM00303
d8ff81f6-2676-4853-9092-a1e700ad022b                                                                 RM00303
e8b302aa-d184-4d30-af51-a1e700ad0230                                                                 DYNAMICS.dbo.MC40200
e8b302aa-d184-4d30-af51-a1e700ad0230                                                                 DYNAMICS.dbo.MC40200
Tudor replied 8 years ago

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!

Mike replied 8 years ago

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?  

Tudor replied 8 years ago

[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.

Tudor replied 8 years ago

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.


If you would like to submit an answer or comment, please sign in to the eOne portal.