After configuring a new Microsoft Dynamics GP Company, the extender setup is triggered during the first login attempt, which opens the ‘Install Extender’ window automatically. This window displays a list of companies, including the new one, and allows you to select the new company for installing tables, loading from the cache, etc. However, for some reason, the extender table EXT01000 (EXT_Extender_Activity) is not created due to:
- The table is somehow damaged
- Logged into GP using an account other than ‘sa’
- Logged into GP while other users were already logged in
We would encounter the following errors every time after logging in.
- [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure ‘TWO.dbo.zDP_EXT01000L_2’.
- [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name ‘TWO.dbo.EXT01000’.
- An operation on table ‘EXT_Extender_Activity” cannot find table data.
- A remove range operation on table ‘EXT_Extender_Activity’ cannot find the table
If you’d like to watch a video explaining this, see below or click here.
Here’s the solution:
- Verify you have a backup of your Dynamics and company databases.
- Log in to Dynamics GP as the ‘sa’ user in a company where the Extender Windows is functioning correctly.
- Go to Microsoft Dynamics GP – Maintenance – SQL. Change the product to Extender and select the database where the EXT01000 table is missing. Highlight ONLY the Extender Activity table, then check the boxes on the right for “Drop Table,” “Create Table,” “Drop Auto Procedure,” and “Create Auto Procedure.” Your window should appear like this but with your database shown instead of the TWO Database.
- Before clicking Process, make sure that only the correct table is highlighted. Then, click the Process button, which will drop (if needed) and recreate the table and stored procedures for the affected company. After that, try logging into the company in GP and the error should be resolved.
Have a question? Please reach out to us at support@eonesolutions.com
