What could impact 1st package arrived under Request Analysis(InfoPackage)?

Apr 11, 2017 at 08:01 AM


avatar image

Dear experts,

Wir experience performance issues with several InfoPackages. For example, it can take 60 min overall, but 58 min on "1st package arrived [HH:MM:SS]" while normally it takes 5 to 15 min overall. I wonder what happens during "1st package arrived [HH:MM:SS]". What should be checked to acquire further details on this?

Thank you in advance and best regards,

Ren Liu

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

John Hawk Apr 12, 2017 at 06:29 PM

Hi Ren,

The more details you can provide, the easier it is to help. Which DataSources are you using? Which version of BW and Service Pack? What database and version?

Some BI content DataSource require the generation of a staging table and code at run time. Once the table and code is generated, follow on data moves much more quickly.

Consider reducing your infoPackage size. You may be facing an NxN issue.

Good luck, and don't forget to recored your solution.

John Hawk

10 |10000 characters needed characters left characters exceeded
Skip to Content