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

• 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>

SAP Adaptive Server Enterprise (ASE) 16.0 SP3

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