SAP Knowledge Base Article - Preview

3007251 - Sybmigrate doesn't report object status if using objtype_create_list_from_sql=QUERY in resource file -- SAP ASE

Symptom

  • Reports produced by sybmigate are missing table objects

    e.g. No Table in the following output:

    sybmigrate -r resource_file_name -m report

    Generating report(s) for migration path : TestDb-->TestDb

    'Status Report' for path 'TestDb' --> 'TestDb'
    ------------------------------------------------------
    Database Data
    Type                                     Status
    ---------------------------------------- ---------------
    Users                                    Initial
    ……
    Replication Attributes                   Initial
     
    View
    Owner                          Name                           Status
    ------------------------------ ------------------------------ ---------------
    dbo                            VuObj                          Success
    dbo                            VuInd                          Success
     
    Stored Procedure
    Owner                          Name                           Status
    ------------------------------ ------------------------------ ---------------
    dbo                            proc1                          Success
    dbo                            proc2                          Success
    -------------------------------------------------------------------------------------------------

    Table create list is using query objtype_create_list_from_sql=Query in resource_file, e.g. related table, view, procedure list in resource file:

    table_create_list_from_sql =
        select user_name(uid), name from sysobjects
        where type = 'U' and name like 'Tab%'
    table_migrate_list_from_sql=
        select user_name(uid), name from sysobjects
        where type = 'U' and name like 'Tab%'
    store_procedure_create_list=
        proc1
        proc2
    view_create_list_from_sql=<ALL_OBJECTS>


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP3

Product

SAP Adaptive Server Enterprise 16.0

Keywords

sybmigrate, CR 821551, 821551, CR821551, objtype_create_list_from_sql, missing, empty , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.