Sage 300 ERP integration with CRM

A client is running Sage 300 2012 with CRM integration. The site had been stable until December 16th and now throughout the day, when using CRM and doing the drill down into All Orders from the O/E Inquiry and clicking the Drill Down to show the custom page the user will get an error stating :

Could Not Find the Sage 300 ERP O/E Files

Error returned: Internal error unable to use PO ini file  (12547 OEORDH1.C)

However, if you access the Portal via IE it is running.  To date, the solution has been to restart Tomcat but that solution will last maybe 5 minutes before it happens again and again throughout the day.

Sage 2012 PU 3 installed, CRM 7.2c.

Any ideas before we reinstall. 

  • 0

    Hi Lloyd,

    The 'All Orders' Drill Down is using Web Deployment, not the ERP Portal. Make sure that Webdeployment is working properly. I would also like to point out that IE 11 is not supported until CRM 7.2D, and may play a role in this if installed. I would recomend an upgrade to PU4 for 300 ERP and patch F for CRM, followed by the solution in KB 31458.

  • 0

    We also had a client with this issue. Sage 300 ERP 2012 with CRM 7.2 on 2008R2 server. stripped and reinstalled but no glory. Spun up a 2012 server and moved everything over to clear the issue. Never did figure out why. Tomas is correct this is a ERP web deploy and both the web deploy and the portal must be working. Also not the portal for ERP 2012 is not Server 2012R2 compliant.

  • 0 in reply to stevenverickson

    It has come to my knowledge, through a support call with the business partner, that this install is on a 2008 server. As per the Sage CRM Support Matrix, Server 2008 R2 is the minimum requrement. To resove this, please upgrade the server to 2008R2 or 2012.

  • 0 in reply to TomasBlomqvist

    Tomas - It was discovered about running on Server 2008, however it's been in that environment for over 2 years  CRM was patched to 7.2f and PU 4 was installed.  We verified that web deployment is/was running.

    Here is the error message they were (periodically) when they click the drill down icon on the O/E Inquiry All Orders custom CRM page. When this message is received, sometimes other users will not be affected and sometimes the user who received the error can click the back arrow and then repeat the process and it works. However, ALL of the time, if the IT guys reset Sage Accpac Tomcat, the users can start working again,.

    Could not find the Sage 300 ERP O/E files.

    1. Make sure Order Entry is activated for this company in Sage 300 ERP.

    2. Check that this user has sufficient access rights to run Order Entry in Sage 300 ERP.

    3. Check with your internal support department to make the Sage CRM to Sage 300 ERP link is still valid.

    Error returned : Internal error. unable to open PO ini file. (12567 OEORDH1.C).

  • 0 in reply to stevenverickson

    Steve - this is a freaking nightmare for me as this is one of our largest sites.  Everything was working fine for 1 1/2 to 2 years until 12/16 and now it's non-stop errors.  Who knows, maybe I'll by them a new server and see if that works but if it doesn't they are going to be more *** off than they are now.

  • 0 in reply to LloydSmith

    Hi Lloyd,

    What you are saying about restarting Tomcat to make this work temporarily, makes no sense at all since Tomcat is not being used for that functionality. You can try to re-run the Webdeployment Manager (as adminstrator), and increase the Maximum Number of  Sage 300 ERP Server Objects. This value controls how many web screens can be open at the same time through webdeployment, and might help to resove the issue. However, there is a balance between functionality and server load in setting this value. The higher the value, the more sceens they can have open at the same time, but this also puts a higher load on the server.

    Please consider that this does not change Windows Server 2008 being an unsupported environment for this install. It would be highly advisable for this customer to at least upgrade their server to 2008 R2 to meet minimum requirements.

    Server 2008 was removed from the support matrix for a good reason. If Sage CRM 7.2 would had passed QA testing as fully functional under that environment, it would have still been listed as a valid platform. However, looking at the most current verison of the support matrix, we can see that it's not listed.

  • 0
    We also had a client with this issue. Sage 300 ERP 2012 with CRM 7.2 on 2008R2 server. stripped and reinstalled but no glory.