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 , SAP Business Suite on Sybase ASE Database Platform , 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 ONE Support launchpad (Login required).

Search for additional results

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