Exception of type 'System.OutOfMemoryException' was thrown in SSMA

Question

Hi,

I never have worked with SQL Server before, my experience is in Oracle, but currently we are trying to assess migrating our application from Oracle to SQL Server 2008 R2.

Now I have installed the SQL Server Migration Assistant for Oracle Tool and SQL Server Migration for Oracle Extension Pack.

First I'm trying to create the Report using the SSMA Analyzer but when I select all the tables from the schema and select create report, half way through the analysis I get the following error and no report is generated:

"Conversion finished with 26568 errors, 28 warnings, and 52197 informational messages.
An unexpected error occurred. Please send the log file to product support. For more information, see "Getting SSMA Assistance" in the product documentation.
Exception of type 'System.OutOfMemoryException' was thrown."

the client machine where I'm executing the SSMA has the following specs:

Free space in hard drive: 762 GB

Memory (RAM): 8 GB

Processor: Intel Core i7-2600 CPU 3.4GHz

System type: 64-bit Operating System

OS: Windows 7 Professional

Can anyone help me with this please?

Thanks in advance.

Answer 1

How much memory did the migration assistant use (e.g. shown in Task Manager)? If it takes a lot of memory the error explained itself. You may try to select less objects a time.

In case you ran the 32 bit version you may also try the 64 bit version.

Thanks.

Liu An [MSFT]

Answer 2

Hi,

The SSMA used half of the physical memory of the machine.The following is a fragment of the log file for when the exception occurs:

"... Exception: Exception of type 'System.OutOfMemoryException' was thrown.
 site: System.String GetStringForStringBuilder(System.String, Int32, Int32, Int32)
 source: mscorlib
   at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
   at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength)
   at System.Text.StringBuilder.Append(String value)
   at System.IO.StringWriter.Write(String value)
   at Microsoft.SSMA.Framework.Generic.Formatters.Default.DefaultHTMLFormatterWriter.WriteHtmlElementStart(String value)..."

Yesy I'm using the 32 bit version as when I try to connect to Oracle with the 64 bit version I get the below error message , and I was trying to avoid installing a new Oracle client.

 "Error occurred while establishing connection to Oracle server. You might have 32-bit connectivity components installed on the machine, in order for SSMA to make use of those connectivity libraries, you need to run the 32-bit version of SSMA..."

Thanks,

Answer 3

Hi moni,

Oracle Client 8.1.7 or a later version, and connectivity to the Oracle databases that you want to migrate. The Oracle client version must be the same version as, or a later version than, the Oracle database version.

On a 64-bit platform, SSMA installs both 32-bit and 64-bit SSMA applications. Depending on the platform (32 or 64-bit) of the Oracle connectivity layer make sure to run the corresponding SSMA (32 or 64-bit) application. Otherwise, both 32 and 64 bit platforms are supported on source (Oracle), client (SSMA machine) and target (SQL Server).

For more information about SSMA for Oracle, please refer to http://www.microsoft.com/download/en/details.aspx?id=28766
                                                                                        http://msdn.microsoft.com/en-us/library/hh313179.aspx.

Pay attention to the system requirements.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 4

Hi Maggie,

Thanks for your reply. I do have all the system requirements as state on my first post, plus my oracle client is 11.2.

I was just emphasizing the fact that my Oracle client is 32-bit so I use the 32-bit SSMA.

Do you know how can I solve my issue of System.OutOfMemoryException?

Thanks,

Natalia

Answer 5

Hi moni,

The exception that is thrown when there is not enough memory to continue the execution of a program.

Excessive managed memory usage is commonly caused by:
 
 Reading large data sets into memory.
 Creating excessive cache entries.
 Uploading or downloading large files.
 Excessive use of regular expressions or strings while parsing files.
 Excessive view state.
 Too much data in session state or too many sessions.

Make sure that there is no any behavior cost much memory.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 6

Hi,

I've tried the 64-bit version of SSMA and in this version I don't get System.OutOfMemory exception.

Still in the 32-bit version even if a select one table with its triggers I get the exception.

Thanks a lot,

Natalia

Answer 7

hi you can also ask your query on the given forum. It may help you .

http://forums.devx.com/showthread.php?t=156633