SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

  • 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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Solution Manager 7.1

Keywords

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

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.