Home / server / Questions / 240340
Accepted
James
Asked: 2011-02-26 09:06:12 +0800 CST

Problems using Crystal reports infoview over the internet

  • 772

We have a Bobje installation and use crystal reports infoview to share some of our reports with our customers over the internet. Most reports will work ok however any reports that take 'longer' seem to fail. Longer being about 3-4 mins. If we run the same reports on the local network they work fine. In fact we have some reports that take 10-15 mins that return fine locally but not over the internet.

We have been in contact with SAP about this and have not had any satisfactory solution (so far!!). Mostly getting browser and java version. We have also increased as many timeouts as we can but this has had no effect.

We are now at a loss about what to do next. One suggestion is that it may be 'network' related but I am unsure as to where to start on that one. another idea is that it may be an OS socket timeout ??

Additional Information:

  • Server RH 4
  • Bobje version XI 3.1 fix pack 1.5
  • Oracle 10g RAC

Any help would be much appreciated.

James

tomcat linux sap crystalreports

3 Answers

  1. Where to go next: I'd get a sniffer of some kind to determine exactly what's going on. Wireshark is a great tool for troubleshooting issues like this. You'll see exactly what's happening over the network. Take one baseline capture locally, then another with a remote client connecting. Compare the two and see where things are different.

    My guess: you've got a stateful firewall somewhere in the equation that's killing the connection after a given number of idle minutes. Some method of TCP keepalive would be necessary to maintain the connection.

    • 0
  2. Best Answer

    I think I found something you may be able to use:

    http://vivekagarwal.wordpress.com/2009/07/04/firewall-dropping-oracle-database-connections-in-websphere-connection-pool/

    The solution that we ended up with was to work around this issue on the Oracle end. We modified the sqlnet.expire_time parameter in sqlnet.ora on the Oracle 10g server down from the default “30″ (30 minutes) to “1″ (1 minute).

    The parameter SQLNET.EXPIRE_TIME is used to specify the time interval, in minutes, to send a probe to verify that client/server connections are active. If the probe finds a terminated connection, or a connection that is no longer in use, it returns an error, causing the server process to exit. This parameter is primarily intended for the database server so that it can free up server-side resources that are not in use.

    A side-effect of the probe is that there is TCP-IP activity between the client and the server each time the probe is executed, and the firewall designates the link as an active one. By lowering the probe interval down to a minute, we managed to fool the firewall into leaving the database connections in the connection pool alone, and not terminate them even though the client may not execute a query using the connection for an extended period of time.

    • 0

  3. In the end I configured the embedded tomcat in BO with an ajp connector. I then configured apache httpd with mod_jk. This fixed the issue.

    J

    • 0