Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

Hanging up the Application Server after close the client.

edited June 2008 in Server
Hi everyone,



I'm new user of the RB Server. I'm trying to build an application like
show us the tutorial (Building a Report Server Application for reports on
Forms), but I'm getting unexpected result. After I close the client, the
application server hangs up and I have kill the process from the task
manager. I don't know what I doing wrong.



I'm using RAD Studio 2007 and RB Server 10.08 with DOA 4.1.0.0 with Oracle
11g.



I added an unit of Labels to my application server with one TOracleSession,
TOracleClientDataSet and TppDBEPipeline, I opened it in
BeforeOpenDataPipelines event.



Can you help me with this?

Comments

  • edited June 2008

    Try a test in which you run the client application and preview the report
    (let's call it Report A) and then preview a different report (Report B) and
    then go back and preview Report A.

    If that works correctly, then the create/destroy of the forms is probably
    working ok.

    You can also try running the server application under the Delphi debugger to
    see if any AV's occurs.

    I have noticed that in a correctly working server application, when you go
    to shut it down, it can sometimes hang. However, if you install
    ReportBuilder Services and run the report server within that context, it
    should run fine.

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited June 2008
    Hi Nard,

    Thank a lot for your help, I did your test and it works well, I can lunch
    Report A and Report B many times and there aren't problem, but after I close
    the preview of the first report showed, I can't access the application
    server. It isn't a problem, but when I want to close the application server
    it dosn't work.

    The only way to close it is kill the process.

    Is it normal?

  • edited June 2008

    I recommed using ReportBuilder Services to host your report server. This is
    the preferred way to run the report server. For details see RBServer\Windows
    Service\ReadMe.doc

    I think this will solve the issue you are describing. Additional benefits
    are that the report server can start automatically each time you reboot the
    machine; in the event of a crash, the server will try to restart itself.

    Basically in about 5 minutes you can have your existing report server
    application running as a windows service, with a tray icon that you can use
    to start/stop the server.
    For the report server project..

    1. Add rsServerActiveX to the 'uses' clause and rebuild.

    2. Install RB Services by running RBServer\Windows Service\RBWinService.exe

    3. Double-click the 'R' icon that appears in the system tray. Select the
    'change' button to browse to your report server .exe file. Then press the
    'start' button to start the server.



    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited June 2008
    Hi Nard,

    I did your advice and it works ok. When I stoped the RB service the
    Application Server stoped too.

    Thank very mouch by your help.

    Richard.
This discussion has been closed.