Hi,

I have a log FILE having a size of 48 mb.

I have to remove all the date and time entries and to remove all the duplicate lines in that log file.

I am able to do it through excel, but unable to do it through Command Prompt.

Kindly , guide me through this.

Regards,
Pankaj
you can at least show US how your data look like, and how you want your final output to look .... Hi,

Please find below log file.

I want to do FOLLOWING things with this .
My aim is to get all the error messages and exceptions
with following PRE conditions

1) to remove all the date and time from the log file
2) To remove all the duplicate rows from the same.
3) To remove all the lines that shows the message like

"at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.(RandomAccessFile.java:212)"


I want the ouptut as ,

ERROR impl.ProfileSearchManagerImpl - /JhomeProductionOpenPort/JhomeJuly17/search/user/Ixo0PRS9/_2ox.cfs (No such file or directory)
java.io.FileNotFoundException: /JhomeProductionOpenPort/JhomeJuly17/search/user/Ixo0PRS9/_2ox.cfs (No such file or directory)

ERROR interceptor.ExceptionMappingInterceptor -
java.lang.NullPointerException




You can use the below demo log file for the same.



29 Jul 2009 04:36:53,915 [ajp-0.0.0.0-8310-415] ERROR impl.ProfileSearchManagerImpl - /JhomeProductionOpenPort/JhomeJuly17/search/user/Ixo0PRS9/_2ox.cfs (No such file or directory)
java.io.FileNotFoundException: /JhomeProductionOpenPort/JhomeJuly17/search/user/Ixo0PRS9/_2ox.cfs (No such file or directory)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.(RandomAccessFile.java:212)
at org.apache.lucene.store.FSDirectory$FSIndexInput$Descriptor.(FSDirectory.java:506)
at org.apache.lucene.store.FSDirectory$FSIndexInput.(FSDirectory.java:536)
at org.apache.lucene.store.FSDirectory.ope nInput(FSDirectory.java:445)
at org.apache.lucene.index.CompoundFileRea der.(CompoundFileReader.java:70)
at org.apache.lucene.index.SegmentReader.i nitialize(SegmentReader.java:277)
at org.apache.lucene.index.SegmentReader.g et(SegmentReader.java:262)
at org.apache.lucene.index.SegmentReader.g et(SegmentReader.java:197)
at org.apache.lucene.index.MultiSegmentRea der.(MultiSegmentReader.java:55)
at org.apache.lucene.index.DirectoryIndexR eader$1.doBody(DirectoryIndexReader.java:75)
at org.apache.lucene.index.SegmentInfos$FindSegmentsFile.run(SegmentInfos.java:636)
at org.apache.lucene.index.DirectoryIndexR eader.open(DirectoryIndexReader.java:63)
at org.apache.lucene.index.IndexReader.ope n(IndexReader.java:209)
at org.apache.lucene.index.IndexReader.ope n(IndexReader.java:192)
at com.JSoftware.community.impl.ProfileSea rchManagerImpl.getSearcher(ProfileSearchManagerImpl.java:1567)
at com.JSoftware.community.impl.ProfileSea rchManagerImpl.getSimilarUserResults(ProfileSearchManagerImpl.java:769)
at com.JSoftware.community.proxy.ProfileSe archManagerProxy.getSimilarUserResults(ProfileSearchManagerProxy.java:85)
at com.JSoftware.community.action.ViewProf ile.getSimilarUsers(ViewProfile.java:983)
at sun.reflect.GeneratedMethodAccessor906. invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImp l.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:823)
at ognl.OgnlRuntime.getMethodValue(OgnlRuntime.java:1386)
at ognl.ObjectPropertyAccessor.getPossible Property(ObjectPropertyAccessor.java:60)
at ognl.ObjectPropertyAccessor.getProperty(ObjectPropertyAccessor.java:147)
at com.opensymphony.xwork2.util.OgnlValueS tack$ObjectAccessor.getProperty(OgnlValueStack.java:72)
at ognl.OgnlRuntime.getProperty(OgnlRuntime.java:2165)
at com.opensymphony.xwork2.util.CompoundRo otAccessor.getProperty(CompoundRootAccessor.java:101)
at ognl.OgnlRuntime.getProperty(OgnlRuntime.java:2165)
at ognl.ASTProperty.getValueBody(ASTProperty.java:114)
at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
at ognl.SimpleNode.getValue(SimpleNode.java:258)
at ognl.Ognl.getValue(Ognl.java:494)
at ognl.Ognl.getValue(Ognl.java:458)
at com.opensymphony.xwork2.util.OgnlUtil.g etValue(OgnlUtil.java:190)
at com.opensymphony.xwork2.util.OgnlValueS tack.findValue(OgnlValueStack.java:228)
at org.apache.struts2.views.freemarker.Sco pesHashModel.get(ScopesHashModel.java:69)
at freemarker.core.Environment.getGlobalVa riable(Environment.java:1057)
at freemarker.core.Environment.getVariable(Environment.java:1043)
at freemarker.core.Identifier._getAsTempla teModel(Identifier.java:70)
at freemarker.core.Expression.getAsTemplat eModel(Expression.java:89)
at freemarker.core.BuiltIn$existsBI._getAsTemplateModel(BuiltIn.java:639)
at freemarker.core.BuiltIn$existsBI.isTrue(BuiltIn.java:650)
at freemarker.core.AndExpression.isTrue(AndExpression.java:68)
at freemarker.core.ParentheticalExpression .isTrue(ParentheticalExpression.java:66)
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:77)
at freemarker.core.Environment.visit(Environment.java:208)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:208)
at freemarker.core.Environment.process(Environment.java:188)
at freemarker.template.Template.process(Template.java:237)
at com.JSoftware.community.web.struts.Free markerResult.doExecute(FreemarkerResult.java:107)
at org.apache.struts2.dispatcher.StrutsRes ultSupport.execute(StrutsResultSupport.java:178)
at com.opensymphony.xwork2.DefaultActionIn vocation.executeResult(DefaultActionInvocation.java:320)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:229)
at com.JSoftware.community.action.RecentHi storyInterceptor.doIntercept(RecentHistoryInterceptor.java:72)
at com.opensymphony.xwork2.interceptor.Met hodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.web.struts.Flas hInterceptor.intercept(FlashInterceptor.java:41)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Def aultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:221)
at com.opensymphony.xwork2.interceptor.Met hodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.validator.Valid ationInterceptor.doIntercept(ValidationInterceptor.java:150)
at com.opensymphony.xwork2.interceptor.Met hodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Con versionErrorInterceptor.intercept(ConversionErrorInterceptor.java:123)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.web.struts.JSof twareConversionErrorInterceptor.interce pt(JSoftwareConversionErrorInterceptor.jav a:35)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.action.LocaleIn terceptor.intercept(LocaleInterceptor.java:68)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Par ametersInterceptor.doIntercept(ParametersInterceptor.java:184)
at com.opensymphony.xwork2.interceptor.Met hodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Sta ticParametersInterceptor.intercept(StaticParametersInterceptor.java:105)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at org.apache.struts2.interceptor.Checkbox Interceptor.intercept(CheckboxInterceptor.java:83)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at org.apache.struts2.interceptor.FileUplo adInterceptor.intercept(FileUploadInterceptor.java:207)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Mod elDrivenInterceptor.intercept(ModelDrivenInterceptor.java:74)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Sco pedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:127)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at org.apache.struts2.interceptor.debuggin g.DebuggingInterceptor.intercept(DebuggingInterceptor.java:206)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Cha iningInterceptor.intercept(ChainingInterceptor.java:115)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.I18 nInterceptor.intercept(I18nInterceptor.java:143)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Pre pareInterceptor.doIntercept(PrepareInterceptor.java:121)
at com.opensymphony.xwork2.interceptor.Met hodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at org.apache.struts2.interceptor.ServletC onfigInterceptor.intercept(ServletConfigInterceptor.java:170)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Ali asInterceptor.intercept(AliasInterceptor.java:123)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Exc eptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.web.struts.Requ ireFeatureInterceptor.intercept(RequireFeatureInterceptor.java:36)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.web.struts.Modu leCheckInterceptor.intercept(ModuleCheckInterceptor.java:47)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.aaa.authz.Requi reAuthorizationInterceptor.intercept(RequireAuthorizationInterceptor.java:51)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.aaa.authz.Guest AuthorizationInterceptor.intercept(GuestAuthorizationInterceptor.java:56)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.web.struts.JSof twareRefererInterceptor.intercept(JSoftwareRefererInterceptor.java:43)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at org.apache.struts2.impl.StrutsActionPro xy.execute(StrutsActionProxy.java:50)
at org.apache.struts2.dispatcher.Dispatche r.serviceAction(Dispatcher.java:504)
at org.apache.struts2.dispatcher.FilterDis patcher.doFilter(FilterDispatcher.java:422)
at com.JSoftware.community.web.struts.JSof twareFilterDispatcher.doFilter(JSoftwareFilterDispatcher.java:101)
at org.springframework.web.filter.Delegati ngFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.Delegati ngFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.SetR esponseCharacterEncodingFilter.doFilter (SetResponseCharacterEncodingFilter.java:61)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.opensymphony.module.sitemesh.filter .PageFilter.parsePage(PageFilter.java:119)
at com.opensymphony.module.sitemesh.filter .PageFilter.doFilter(PageFilter.java:55)
at org.springframework.web.filter.Delegati ngFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.Delegati ngFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.ActionCon textCleanUp.doFilter(ActionContextCleanUp.java:99)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.JSof twareCacheFilter.doFilter(JSoftwareCacheFilter.java:208)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.JSof twareDynamicResponseHeaderFilter.doFilt er(JSoftwareDynamicResponseHeaderFilter.ja va:65)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.Pres enceFilter.doFilterInternal(PresenceFilter.java:137)
at org.springframework.web.filter.OncePerR equestFilter.doFilter(OncePerRequestFilter.java:76)
at org.springframework.web.filter.Delegati ngFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.Delegati ngFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.JSof twareCompressionFilter.doFilter(JSoftwareCompressionFilter.java:103)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.util.NoCacheFilter.doFilt er(NoCacheFilter.java:66)
at org.acegisecurity.util.FilterToBeanProx y.doFilter(FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at org.directwebremoting.servlet.DwrWebCon textFilter.doFilter(DwrWebContextFilter.java:91)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.base.plugin.PluginFilter. doFilter(PluginFilter.java:75)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at com.JSoftware.community.aaa.JSoftwareAu thenticationTranslationFilter.doFilter(JSoftwareAuthenticationTranslationFilte r.java:164)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslati onFilter.doFilter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at com.JSoftware.community.aaa.FeedsBasicP rocessingFilter.doFilter(FeedsBasicProcessingFilter.java:146)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.rememberme.Remembe rMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:135)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessing Filter.doFilter(AbstractProcessingFilter.java:271)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at com.JSoftware.community.aaa.SessionTrac kingFilter.doFilter(SessionTrackingFilter.java:53)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at com.infosys.saas.socialcommerce.web.fil ter.PlatformSecurityFilter.doFilter(PlatformSecurityFilter.java:77)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionCo ntextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.jav a:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at com.infosys.saas.socialcommerce.web.fil ter.PlatformForceHttpsFilter.doFilter(PlatformForceHttpsFilter.java:89)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy .doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProx y.doFilter(FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.Appl icationStateFilter.doFilter(ApplicationStateFilter.java:145)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeade rFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrappe rValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContex tValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityA ssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccConte xtValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostVa lve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportV alve.invoke(ErrorReportValve.java:104)
at com.infosys.saas.socialcommerce.jboss.c ookie.PlatformCookieHandler.invoke(PlatformCookieHandler.java:66)
at org.jboss.web.tomcat.service.jca.Cached ConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngine Valve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAda pter.service(CoyoteAdapter.java:241)
at org.apache.coyote.ajp.AjpProcessor.proc ess(AjpProcessor.java:437)
at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:381)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:595)
29 Jul 2009 04:36:53,956 [ajp-0.0.0.0-8310-140] ERROR com.JSoftware - com.JSoftware.community.ForumThreadNotF oundException: Thread 5174 could not be loaded from the database.
29 Jul 2009 04:36:58,335 [ajp-0.0.0.0-8310-239] ERROR interceptor.ExceptionMappingInterceptor -
java.lang.NullPointerException
at com.JSoftware.community.action.RSSPolls .execute(RSSPolls.java:95)
at sun.reflect.GeneratedMethodAccessor3418 .invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImp l.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.opensymphony.xwork2.DefaultActionIn vocation.invokeAction(DefaultActionInvocation.java:376)
at com.opensymphony.xwork2.DefaultActionIn vocation.invokeActionOnly(DefaultActionInvocation.java:239)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:213)
at com.JSoftware.community.web.struts.Flas hInterceptor.intercept(FlashInterceptor.java:41)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Def aultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:221)
at com.opensymphony.xwork2.interceptor.Met hodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.validator.Valid ationInterceptor.doIntercept(ValidationInterceptor.java:150)
at com.opensymphony.xwork2.interceptor.Met hodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Con versionErrorInterceptor.intercept(ConversionErrorInterceptor.java:123)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.web.struts.JSof twareConversionErrorInterceptor.interce pt(JSoftwareConversionErrorInterceptor.jav a:35)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.action.LocaleIn terceptor.intercept(LocaleInterceptor.java:68)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Par ametersInterceptor.doIntercept(ParametersInterceptor.java:184)
at com.opensymphony.xwork2.interceptor.Met hodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Sta ticParametersInterceptor.intercept(StaticParametersInterceptor.java:105)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at org.apache.struts2.interceptor.Checkbox Interceptor.intercept(CheckboxInterceptor.java:83)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at org.apache.struts2.interceptor.FileUplo adInterceptor.intercept(FileUploadInterceptor.java:207)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Mod elDrivenInterceptor.intercept(ModelDrivenInterceptor.java:74)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Sco pedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:127)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at org.apache.struts2.interceptor.debuggin g.DebuggingInterceptor.intercept(DebuggingInterceptor.java:206)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Cha iningInterceptor.intercept(ChainingInterceptor.java:115)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.I18 nInterceptor.intercept(I18nInterceptor.java:143)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Pre pareInterceptor.doIntercept(PrepareInterceptor.java:121)
at com.opensymphony.xwork2.interceptor.Met hodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at org.apache.struts2.interceptor.ServletC onfigInterceptor.intercept(ServletConfigInterceptor.java:170)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Ali asInterceptor.intercept(AliasInterceptor.java:123)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.opensymphony.xwork2.interceptor.Exc eptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.web.struts.Requ ireFeatureInterceptor.intercept(RequireFeatureInterceptor.java:36)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.web.struts.Modu leCheckInterceptor.intercept(ModuleCheckInterceptor.java:47)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.aaa.authz.Requi reAuthorizationInterceptor.intercept(RequireAuthorizationInterceptor.java:51)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.aaa.authz.Guest AuthorizationInterceptor.intercept(GuestAuthorizationInterceptor.java:56)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at com.JSoftware.community.web.struts.JSof twareRefererInterceptor.intercept(JSoftwareRefererInterceptor.java:43)
at com.opensymphony.xwork2.DefaultActionIn vocation.invoke(DefaultActionInvocation.java:211)
at org.apache.struts2.impl.StrutsActionPro xy.execute(StrutsActionProxy.java:50)
at org.apache.struts2.dispatcher.Dispatche r.serviceAction(Dispatcher.java:504)
at org.apache.struts2.dispatcher.FilterDis patcher.doFilter(FilterDispatcher.java:422)
at com.JSoftware.community.web.struts.JSof twareFilterDispatcher.doFilter(JSoftwareFilterDispatcher.java:101)
at org.springframework.web.filter.Delegati ngFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.Delegati ngFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.SetR esponseCharacterEncodingFilter.doFilter (SetResponseCharacterEncodingFilter.java:61)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.opensymphony.module.sitemesh.filter .PageFilter.doFilter(PageFilter.java:39)
at org.springframework.web.filter.Delegati ngFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.Delegati ngFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.ActionCon textCleanUp.doFilter(ActionContextCleanUp.java:99)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.JSof twareCacheFilter.doFilter(JSoftwareCacheFilter.java:208)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.JSof twareDynamicResponseHeaderFilter.doFilt er(JSoftwareDynamicResponseHeaderFilter.ja va:65)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.JSof twareDynamicResponseHeaderFilter.doFilt er(JSoftwareDynamicResponseHeaderFilter.ja va:65)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.Pres enceFilter.doFilterInternal(PresenceFilter.java:137)
at org.springframework.web.filter.OncePerR equestFilter.doFilter(OncePerRequestFilter.java:76)
at org.springframework.web.filter.Delegati ngFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.Delegati ngFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.JSof twareCompressionFilter.doFilter(JSoftwareCompressionFilter.java:103)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.JSof twareCompressionFilter.doFilter(JSoftwareCompressionFilter.java:103)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.util.NoCacheFilter.doFilt er(NoCacheFilter.java:66)
at org.acegisecurity.util.FilterToBeanProx y.doFilter(FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at org.directwebremoting.servlet.DwrWebCon textFilter.doFilter(DwrWebContextFilter.java:91)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.base.plugin.PluginFilter. doFilter(PluginFilter.java:75)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at com.JSoftware.community.aaa.JSoftwareAu thenticationTranslationFilter.doFilter(JSoftwareAuthenticationTranslationFilte r.java:164)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslati onFilter.doFilter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at com.JSoftware.community.aaa.FeedsBasicP rocessingFilter.doFilter(FeedsBasicProcessingFilter.java:146)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.rememberme.Remembe rMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessing Filter.doFilter(AbstractProcessingFilter.java:271)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at com.JSoftware.community.aaa.SessionTrac kingFilter.doFilter(SessionTrackingFilter.java:53)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at com.infosys.saas.socialcommerce.web.fil ter.PlatformSecurityFilter.doFilter(PlatformSecurityFilter.java:77)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionCo ntextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.jav a:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at com.infosys.saas.socialcommerce.web.fil ter.PlatformForceHttpsFilter.doFilter(PlatformForceHttpsFilter.java:89)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy .doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProx y.doFilter(FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.Appl icationStateFilter.doFilter(ApplicationStateFilter.java:145)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeade rFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrappe rValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContex tValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityA ssociationValve.invoke(SecurityAssociationValve.java:179)
at org.jboss.web.tomcat.security.JaccConte xtValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostVa lve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportV alve.invoke(ErrorReportValve.java:104)
at com.infosys.saas.socialcommerce.jboss.c ookie.PlatformCookieHandler.invoke(PlatformCookieHandler.java:66)
at org.jboss.web.tomcat.service.jca.Cached ConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngine Valve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAda pter.service(CoyoteAdapter.java:241)
at org.apache.coyote.ajp.AjpProcessor.proc ess(AjpProcessor.java:437)
at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:381)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:595)
29 Jul 2009 04:36:58,426 [ajp-0.0.0.0-8310-407] ERROR interceptor.ExceptionMappingInterceptor -
java.lang.NullPointerException
(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.SetR esponseCharacterEncodingFilter.doFilter (SetResponseCharacterEncodingFilter.java:61)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)

