SDCCN EWA Request Session runs very Slow

[Former Member]

Hi Team,

Recently I’ve configured EWA for a productive ECC PRD, but the request session task for EWA takes around 10 hours to be generated.  Most of the time is taken in some steps as shown in the following lines between 2:54 to 6:43 and between 06:43 to 10:41. After these steps the process finish.

24.02.2014 10:42:01  > SEWA_GET_ABAP_DUMPS : # of tables in funcmod > # of tables in mod 001041

24.02.2014 10:42:01  > SEWA_GET_ABAP_DUMPS : inconsistency in # of tables found for mod 001041

24.02.2014 10:41:58 RSDDCVER_RFC_BW_WHM_STAT : Approximate Download with module 000684

24.02.2014 10:41:58  > Difference in function interface

24.02.2014 10:41:56 RSDDCVER_RFC_BW_STATISTICS : Approximate Download with module 000663

24.02.2014 10:41:56  > Difference in function interface

24.02.2014 10:41:55 RSDDCVER_AGGREGATES : Approximate Download with module 000734

24.02.2014 10:41:55  > Difference in function interface

24.02.2014 10:41:53 RSAR_ROIDOCPRMS_GET_ALL : Approximate Download with module 000682

24.02.2014 10:41:53  > Difference in function interface

24.02.2014 10:41:46 DB6_HIST_BUFFERPOOL : exception NO_HISTORY_FOUND raised on XXXXXXX_PRD_00

24.02.2014 10:41:46 DB6_HIST_DB : exception NO_HISTORY_FOUND raised on XXXXXXXX_PRD_00

24.02.2014 06:43:27 DB6_DBH_RESOURCES : Approximate Download with module 000246

24.02.2014 06:43:27  > Difference in function interface

24.02.2014 06:43:19 SQL_STMT_DB6 : Time limit exceeded. on XXXXXXXXXX_PRD_00

24.02.2014 02:54:48  > SQL_STMT_DB6 : # of tables in funcmod > # of tables in mod 000184

24.02.2014 02:54:48  > SQL_STMT_DB6 : inconsistency in # of tables found for mod 000184

24.02.2014 02:54:48  > SQL_STMT_DB6 : # of imp params in funcmod > # of imp params in mod 000184

24.02.2014 02:54:48  > SQL_STMT_DB6 : inconsistency in # of imp params found for mod 000184

24.02.2014 02:54:46  > DB6_DBSIZE_HISTORY : # of imp params in funcmod > # of imp params in mod 001152

24.02.2014 02:54:46  > DB6_DBSIZE_HISTORY : inconsistency in # of imp params found for mod 001152

Please, do you have any idea about what could be happening? PRD System is an ECC 6.0, kernel 7.21, recently migrated from WIN/ORA to DB2/AIX.

Thanks in advance

Best Regards,

Enrique Sánchez.

[Former Member]

Hello ,

I have the same fix. How do you fix this problem?

Thks

Javier