Error E-reg-002-029 Soft Limit Exceeded For Region
gateway issue 3 replies Latest Post - 2014-02-05T12:33:18Z by Jessedan Display:ConversationsBy Date 1-4 of 4 Previous Next gurunk 2700042QVU 3 Posts Pinned topic Netcool Oracle gateway issue 2013-08-12T12:07:41Z | Tags: Answered question This question has been answered. Unanswered question This question has not been answered yet. Hi All, we are having an issue with Oracle gateway ,where gateway stops transferring alerts to database by throwing softlimit errors. we are in process of upgrading gateway to JDBC binary till then we want to fix this issue. as of now ,we are deleting all files from $OMNIBUS/var/* directory and restarting oracle gareway to fix this issue whenever we face this problem. Someone please suggest if you have any idea on this issue ? have omnibus 7.3.1 and Oracle gateway version 5.8.0. below are proeprty details set in gateway property file. Gate.RegionSoftLimitInc : 100 Gate.RegionSoftLimit : 200 Gate.RegionHardLimit : 400 Gate.OverLoadPeriod : 300 Gate.OverLoadThreshold : 90 Gate.IDUCFlushRate : 60 errors: nco_g_oracle.log_20130808-0000:2013-08-07T04:07:27: Error: E-REG-002-029: Soft limit exceeded for region : status_upd_workarea nco_g_oracle.log_20130808-0000:2013-08-07T04:07:27: Error: E-REG-002-029: Soft limit exceeded for region : status_upd_workarea Regards, Guru Log in to reply. AjayKumar_Singh 270006JY5J 1 Post Re: Netcool Oracle gateway issue 2013-10-22T10:55:18Z This is the accepted answer. This is the accepted answer. Try Increasing the value for soft limit and hard limit depending upon the availability of Memory on the server. The issue clearly seems to be of the size of data it is caching , what is the volume of data in the source tables? Log in to reply. idocs 06000187VH 12 Posts Re: Netcool Oracle gateway issue 2013-11-07T15:26:16Z This is the accepted answer. This is the accep
object server; softlimit; hardlimit; omnibus; region soft limit exceeded Technote (FAQ) Question What is this ObjectServer error message? "Error: E-OBJ-102-019: Failed to execute parsed language command. (-402:Region soft limit exceeded)" Cause The default size of storage for table data was exceeded. Answer The error means the default size of storage for table data with the v7.x ObjectServer which by default (in 7.0.3 +) is 450 MB Soft Limit, 500 MB Hard Limit, was exceeded. The next step is to increase the Hard and Soft limit. The general guideline is to use 6Kb per row max and multiply with the https://www.ibm.com/developerworks/community/forums/html/topic?id=3cc7c039-fb0f-4d04-afd6-1f0db4a3a506 number of resident events in the object server for all 3 tables (status, journal and details), in order to decide the Hard and Soft limit size. In addition, to increase the Hard limit please stop the object server and issue the following command $OMNIHOME/bin/nco_store_resize -newhardlimit
[ date ] [ thread ] [ subject ] [ author ] Hi, i`m running on solaris, i try change soft/hard limits but it not helps. Marek On Nov 29, 2010, at 4:40 PM, Andrea Tiso wrote: > I have experienced similar problems with Oracle Gateways 4.0 e 5.0 installed https://netcoolusers.org/archives/users/2010-November/060469.html on Netcool/OMNIBus 7.2.1 over HP-UX operating system. > > I have configured three Oracle Gateways in production environment and other four Gatways in test environment and all of this are workiging well. > > I'm using this settings: > > Gate.RegionSoftLimit http://markmail.org/message/gqqm7w7kqepg4ibl : 40 > Gate.RegionHardLimit : 80 > Gate.RegionSoftLimitInc : 20 > > On HP-UX, the best way to solve the problem is enabling the nco_g_oracle executable to use third and fourth quadrant private data space using "chatr" command. > > Usually error e-reg-002-029 on HP-UX third and fourth quadrant private data space are not enabled and you can check this issuing the command: > > chatr nco_g_oracle > > To enable third and fourth quadrant private data space you can issue the following commands: > > chatr +q3p enable nco_g_oracle > chatr +q4p enable nco_g_oracle > > Best regards > ________________________________ > > TISO Andrea > > T.IT.SO.CA - Network Assurance & Performance Management > > e-mail: a.tiso at eustema.it > > ________________________________ > > error e-reg-002-029 soft > -----Messaggio originale----- > Da: users-bounces at netcoolusers.org [mailto:users-bounces at netcoolusers.org] Per conto di Ajay Sharma5 > Inviato: lunedì 29 novembre 2010 9.34 > A: users at netcoolusers.org; zidekm at gmail.com > Oggetto: Re: [INUG-Users] Oracle Gateway Problem > > Try to play with the hard and soft limit property settings in the .props > file of Oracle GW. > > and follow this as well .. > > > 1)Each gateway work region is kept in memory up to the soft limit. Once the > soft limit is exceeded, the work region is stored on disk up until the hard > limit. If the hard limit is exceeded, the gateway will shut down. > 1)If received occasionally during periods of heavy load, this error is > normal. If received regularly, it can indicate that the gateway is not > keeping up with the number of events. Check the statistics number of the > gateway. > 3)The property Gate.RegionSoftLimit can be increased to specify the amount > of memory the gateway will use. Available system memory should be > 7*Gate.RegionSoftLimit. > > > Clear the contents under $OMNIHOME/var/ for the GW and restart it. > > Hope it helps. > > Regards > Ajay M Sharma > Cell - 09999459922 > > "Begin by always EXPECTING good things to happen" > > > > From: Marek Židek
search in one of my setsExclude this search from one of my sets 3 messages in org.netcoolusers.usersRe: [INUG-Users] Events not being pas...FromSent OnAttachmentsMarisa MolchanyJan 24, 2008 7:10 am James FarrowJan 24, 2008 7:41 am tref...@realitybytes.netJan 24, 2008 7:51 am Subject:Re: [INUG-Users] Events not being passed via Oracle GatewayFrom:James Farrow (netc...@gmail.com)Date:Jan 24, 2008 7:41:59 amList:org.netcoolusers.usersMarisa There is in-depth discussions about this message on many previous threads on INUG which you can refer to for more information (so I won't got over that again here) but to start with try increasing the values you have here Gate.RegionSoftLimit : 60 Gate.RegionHardLimit : 120 to something like this Gate.RegionSoftLimit : 200 Gate.RegionHardLimit : 450 Do you see the same "offline" message after starting up the gateway? James On 24/01/2008, Marisa Molchany