SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
OutOfMemoryError

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
OutOfMemoryError
Author Message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post OutOfMemoryError Reply with quote
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 View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
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 View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Reply with quote
Is only one day of 8 hours, one user.
Wed Jul 13, 2011 6:45 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Reply with quote
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 View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Reply with quote
You suggest something?
Wed Jul 13, 2011 6:54 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
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 View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Reply with quote
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 View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post Reply with quote
What can you suggest me?
Thu Jul 14, 2011 12:38 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.