InfoPath Dev

Hi,

I have an InfoPath form which was deployed as a form template; it consumes a web service, pulls data from SQL server.

Some maintenance work has been done on my servers in the production environment, now the InfoPath forms are not working properly.

When I select an item in a drop down box it used to automatically fill the remaining text boxes.

Now when I select an Item in dropdown box shows up “An error occurred accessing a data source” error.

I got this error.

The query cannot be run for the following DataObject: GetAllEmployeesAtLocation
InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred:

Could not find stored procedure 'dbo.GetEmployeeInformationForAllEmployeesAtLocation'.
<detail><ExceptionDetail xmlns="http://schemas.datacontract.org/2004/07/System.ServiceModel" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><HelpLink i:nil="true"/><InnerException i:nil="true"/><Message>Could not find stored procedure 'dbo.GetEmployeeInformationForAllEmployeesAtLocation'.</Message><StackTrace>   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

Please help me.

Thanks!

It's difficult to know what corrective action to take without knowing what "maintenance work" was done on the server. From the error message, it seems your stored procedure was deleted. Can you restore it? If I were you, I'd go thru the deployment steps for your solution and see if that fixes it. Hopefully you are the creator of the solution and know how to do this.