2345886 - Incorrect rowcounts from queries on hash-partitioned tables (during SUM DMO) - SAP ASE

You are running queries against Hash-Partitioned tables on SAP ASE.

• An example query such as the one below on hash-partitioned table TAB, returns an incorrect number of rows:

select count(*) from TAB WHERE RCLNT = '500' AND ('2012' < RYEAR OR (RYEAR = '2012' AND '4710004411' < DOCNR)) AND RYEAR <= '2012'

• The same query returns the correct number of rows on the unpartitioned copy of TAB.
• dbcc check on the table and it's indexes is clean

On systems running SAP applications:

• You are migrating your SAP BW and/or SAP Solution Manager system from SAP ASE to SAP HANA via SUM DMO
• A rowcount mismatch is reported during the downtime phase, EU_CLONE_MIG_DT_RUN
• Per SAPup_troubleticket.log:
  -------------------------------------------------------------
  SAPup broke during phase SUBMOD_MIG_SWITCH_ORG/SUBMOD_MIG_DOWNTIME_RUN/EU_CLONE_MIG_DT_RUN in module MAIN_SWITCH / Downtime I: Switch tables and Kernel
  Error Message: Found 2 tables with different row count/checksums,
  see '/usr/sap/<SID>/SUM/abap/migrate_dt/MIGRATE_DT_CHECKDIFF.LST' for more details on 'repair' option
  -------------------------------------------------------------
• The error is reported on partitioned PSA tables
• dbcc check on the PSA table and it's indexes, on source ASE system, is clean

• SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.0
• SAP Solution Manager (SOLMAN) 7.1

SUM, DMO, "SUM DMO", migration, HANA, partitioned, rowcount, EU_CLONE_MIG_DT_RUN, MIGRATE_DT_CHECKDIFF.LST, PSA , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem