A client reported that a SmartConnect integration they’d been using for a couple of years had started failing regularly. It was scheduled to run in the early hours on every week day, but was failing most of the time; oddly, it was working sometimes.
If the integration was run manually it ran successfully every single time. When running on the schedule it failed more often than not.
There was an error writing to the pipe: Unrecognized error 232 (0xe8)
We made two changes to the setup after which the issue was resolved and the integration ran successfully.
We gave the service account permissions on SmartConnect database and we changed format of the service account from user@domain to domain\user.
The puzzling aspect of this error was that neither the service account nor the assigned permissions had been changed. Or at least no-one with the ability to make changes admitted to having done so.
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.