Skip to content
+1-888-319-3663

COMMUNITY FORUM

Stored Procs not created for one GP database

Manny asked 3 years ago
Hello,
We have one that does not have the SmartConnect stored procedures present.   I tried everything listed in this article, but no luck.
 
https://www.eonesolutions.com/help-article/kba-01144-l9g7l4/
 
Any ideas?  This is only happening to 1 GP database. 
Answers
Lorren Zemke answered 3 years ago
Manny,
Is System Maintenance running successfully or with errors? If there are some errors, it may be possible, that it’s not getting to that company to be able to create the stored procedures.
Depending on the number of companies, System Maintenance may take several minutes to run. You should see if reference updating GP Databases and then some additional tasks after that. 
Maybe you could post the results of the System Maintenance run.
 
Lorren
Manny replied 3 years ago

Hi Lorren,

Thanks for the reply. I ended up contacting support. Today I was asked to to run a script to clear all event log data that was older than 7 days. After that then I was able to run system maintenance to re-create the stored procedures.


If you would like to submit an answer or comment, please sign in to the eOne portal.