Sage 100

Sage 100 v 4.5 SQL - getting an error on the Integration Engine that I have not seen in the past. Really no information that I could find on the Knowledgebase, but I think that system is getting worse by the day. Integration Engine error: Error occured in SY_Maint.pvc line 428: Error #15: Operating system command failed Any help would be appreciated.

Kevin, I can tell you that the integration engine is probably trying to update a file and the operating system has returned an error. We see this a lot with writes to SQL Server, but just the error 15 along doesn't tell us much. It is frequently a problem with the connection string, but if other processes within Sage 100 are working properly, then it could be something like trying to write out too many characters to a Sage 100 field (truncation) or any number of other issues. If there were a way to get the actual OS message, it would help a lot. Unfortunately, that's probably not easy within the integration engine. - Phil

Thanks, unfortunately I can't see any other details. I did some more basic testing and the 100 server linking to the CRM server does have an issue with the URL, just found that. So, I'm going down that path at the moment to have them resolve that issue. Can still get to CRM fine from outside and on the CRM server, so I think this is a good place to start.

choose the Rebuild CRM option - it will clear the files and rebuild.

Thanks for the tip @JohnnyPabian . After fixing the server link that they broke, the rebuild was able to kick out a more descriptive error message about a duplicate key. Found a duplicate User in CRM that was trying to sync back to Sage 100. Deleted that user and was able to rebuild and resolve the issue.