web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Runtime error 429 when connecting to SL2015 CU2 from 32bit Excel

(0) ShareShare
ReportReport
Posted on by 6,451

I am running into this issue in SL 2015 CU2  that was apparently fixed in SL 2015 CU1.  It happens on the "Set sivTB = New SIVToolbar" line of code in the Excel Macro.

pastedimage1572272874686v1.png

Can MS confirm that is Hot Fix made it into SL 2015 CU2 and beyond?  Below is the link for the SL 2015 CU1 Hot Fix.

https://support.microsoft.com/en-us/help/3091285/you-receive-a-run-time-error-429-when-you-try-to-connect-to-microsoft

I have the same question (0)
  • Verified answer
    CFROTON Profile Picture
    4,710 on at

    Hello

    I can confirm that they could not reproduce it in CU2...But they did have some fix releated in version 2018

    Here is a workaround listed in the bug 32187 (this is the HF for the CU1 bug)

    Execute the following command in a command Window running as administrator

    c:\Windows\Microsoft.NET\Framework\v4.0.30319\regasm.exe  "c:\Program Files (x86)\Common Files\Microsoft Shared\DynamicsSL\Microsoft.Dynamics.SL.ObjectModel.dll"

    The assembly, Microsoft.Dynamics.SL.ObjectModel.dll who’s typical location is

    c:\Program Files (x86)\Common Files\Microsoft Shared\DynamicsSL needs to be registered with COM for the Object Model to work properly. The Client Installation for Microsoft Dynamics SL 2015 did not do that properly. The CU1 update was not capable of registering the file, so this HotFix was created.

       To accomplish that registration, the REGASM tool is used. It is installed with Microsoft.Net so is already available on the machine. Its typical location is…

    c:\Windows\Microsoft.NET\Framework\v4.0.30319

    ------------------------------------------------------------

    You might look at this below regarding the bug mentioned

    The latest comments regarding this bug (the HF request submitted for CU2) are:

    After creating the application and setting it to target the 32-bit configuration (rather than AnyCPU), the app loaded parent fine.  After applying CU1 to the SL 2015 install, it did encounter a problem - as expected - but installing CU2 then fixed the issue.

    I also was able to launch the Dynamics SL parent and application from Microsoft Excel after installing the 32-bit version of Excel.  Apparently Object Model runs only under the 32-bit version.

    Per comments below, this is not reproducible after the manual registration step provided with Bug 32187 is applied.  The code hotfix for that bug has been included in CU2.

    This is that workaround for manual registration

    Execute the following command in a command Window running as administrator

    c:\Windows\Microsoft.NET\Framework\v4.0.30319\regasm.exe  "c:\Program Files (x86)\Common Files\Microsoft Shared\DynamicsSL\Microsoft.Dynamics.SL.ObjectModel.dll"

                  The assembly, Microsoft.Dynamics.SL.ObjectModel.dll who’s typical location is

    c:\Program Files (x86)\Common Files\Microsoft Shared\DynamicsSL needs to be registered with COM for the Object Model to work properly. The Client Installation for Microsoft Dynamics SL 2015 did not do that properly. The CU1 update was not capable of registering the file, so this HotFix was created.

       To accomplish that registration, the REGASM tool is used. It is installed with Microsoft.Net so is already available on the machine. Its typical location is…

    c:\Windows\Microsoft.NET\Framework\v4.0.30319

    In order to access the object model from Excel, the 32-bit version of Excel/Office must be installed.  For an application to successfully access the Object Model, the app must be built with a target environment of x86.

    Thank you

    Jana MacDonald

    Microsoft Dynamics Support

  • Verified answer
    Mark E Profile Picture
    6,451 on at

    Thanks.  It appears that the command line to register the Object Model dll has resolved my issue.  Going to do more testing, but so far it looks good.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans