none
Analysis Manager & Msmdarch - Application Error

    Question

  • I have been receiving the follow error when I close Analysis Manger:

    mmc.exe - Application Error
    The instruction at “0x7c8327f9” referenced memory at “0xffffffff”.  The memory could not be “read”


    I am also getting the following error when msmdarch completes an archive.

    msmdarch.exe – Application Error
    The instruction at “0x7c8327f9” referenced memory at “0xffffffff”.  The memory could not be “read”

    I am not seeing anything in the event viewer for these errors.


    The system is a Win2k3 Server SP1 with 3.75 GB of ram and Sql Server Standard SP4.

    I have scoured google looking for an answer, but I am coming up short.

    Any insight into these errors?

    Wednesday, August 09, 2006 4:10 PM

Answers

  • RESOLVED!

    unbelievable. the issues turned out to be the Oracle ODBC driver that we were using as the Data Source. I updated the ODBC driver with the latest drivers from Oracle and the issues have gone away for both analysis manager & msmdarch.

    Wednesday, August 30, 2006 3:31 PM

All replies

  • Looks like something is wrong with the installation on your machine.

    You can try and re-install Analysis Services on you machine. Please make sure you backup all your databases before doing so.

    Edward.
    --
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Thursday, August 10, 2006 7:23 PM
    Owner
  • the only reason I haven't tried that yet is that this is also happening on other machines, another Win2k3 box and an XP machine, I should have stated that.
    Thursday, August 10, 2006 7:28 PM
  • RESOLVED!

    unbelievable. the issues turned out to be the Oracle ODBC driver that we were using as the Data Source. I updated the ODBC driver with the latest drivers from Oracle and the issues have gone away for both analysis manager & msmdarch.

    Wednesday, August 30, 2006 3:31 PM
  • Interesting, I have been searching for a solution to a similiar error

    DTSRun.exe - Application Error

    The instruction at "0x7c8327f9" referenced memory at "0xffffffff".  The memory could not be read.

    when running a scheduled DTS package Win 2003 sp1 0S that runs fine when not scheduled.  The package connects to an Oracle 8i DB to pull data into SQL server 2000 DB tables.  Do you have a link for the Oracle Driver you used.  I am using Instant Client version 10 driver?

    Saturday, December 02, 2006 2:36 PM
  • I would just pull down the latest instant client from oracle, hopefully that will fix your issue.
    Saturday, December 02, 2006 7:17 PM