locked
SSMA to DB2 (zOS) 7.3 Connection error RRS feed

  • Question

  • Based on the output, it appears to have connected, but, once SSMA begins to load schemas from DB2, it runs for exactly 30 seconds then returns an error (as shown below).

    Connection to DB2 established successfully.
    Connection string: Provider=DB2OLEDB.1;Network Transport Library=TCPIP;User ID=dbamove;Initial Catalog=DBP1;Package Collection=DBP1;Network Address=mvsgwy01.tgr.net;Network Port=36000;Connection Timeout=0;
    Error occurred while collecting data.

    I've seen "error collecting data" and "Error collecting data into metabase". I assume these are permissions on one end or the other, but, have checked logs on both sides and do not see.

    Log Below. I've looked at this thing for days and cannot find anything pointing me to the problem. Any assistance would be greatly appreciated.

    [Generic: Mandatory] [14628/1] [2017-04-11 11:22:23]: SQL Server Migration Assistant for DB2 v7.3.0
    [Generic: Mandatory] [14628/12] [2017-04-11 11:25:26]: DB2 connection provider: oledb provider.
    [Generic: Mandatory] [14628/12] [2017-04-11 11:25:26]: DB2 connection mode: Standard.
    [Collector: Mandatory] [14628/12] [2017-04-11 11:25:27]: DB2 server version: 'DB2 v09.01'.
    [Collector: Error] [14628/12] [2017-04-11 11:26:22]: Error collecting data into metabase.
    [Collector: Error] [14628/12] [2017-04-11 11:26:22]: Exception: PROCESSING WAS INTERRUPTED BY A CANCEL REQUEST FROM A CLIENT PROGRAM SQLSTATE: 57014, SQLCODE: -952
     site: Void ExecuteCommandTextErrorHandling(System.Data.OleDb.OleDbHResult)
     source: Microsoft DB2 OLE DB Provider
     error code: -2147217900
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
       at System.Data.OleDb.OleDbCommand.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.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CountObjects(IDbConnection connection, Int64 serverVersion, Db2MfCollectionFilter filter, HashSet`1 excludedSchemas)
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CollectDataIntoMetabase(XMetabase xMetabase, IDbConnection connection, Int64 serverVersion, Db2MfCollectionFilter filter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
    [Generic: Error] [14628/12] [2017-04-11 11:26:23]: Failed to collect metabase data.
    [Generic: Error] [14628/12] [2017-04-11 11:26:23]: Exception: Error occurred while collecting data.
     site: Microsoft.SSMA.Framework.Generic.Collectors.XMetabase CreateMetabaseAndCollectData(System.Data.IDbConnection, System.String, Microsoft.SSMA.Framework.Generic.XTree.XNode, Microsoft.SSMA.Framework.Generic.UserInterface.IUIProgressBarProvider, Microsoft.SSMA.Framework.Generic.UserInterface.IUIStopOperationProvider, Microsoft.SSMA.Framework.Generic.Collectors.ICollectionContext)
     source: Microsoft.SSMA.Framework.Db2Mf.Generic
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CollectData(String xmlConnectionParameters, SecureString password, ICollectionContext context, IDbConnection implicitConnection, XNode xFilter)
       at Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
       at Microsoft.SSMA.Framework.Generic.Workspaces.Default.MetabaseWorkspaceItem.Connect(String connectionParameters, SecureString password)
    [Generic: Error] [14628/12] [2017-04-11 11:26:23]: Inner Exception #1: PROCESSING WAS INTERRUPTED BY A CANCEL REQUEST FROM A CLIENT PROGRAM SQLSTATE: 57014, SQLCODE: -952
     site: Void ExecuteCommandTextErrorHandling(System.Data.OleDb.OleDbHResult)
     source: Microsoft DB2 OLE DB Provider
     error code: -2147217900
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
       at System.Data.OleDb.OleDbCommand.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.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CountObjects(IDbConnection connection, Int64 serverVersion, Db2MfCollectionFilter filter, HashSet`1 excludedSchemas)
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CollectDataIntoMetabase(XMetabase xMetabase, IDbConnection connection, Int64 serverVersion, Db2MfCollectionFilter filter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
    [Gui: Error] [14628/12] [2017-04-11 11:26:28]: LowLevelAdapter.ReadSource : Read Source error: Microsoft.SSMA.Framework.Generic.Collectors.CollectorException: Error occurred while collecting data. ---> System.Data.OleDb.OleDbException: PROCESSING WAS INTERRUPTED BY A CANCEL REQUEST FROM A CLIENT PROGRAM SQLSTATE: 57014, SQLCODE: -952
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
       at System.Data.OleDb.OleDbCommand.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.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CountObjects(IDbConnection connection, Int64 serverVersion, Db2MfCollectionFilter filter, HashSet`1 excludedSchemas)
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CollectDataIntoMetabase(XMetabase xMetabase, IDbConnection connection, Int64 serverVersion, Db2MfCollectionFilter filter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
       --- End of inner exception stack trace ---
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CollectData(String xmlConnectionParameters, SecureString password, ICollectionContext context, IDbConnection implicitConnection, XNode xFilter)
       at Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
       at Microsoft.SSMA.Framework.Generic.Workspaces.Default.MetabaseWorkspaceItem.Connect(String connectionParameters, SecureString password)
       at Microsoft.SSMA.GUI.Product.Db2MfToMsSql.LowLevel.AppConnectToSourceDb2Mf.ConnectToSourceStart(Object guiContext)
    [Gui: Error] [14628/12] [2017-04-11 11:26:28]: Exception: Error occurred while collecting data.
     site: Microsoft.SSMA.Framework.Generic.Collectors.XMetabase CreateMetabaseAndCollectData(System.Data.IDbConnection, System.String, Microsoft.SSMA.Framework.Generic.XTree.XNode, Microsoft.SSMA.Framework.Generic.UserInterface.IUIProgressBarProvider, Microsoft.SSMA.Framework.Generic.UserInterface.IUIStopOperationProvider, Microsoft.SSMA.Framework.Generic.Collectors.ICollectionContext)
     source: Microsoft.SSMA.Framework.Db2Mf.Generic
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CollectData(String xmlConnectionParameters, SecureString password, ICollectionContext context, IDbConnection implicitConnection, XNode xFilter)
       at Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
       at Microsoft.SSMA.Framework.Generic.Workspaces.Default.MetabaseWorkspaceItem.Connect(String connectionParameters, SecureString password)
       at Microsoft.SSMA.GUI.Product.Db2MfToMsSql.LowLevel.AppConnectToSourceDb2Mf.ConnectToSourceStart(Object guiContext)
    [Gui: Error] [14628/12] [2017-04-11 11:26:28]: Inner Exception #1: PROCESSING WAS INTERRUPTED BY A CANCEL REQUEST FROM A CLIENT PROGRAM SQLSTATE: 57014, SQLCODE: -952
     site: Void ExecuteCommandTextErrorHandling(System.Data.OleDb.OleDbHResult)
     source: Microsoft DB2 OLE DB Provider
     error code: -2147217900
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
       at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
       at System.Data.OleDb.OleDbCommand.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.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CountObjects(IDbConnection connection, Int64 serverVersion, Db2MfCollectionFilter filter, HashSet`1 excludedSchemas)
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CollectDataIntoMetabase(XMetabase xMetabase, IDbConnection connection, Int64 serverVersion, Db2MfCollectionFilter filter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
       at Microsoft.SSMA.Framework.Db2Mf.Generic.Db2MfObjectCollector.Db2MfObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)

    Tuesday, April 11, 2017 4:03 PM

All replies

  • Hi ShawnHarrisSr,

    We are currently looking into this issue and will give you an update as soon as possible.

    Thank you for your understanding and support.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, April 13, 2017 9:16 AM