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 for Me (Login required).

Search for additional results

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