"29 Jul 2009 06:16:59,414 [ajp-0.0.0.0-8310-83] ERROR impl.ProfileSearchManagerImpl - /jivehomeProductionOpenPort/JiveHomeJuly17/search/user/Ixo0PRS9/_2ox.cfs (No such file or directory)"
java.io.FileNotFoundException: /jivehomeProductionOpenPort/JiveHomeJuly17/search/user/Ixo0PRS9/_2ox.cfs (No such file or directory)

at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.opensymphony.module.sitemesh.filter .PageFilter.parsePage(PageFilter.java:119)
at com.opensymphony.module.sitemesh.filter .PageFilter.doFilter(PageFilter.java:55)
at org.springframework.web.filter.Delegati ngFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.Delegati ngFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.ActionCon textCleanUp.doFilter(ActionContextCleanUp.java:99)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.JSof twareCacheFilter.doFilter(JSoftwareCacheFilter.java:208)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.JSof twareDynamicResponseHeaderFilter.doFilt er(JSoftwareDynamicResponseHeaderFilter.ja va:65)

"29 Jul 2009 06:17:04,056 [ajp-0.0.0.0-8310-389] ERROR impl.QueryCache - Error loading block, ObjectType: 14, OBJECTID: 2082"
java.sql.SQLException: ORA-00903: invalid table name
"29 Jul 2009 06:17:04,064 [ajp-0.0.0.0-8310-389] ERROR impl.QueryCache - Error retrieving count"
java.sql.SQLException: ORA-00903: invalid table name
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
at com.JSoftware.community.web.filter.Pres enceFilter.doFilterInternal(PresenceFilter.java:137)
at org.springframework.web.filter.OncePerR equestFilter.doFilter(OncePerRequestFilter.java:76)
at org.springframework.web.filter.Delegati ngFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.Delegati ngFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFil terChain.doFilter(ApplicationFilterChain.java:206)
vbscript.

dictionary object will do the duplicate elimination

Code: [Select]If Not objDictionary.Exists(MyString) Then
objDictionary.Add Mystring, Mystring
End If
The rest is simple