Author |
Message |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
OutOfMemoryError |
|
In the log of report:
22517 records found.
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at java.lang.String.<init>(String.java:174)
at AlertJob.main(Unknown Source)
If I increased using this line:
java -Xms1024m -jar alertCenter.jar /JOB 196
The report not send to my e-mail, only quit the message of error in the log.
|
|
Wed Jul 13, 2011 5:55 pm |
|
 |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
|
|
IOException while running socketReader: java.net.SocketException: Connection reset
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at java.net.SocketInputStream.read(SocketInputStream.java:182)
at java.io.DataInputStream.readInt(DataInputStream.java:353)
at com.sybase.dpb.AsyncSocketReader.run(AsyncSocketReader.java:41)
Alert Center only achieved that is not left hanging. The report not generated.
|
|
Wed Jul 13, 2011 6:03 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
I think you are trying to generate report HTML file which is too big for the system and that's why you are getting out-of-memory exceptions. Please modify maximum number of records parameter to some reasonable value. This will limit the report size.
You can also update repot definitions to pull only the data you need, for example narrow the scope of the report from 1 week to 1 day and run once a day rather than once a week.
|
|
Wed Jul 13, 2011 6:43 pm |
|
 |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
|
|
Is only one day of 8 hours, one user.
|
|
Wed Jul 13, 2011 6:45 pm |
|
 |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
|
|
I have in log:
22517 records found.
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at java.lang.String.<init>(String.java:174)
at AlertJob.main(Unknown Source)
IOException while running socketReader: java.net.SocketException: Connection reset
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at java.net.SocketInputStream.read(SocketInputStream.java:182)
at java.io.DataInputStream.readInt(DataInputStream.java:353)
at com.sybase.dpb.AsyncSocketReader.run(AsyncSocketReader.java:41)
In report Options:
5000 max lines
750 KB
This is some real value.
|
|
Wed Jul 13, 2011 6:54 pm |
|
 |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
|
|
You suggest something?
|
|
Wed Jul 13, 2011 6:54 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
The root cause of the error: the report size exceeds maximum allowed for the process memory. When you increased the memory parameter, the report is created but it is still too big for the email attachment.
Please verify the report zip option value. Try setting it to 1 to have all reports zipped before sending.
|
|
Thu Jul 14, 2011 9:53 am |
|
 |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
|
|
I changed, I get the same:
Sin parámetro de memoria:
22517 records found.
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at java.lang.String.<init>(String.java:174)
at AlertJob.main(Unknown Source)
Con parámetro de memoria (-Xms1024m):
22517 records found.
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at java.lang.String.<init>(String.java:174)
at AlertJob.main(Unknown Source)
IOException while running socketReader: java.net.SocketException: Connection reset
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at java.net.SocketInputStream.read(SocketInputStream.java:182)
at java.io.DataInputStream.readInt(DataInputStream.java:353)
at com.sybase.dpb.AsyncSocketReader.run(AsyncSocketReader.java:41)
|
|
Thu Jul 14, 2011 10:25 am |
|
 |
lorellan
Joined: 13 Jun 2011 Posts: 124 Country: Ecuador |
|
|
|
What can you suggest me?
|
|
Thu Jul 14, 2011 12:38 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
How long does it take for the job to run before you get OutOfMemory error?
Are there any related errors reported in your Sybase server logs? Connection terminated, connection timeout, something else?
|
|
Thu Jul 14, 2011 6:51 pm |
|
 |
|