Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Deploy SRS Reports Error
Microsoft Dynamics GP (Archived)

Deploy SRS Reports Error

(0) ShareShare
ReportReport
Posted on by Travis 1,960

I get the following error when using the SQL server reporting services wizard for GP.

Just after I select the TWO database to deploy the reports to, I get

Unhandled exception has occured in your application. etc, etc, details below:

I am running windows 7 64 bit.

 

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {58737586-7149-11D4-9BB0-00A0CC359411} failed due to the following error: 80040154.
   at Microsoft.Dynamics.GP.BusinessIntelligence.SRSDeployment.GPReg.GetKeyHash(SqlConnection sqlConnection)
   at Microsoft.Dynamics.GP.BusinessIntelligence.SRSDeployment.GPReg.IsModuleRegistered(Int16 Mod, SqlConnection sqlConnection)
   at Microsoft.Dynamics.GP.BusinessIntelligence.SRSDeployment.GPReg.GetRegisteredModules(SqlConnection sqlConnection)
   at Microsoft.Dynamics.GP.BusinessIntelligence.SRSDeployment.FormSrsDeployment.cmbxDatabase_SelectedIndexChanged(Object sender, EventArgs e)
   at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
   at System.Windows.Forms.ComboBox.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
Microsoft.Dynamics.GP.BusinessIntelligence.SRSDeployment
    Assembly Version: 10.0.0.0
    Win32 Version: 10.00.836.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Dynamics/SQL%20Reporting/Microsoft.Dynamics.GP.BusinessIntelligence.SRSDeployment.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Web.Services
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
wubp6p9z
    Assembly Version: 10.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Interop.GPRegistration
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.0.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Interop.GPRegistration/10.0.0.0__31bf3856ad364e35/Interop.GPRegistration.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


 

*This post is locked for comments

  • Tanya Henderson Profile Picture
    Tanya Henderson on at
    RE: Deploy SRS Reports Error

    Thank you so much other posts didn't say you needed a 64 bit version.  This saved me hours and fixed the issue immediately.

  • Suggested answer
    Sergio Ferreira Profile Picture
    Sergio Ferreira 30 on at
    Re: Deploy SRS Reports Error

    There isn't a 64-bit version of the SRS Deployment Wizard. What you do need is the 64 bit Dexterity Common Components (mbs.microsoft.com/.../downloadfile.aspx). You don't need to restart anything once those are installed, just re launch the Wizard and you won't get the error, just your module list.

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    Re: Re: Re: Re: Re: Re: Re: Deploy SRS Reports Error

    Travis,

    The 32 bit SRS Deployment Wizard won't work on a 64 bit machine.  With Dynamics GP 2010, there is a 64 bit version of the deployment wizard.

    Thanks

    Rob

  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at
    Re: Re: Re: Re: Re: Re: Deploy SRS Reports Error

     Wait...it may be the other way around.  Anyways I would try to install 32-bit on 32-bit and 64-bit on 64-bit.  I have had quite a few issues in the past installing 32-bit software on 64-bit architectures.

  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at
    Re: Re: Re: Re: Re: Deploy SRS Reports Error

     I don't know if there is or not.  However, I don't think you can install 32 bit versions of software on 64-bit architectures.

     

    Ron

  • Travis Profile Picture
    Travis 1,960 on at
    Re: Re: Re: Re: Deploy SRS Reports Error

    The 64 bit version of the Reporting Wizard?  I didn't know there was one.

  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at
    Re: Re: Re: Deploy SRS Reports Error

     

    Are you positive you are installing the 64-bit version?
  • Travis Profile Picture
    Travis 1,960 on at
    Re: Re: Deploy SRS Reports Error

    Yes.

  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at
    Re: Deploy SRS Reports Error

     Travis,

     Are you trying to install this on a Windows 7 64-bit machine?

     Ron

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans