• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 822
  • Last Modified:

eConnect Error: Cannot Find a Stored Procedure in the Microsoft Dynamics GP Database


When using eConnect for GP 2010 to import Project Accounting projects into the Project Cards, I get an error that says, "The stored procedure taPAProjects doesn't exist."

But, we took a look in the company database in SQL.  Indeed, this stored procedure is there.  How can we convince eConnect of that?

Thanks!  Much appreciated!

1 Solution
Steve EndowMicrosoft MVP - Dynamics GPCommented:

I have run into this error before.

There are three possible reasons that I'm aware of for this error, and there may be others.  Do you have any other eConnect integrations that work properly for this particular database?

First, you should output / display your eConnect connection string to double check that you are sending the correct SQL instance name and correct database name.

Data Source=SERVERNAME;Initial Catalog=COMPANYDB;Integrated Security=SSPI

Next, verify that the company database DYNGRP role includes EXEC access to the stored procedure

If that looks correct, open SQL Server Management Studio, expand Security -> Logins and locate the eConnect login, then double click on the eConnect login.

Select the User Mapping page.  Verify that the Default Schema is set to "dbo" for all of the mapped GP databases.  If there is a Default Schema other than dbo for any of the databases, you will need to delete the eConnect user schema from all databases, and then delete the eConnect SQL login.  You can then re-created the eConnect login and users, making sure that the Default Schema is dbo.

Please let me know one of these seems relevant to your issue.


Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
TBSupportAuthor Commented:
Hi Steve:

Yes, the client did not have the correct DSN being used.  Therefore, I was not connecting to the correct server nor the correct database.

Thanks, so much!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now