Can’t get rid of “SmartList Builder needs to finish installing.”
After updating from GP2010 to GP 2013 SP2 and installing SmartList Builder , I always, get the message "SmartList Builder needs to finish installing. This may take a few minutes." when login with sa. I connected to all companies, and it still give this message. Non-sa users get a message saying that an administrator must complete Smartlist Builder installation.
How can I get rid of this message? How can I complete the installation? I entered Smartlist builder registration key, and it was accepted.
When I installed GP 2013, I installed the SmartList Builder provided with GP, and installed the eOne version after running GP Utilities. Just to make sure, I followed the instruction you provided to uninstall the eOne SLB version et put back the version included with GP, and I didn't forget to update the DU000020 table. I ran GP Utilities, and reinstall eOne SLB.
Still the same problem. In DB_Upgrade, the version for PRODID=3830 is 12.0.21 for all databases.
I ran a SQL profiler. The last executed query when the "smartlist needs to finish installing" message appear is:
My ERB11100 table in DYNAMICS misses the Blank_Field_CB field.
Which update adds this field? GP-provide SLB or eOne version?
The tables should have been updated from the GP upgrade. If you would like to go through our support we have a script to go through and update the tables for you.
When you upgraded to GP 2013 did you also upgrade the version of SmartList Builder that came with your GP 2013 upgrade before installing the eOne version? If not we have instructions in our manual for the upgrade process online: https://www.eonesolutions.com/smartlist-builder/downloads/
If you didn't follow that process you will need to uninstall the eOne version of SmartList Builder and then run through that upgrade process in the manual, then install the eOne version. Here are the steps to unistall the eOne SmartList Builder. https://www.eonesolutions.com/help-article/completely-uninstall-smartlist-builder-from-a-workstation/
I am getting the same error. We upgraded to GP 2013 Dynamics 12.00.1482 and used build 67 of smart list builder.
I also receive the same error everytime you log into any company.
what is the resolution?
On build 67 the issue has been fixed. After clicking yes the first time it should not prompt you again until you make changes in SmartList Builder.
I have the same issue with an upgrade from GP 2010 to 2013 R2. Went through the install steps in the manual and keep getting the needs to finish installing error upon login. Can get into the windows as any user. I did have to restore the Dynamics database after installing eOne to update a failed company, but did install again. Any suggestions? Thanks!
Does the following query execute with any errors?
select Extender_Type, Extender_ID from DYNAMICS..DDB10000
select Extender_Type, Extender_ID from DYNAMICS..ERB10100
select Extender_Type, Extender_ID from DYNAMICS..NLB10100
select Extender_Type, Extender_ID from DYNAMICS..SLB10100
select Extender_Type, Extender_ID from DYNAMICS..SLB10400
select Blank_Field_CB from DYNAMICS..ERB11100
select Blank_Field_CB from DYNAMICS..NLB11100
select Blank_Field_CB from DYNAMICS..SLB11100
If that runs without error it's possible you may be missing a view(s). You can create the views by going to Microsoft Dynamics GP-Tools-SmartList Builder-Maintenance-Create Views as the sa user. Select all the companies and click create.
Not sure if no errors refers to. THe top 3 had no output, the next 2 had 0 for output, and the last 3 failed but the table existed with 0 rows.
If you can send in an email to email@example.com I can send you a script that will fix the last 3 and should stop the message from happening.
If you would like to submit an answer or comment, please sign in to the eOne portal.