locked
Counting objects to be loaded... Error occurred while collecting data. RRS feed

  • Question

  • While using the Migration Assistant for Oracle v5.2.1259.

    I enter the connection info and the tool seems to connect to the Oracle DB successfully.  The status bar shows "Counting objects to be loaded...", but after about 60 seconds a dialog box with the very descriptive message "Error occurred while collecting data.". 

    Has anyone else come across this error?  Is there anywhere I should look for a more descriptive error message? 

    Here's the version info for the Oracle DB:

    Oracle Database 11g Release 11.2.0.1.0 - Production
    PL/SQL Release 11.2.0.1.0 - Production
    "CORE 11.2.0.1.0 Production"
    TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
    NLSRTL Version 11.2.0.1.0 - Production

    Let me know if there is any other information that would be useful. 

    Thanks in advance!

    Gene

    UPDATE: 

    I found the SSMA log file.  Here's what it contains:

    [Generic: Error] [3332/1] [2012-05-10 14:53:36]: SQM initialization error: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
    [Generic: Error] [3332/1] [2012-05-10 14:53:36]: Exception: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
     site: Void SqmWriteSharedMachineId(System.Guid)
     source: Microsoft.SSMA.Framework.Generic.Factories
       at Microsoft.SSMA.Framework.Generic.SQM.SqmLibWrapper.SqmWriteSharedMachineId(Guid Guid)
       at Microsoft.SSMA.Framework.Generic.SQM.SqmSession.SetMachineId()
       at Microsoft.SSMA.Framework.Generic.SQM.SqmSession..ctor(String name)
       at Microsoft.SSMA.Framework.Generic.SQM.SqmSSMAManager.InitSession()
       at Microsoft.SSMA.Framework.Oracle.SqlServer.SQM.SqmOracleSSMAManager.InitSession()
    [Generic: Mandatory] [3332/1] [2012-05-10 14:53:38]: SQL Server Migration Assistant for Oracle v5.2.1259
    [Collector: Mandatory] [3332/4] [2012-05-10 14:54:03]: Oracle connection provider: OracleClient.
    [Collector: Mandatory] [3332/4] [2012-05-10 14:54:03]: Oracle connection mode: Standard.
    [Collector: Mandatory] [3332/4] [2012-05-10 14:54:04]: Oracle server version: '11.2.0.1.0'.
    [Gui: Error] [3332/4] [2012-05-10 14:54:36]: LowLevelAdapter.ReadSource : Read Source error: Microsoft.SSMA.Framework.Generic.Collectors.CollectorException: Error occurred while collecting data. ---> System.Data.OracleClient.OracleException: ORA-04030: out of process memory when trying to allocate 22704 bytes (kxs-heap-c,temporary memory)

       at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
       at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
       at System.Data.OracleClient.OracleCommand.ExecuteScalarInternal(Boolean needCLStype, Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
       at System.Data.OracleClient.OracleCommand.ExecuteScalar()
       at Microsoft.SSMA.Framework.Generic.Utilities.DbUtilities.DbCommandWrapper.ExecuteScalar()
       at Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbCommand.Execute[T](ExecutionDelegate`1 executionMethod)
       at Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbCommand.ExecuteScalar()
       at Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CountObjects(IDbConnection connection, Int64 serverVersion, OracleCollectionFilter filter, Set`1 excludedSchemas)
       at Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CollectDataIntoMetabase(XMetabase xMetabase, IDbConnection connection, Int64 serverVersion, OracleCollectionFilter filter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
       at Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
       --- End of inner exception stack trace ---
       at Microsoft.SSMA.Framework.Generic.Workspaces.Default.MetabaseWorkspaceItem.Connect(String connectionParameters, SecureString password)
       at Microsoft.SSMA.GUI.Product.OracleToMsSql.LowLevel.AppConnectToSourceOracle.ConnectToSourceStart(Object guiContext)
    [Gui: Error] [3332/4] [2012-05-10 14:54:36]: Exception: Error occurred while collecting data.
     site: Void Connect(System.String, System.Security.SecureString)
     source: Microsoft.SSMA.Framework.Generic.SSMAEnvironment
       at Microsoft.SSMA.Framework.Generic.Workspaces.Default.MetabaseWorkspaceItem.Connect(String connectionParameters, SecureString password)
       at Microsoft.SSMA.GUI.Product.OracleToMsSql.LowLevel.AppConnectToSourceOracle.ConnectToSourceStart(Object guiContext)
    [Gui: Error] [3332/4] [2012-05-10 14:54:36]: Inner Exception #1: ORA-04030: out of process memory when trying to allocate 22704 bytes (kxs-heap-c,temporary memory)

     site: Void CheckError(System.Data.OracleClient.OciErrorHandle, Int32)
     source: System.Data.OracleClient
     error code: -2146232008
       at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
       at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
       at System.Data.OracleClient.OracleCommand.ExecuteScalarInternal(Boolean needCLStype, Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
       at System.Data.OracleClient.OracleCommand.ExecuteScalar()
       at Microsoft.SSMA.Framework.Generic.Utilities.DbUtilities.DbCommandWrapper.ExecuteScalar()
       at Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbCommand.Execute[T](ExecutionDelegate`1 executionMethod)
       at Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbCommand.ExecuteScalar()
       at Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CountObjects(IDbConnection connection, Int64 serverVersion, OracleCollectionFilter filter, Set`1 excludedSchemas)
       at Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CollectDataIntoMetabase(XMetabase xMetabase, IDbConnection connection, Int64 serverVersion, OracleCollectionFilter filter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
       at Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)


    • Edited by Jumper350 Thursday, May 10, 2012 10:00 PM
    Thursday, May 10, 2012 9:33 PM

Answers

  • Hi Jumper350,

    >> source: System.Data.OracleClient error code: -2146232008

    Regarding to the SSMA error log, which should not be SQL Server issue. This might be related to SSMA for Oracle issue, please link to SSMA team for further help from here.

    Meanwhile based on error code in log above, here is a thread with the same error code as yours, please refer to here

    Regards, Amber zhang

    • Marked as answer by amber zhang Friday, May 18, 2012 4:32 AM
    Tuesday, May 15, 2012 8:09 AM

All replies

  • Could you please check the given link, hope it will help you. http://kb.monitorware.com/kbeventdb-list-3-System-SysMon.html
    Saturday, May 12, 2012 5:44 PM
  • Hi Jumper350,

    >> source: System.Data.OracleClient error code: -2146232008

    Regarding to the SSMA error log, which should not be SQL Server issue. This might be related to SSMA for Oracle issue, please link to SSMA team for further help from here.

    Meanwhile based on error code in log above, here is a thread with the same error code as yours, please refer to here

    Regards, Amber zhang

    • Marked as answer by amber zhang Friday, May 18, 2012 4:32 AM
    Tuesday, May 15, 2012 8:09 AM