Symptom
A simple 'Select ~ Into ~' query returns incorrect result only on two secondary nodes(node3 & node4).
However same query returns always correct result on coordinator node(node1) and the 1st secondary node(node2).
... [20896]: Insert for '#TEMP_CHK' completed in 11 seconds. 422 rows inserted. <= incorrect in node3
... [20896]: Insert for '#TEMP_CHK' completed in 6 seconds. 438 rows inserted. <= Correct on node1
* problematic query : below second SQL ran into incorrect results.
SELECT ..., ...ID(A.RNN, 101) AS RNN , ...
INTO #TMP_RNN
FROM #TMP_RNN_T A ;
SELECT A.RNN
, CAST( TRIM(REPLACE(A.KRN_CSM,' ','')) AS CHAR(010))
, CAST( TRIM(REPLACE(B.KRN_CSM,' ','')) AS CHAR(010))
, CAST(0 AS INTEGER)
INTO #TEMP_CHK
FROM #TMP_RNN A
, ***.TB_ADW_CSC101P B
WHERE B.BASE_YM = '201712'
AND B.LDGR_SCD = '1'
AND A.RNN = B.RNN
AND TRIM(REPLACE(A.KRN_CSM,' ','')) <> TRIM(REPLACE(B.KRN_CSM,' ','')) ;
Read more...
Product
Keywords
"Incorrect result" ; "Join Varchar" ; , KBA , BC-SYB-IQ , Sybase IQ , 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.
SAP Knowledge Base Article - Preview