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.