ExportToStream - MULTI USER ENVIRONMENT - ABOUT 20 concurrent users

[Former Member]

Hi:

    Does  Report.ExportToStream(ExportFormatType.PortableDocFormat)

    cause problems in a MULTI USER / CONCURRENT USERS environment?

2 Namespaces being used are :

     using  CrystalDecisions.CrystalReports.Engine;

     using CrystalDecisions.Shared;

     Example:

      -There is a report called “Performance.RPT” in a “Reports” folder under the website named “PKSSSystem”.

      - In production, 20 concurrent users are accessing the same report ““Performance.RPT” , and the report is exported to Stream

           with Report.ExportToStream(ExportFormatType.PortableDocFormat), resultant byte[] array is stored in the database  and pulled back as an pdf file  on a button click “SavePDF”, “GeneratePDf” etc…

      are there any concurrency issues expected as given in the support forums below.

      http://search.sap.com/notes?id=0001892901&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64....

3. Also what are 1CPL and 3 CPL. Do we need to have a concern with CPL stuff while using ExportToStream in the code??

4) Environment: Ms Visual studio 2008, CR reports Engine Version 12.x.CR Engines are available on webserver and directly accessed from the aspx - c# page.

Your quick response is greatly helpful - Thanks

Message was edited by: Ludek Uher

[former_member183750 · Accepted solution]

Hi

CPL (Concurrent Processor License) is always important and yes you do need to be concerned. The report engine is limited to 3 CPL (no way to increase this. not with Crystal Reports - more below). Thus the designed behavior is as follows: three requests are made for a report to be processed. The engine starts to process the reports. a fourth request is made of the engine. this 4th report is placed in a q queue and waits until one of the initial three requests is dome, thus releasing a CPL. 20 concurrent users means that 17 of the users will be waiting, some a long time as you have to release 16 licenses before you get to the 17th request.

The KBA you are referring to specifies that this issue would be resolved in SP 7 and this was the case. E.g.; make sure you are using SP 7 for CR 2008. See the downloads portal for SP 7.

As to increasing the CPL. You have two options; web farms or upgrade to SAP Crystal Reports Server (CRS). CRS can handle up to 25 concurrent requests. For more info re. CRS see:

http://www.sap.com/solution/sme/software/analytics/crystal-bi/index.html

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member · Accepted solution]

Ludek:

Thank You so much. Attached find the file (small file but I gave information on what needed).

This is very important and awaiting your reply.

- Thanks

Aparna

Crystal_ExportToStream_multiUser.txt.zip

[former_member183750 · Accepted solution]

Well, in this case the licensing model is quite different and depends on what licensing your client obtained. In it's infinite, you could throw as many CPUs at this as allowed and then you're essentially unlimited.

- Ludek