Skip to Content
0
Former Member
Nov 08, 2012 at 07:01 AM

Request number for datamart is not available in some requests monitor

21 Views

Hi Gurus,

we are having data flow from DSO to inventory CUBE for goods movements.From last few month some stock qty are comming as -ive which should not come.

After analysis i came to know this might be beacause of duplicates request load from dso to cube. After investigation i got the following findings:

DSO Load Date DSO Request# Cube request# Cube Load date 03.09.2012 REQU_A04QDTBAI6B4NR5K19SB9TXFV REQU_1EGC3QZD3JPJCCJTEOYHVN6H7 03.09.2012 31.08.2012 REQU_1AEO64G2FN381MKX13OVZRXXN REQU_4GVPQGKQCGFUYIRNTHAEK0TXN 31.08.2012 31.08.2012 REQU_1C9I9D10FOSWB3HLZNLQ4OZ2J 30.08.2012 REQU_8337OGNX7HZXKUIMASPH9QJRF 30.08.2012 REQU_BSJLMJDL8C7W0B1DAIHB3AK5N 30.08.2012 REQU_BSJLMJDL8C7W0B1DAIHB3AK5N REQU_084AKGXA4OLU61WUELDWLSFPN 30.08.2012

REQU_4GVPQGKQCGFUYIRNTHAEK0TXN is repeat delta which includes all 30 and 31st request from dso.

Question :

1. REQU_084AKGXA4OLU61WUELDWLSFPN in cube donot show request# REQU_BSJLMJDL8C7W0B1DAIHB3AK5N in monitor. This is only by records count i am able to identify. This case exist with some more request in cube. Why it is not showing request# fron which data is taken.?

2. Why REQU_4GVPQGKQCGFUYIRNTHAEK0TXN include data from request#REQU_BSJLMJDL8C7W0B1DAIHB3AK5N repeatedly.

Any suggestion would be helpful.

Thanks

Rishi