Skip to Content
0
Jun 02, 2011 at 10:17 PM

Extremely large row count during data flow execution, not cartesian

306 Views

What would cause very large row counts like this in data services data flow other than a cartesian join? (I've triple checked for this and even brought in a fresh pair of eyes) I've had this problem before and it went away after a server restart, but I have no idea why. Now it's back and restarting the server doesn't seem to have any effect. The largest table feeding the query is 4974 records.

So far I've tried to restarting the server, and compacting the repository. I'm thinking that there is a cached version of the data flow somewhere that is causing the problem.

Anyone have any ideas?

Thanks in advance.

Jon

Path Name                                                                                State   Row Count  Elapsed T  Abs Time
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join3: 1                    PROCEED   1443000  3166.339   3187.745
/DF_SAP_Web_Global_Customer_Address/CacheSplit                                              PROCEED      4000     0.406     21.312
/DF_SAP_Web_Global_Customer_Address/KNA1_11                                                 PROCEED         0     0.000    20.843
/DF_SAP_Web_Global_Customer_Address/ADRC2                                                   PROCEED      4000     0.422     21.312
/DF_SAP_Web_Global_Customer_Address/TPART4                                                  PROCEED         0     0.000     22.952
/DF_SAP_Web_Global_Customer_Address/CacheSplitMemoryReader                                  PROCEED   1444000  3167.238   3188.644
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join3: 0                    PROCEED         0     0.000     20.874
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress_SAP_GLOBAL_CUSTOMER_ADDRESS READY           0     0.000     20.343
/DF_SAP_Web_Global_Customer_Address/KNA16                                                   PROCEED  18141000  3166.171   3189.186
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-JoinCache8                  PROCEED         0     0.000     22.984
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress: 0                          PROCEED  16887000  3165.375   3189.140
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress: 1                          PROCEED         0     0.000     23.796
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-JoinCacheReader11           PROCEED         0     0.000     23.765
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join9: 0                    PROCEED 108951000  3166.187   3189.155
/DF_SAP_Web_Global_Customer_Address/CacheSplit[1]                                           PROCEED         0     0.000     22.952
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join9: 1                    PROCEED  18140000  3166.094   3189.124
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-JoinCache12                 PROCEED         0     0.000     23.780
/DF_SAP_Web_Global_Customer_Address/KNVP10                                                  PROCEED         0     0.000     23.796
/DF_SAP_Web_Global_Customer_Address/CacheSplitMemoryReader[1]                               PROCEED 108952000  3166.219   3189.171
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join5: 0                    PROCEED   1184000  3165.459   3188.396
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-JoinCacheReader7            PROCEED         0     0.000     22.968
/DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join5: 1                    PROCEED 108951000  3166.141   3189.109