SP error 2005140

SP error 2005140

Postby klincoln » Mon Apr 23, 2012 3:59 pm


Does anyone know what this error means? I do not see it in Error Definition.

Posts: 2
Joined: Thu Feb 09, 2012 11:59 am

Re: SP error 2005140

Postby rlape » Wed Apr 25, 2012 11:25 am


What type of interface is this? Is it an inbound order interface?

You can usually get some clue about what is causing the error by querying the Dictionary table in the Works database. The Number column references the last 4 digits of your error number.

In your case use this query.
SELECT * FROM dbo.Dictionary WHERE Number = '5140'

The error looks like an issue with the InboundOrder_Interface_Auth_DE table.

You can also look at the stored procedure that the interface is calling and search for this error number. I am not seeing this error in the FileOrder SP, though.

Please post more info about the type of interface and maybe the target message that is generating this error.
Ray Lape | Senior Consultant
Galen Healthcare Solutions
Posts: 40
Joined: Wed Mar 30, 2011 12:34 pm
Location: Burlington, KY

Return to Order/Result

Who is online

Users browsing this forum: No registered users and 1 guest