| Huge datafiles. [message #54440] |
Mon, 18 November 2002 12:20  |
Pakshi
Messages: 6
Registered: November 2002
|
Junior Member |
|
|
I am having a problem with App server not able to get connections to the database server.
I looked at the database, it has 9 table spaces with each tablespace associated with 1 datafile each.
The size of each tablespace (remember each tablespace has only one datafile each) ranges from 3000 MB to 10,000 MB. With the TEMP tablespace topping it all with a size of 33,000 MB.
Is it possible that the huge datafile sizes are creating the problems?
DO I create multiple manageable datafiles for each tablespace?
What should be the size of each datafile?
How do I port the data from these humungous datafiles to the other manageable datafiles and drop them?
Any help would be greatly appreciated.
Thanks.
Pakshi
|
|
|
|
|
|
| Re: Huge datafiles. [message #54445 is a reply to message #54440] |
Mon, 18 November 2002 22:35  |
gp
Messages: 46
Registered: September 2002
|
Member |
|
|
|
handling such a huge data file might be combersom but your connection problem is definately not cos of them as Mahesh said pleas poet the actual error message that u r getting ... i guess there should be proble with your connection string etc
|
|
|
|
| Re: Huge datafiles. [message #54481 is a reply to message #54440] |
Tue, 19 November 2002 13:04 |
Pakshi
Messages: 6
Registered: November 2002
|
Junior Member |
|
|
Thanks for your help. Sorry for the delay in getting back with the log file.. I have taken the top few lines from the log file.
Please take a look at it and suggest.
Thanks.
Pakshi
####<Nov 11, 2002 12:52:56 PM PST> <Error> <HTTP> <wh-app01> <weiServer1> <ExecuteThread: '26' for queue: 'default'> <> <> <101020> <[[WebAppServletContext(6745747,wlcs)]] Servlet failed with Exception>
java.sql.SQLException: Pool connect failed: weblogic.common.ResourceException: None available
at weblogic.jdbcbase.pool.Driver.connect(Driver.java:218)
at weblogic.jdbcbase.jts.Driver.getNonTxConnection(Driver.java:303)
at weblogic.jdbcbase.jts.Driver.connect(Driver.java:116)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:44)
at com.beasys.commerce.foundation.pipeline.CommercePipelineComponent.getConnection(CommercePipelineComponent.java:58)
at com.fronteracorp.commerce.cms.pipeline.RetrieveProductExtValuePC.process(RetrieveProductExtValuePC.java:75)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImpl.process(PipelineExecutorImpl.java:192)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplImpl.process(PipelineExecutorImplImpl.java:110)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplEOImpl.process(PipelineExecutorImplEOImpl.java:31)
at com.beasys.commerce.webflow.PipelineProcessor.callPipeline(PipelineProcessor.java:176)
at com.beasys.commerce.webflow.PipelineProcessor.process(PipelineProcessor.java:99)
at com.beasys.commerce.webflow.WebflowAdvisor.handleTarget(WebflowAdvisor.java:410)
at com.beasys.commerce.webflow.WebflowAdvisor.processTarget(WebflowAdvisor.java:156)
at com.beasys.commerce.webflow.DestinationDeterminer.determineDestination(DestinationDeterminer.java:76)
at com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:554)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
--------------- nested within: ------------------
com.beasys.commerce.foundation.exception.SystemException : An error occurred getting connection using data source URL /jdbc/commercePool/.
at com.beasys.commerce.foundation.pipeline.CommercePipelineComponent.getConnection(CommercePipelineComponent.java:70)
at com.fronteracorp.commerce.cms.pipeline.RetrieveProductExtValuePC.process(RetrieveProductExtValuePC.java:75)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImpl.process(PipelineExecutorImpl.java:192)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplImpl.process(PipelineExecutorImplImpl.java:110)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplEOImpl.process(PipelineExecutorImplEOImpl.java:31)
at com.beasys.commerce.webflow.PipelineProcessor.callPipeline(PipelineProcessor.java:176)
at com.beasys.commerce.webflow.PipelineProcessor.process(PipelineProcessor.java:99)
at com.beasys.commerce.webflow.WebflowAdvisor.handleTarget(WebflowAdvisor.java:410)
at com.beasys.commerce.webflow.WebflowAdvisor.processTarget(WebflowAdvisor.java:156)
at com.beasys.commerce.webflow.DestinationDeterminer.determineDestination(DestinationDeterminer.java:76)
at com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:554)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
####<Nov 11, 2002 12:53:02 PM PST> <Error> <WLCS_PIPELINE_FRAMEWORK> <wh-app01> <weiServer1> <ExecuteThread: '17' for queue: 'default'> <> <> <000000> <LOG_FATAL: PipelineFatalException thrown by WeiSearchPC>
com.beasys.commerce.foundation.exception.PipelineFatalException : No message available. Resource bundle not found: WEI catalog
at com.fronteracorp.commerce.ebusiness.search.pipeline.SearchPC.process(SearchPC.java:122)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImpl.process(PipelineExecutorImpl.java:192)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplImpl.process(PipelineExecutorImplImpl.java:110)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplEOImpl.process(PipelineExecutorImplEOImpl.java:31)
at com.beasys.commerce.webflow.PipelineProcessor.callPipeline(PipelineProcessor.java:176)
at com.beasys.commerce.webflow.PipelineProcessor.process(PipelineProcessor.java:99)
at com.beasys.commerce.webflow.WebflowAdvisor.handleTarget(WebflowAdvisor.java:410)
at com.beasys.commerce.webflow.WebflowAdvisor.processTarget(WebflowAdvisor.java:156)
at com.beasys.commerce.webflow.DestinationDeterminer.determineDestination(DestinationDeterminer.java:76)
at com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:554)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
####<Nov 11, 2002 12:53:02 PM PST> <Error> <WLCS_PIPELINE_FRAMEWORK> <wh-app01> <weiServer1> <ExecuteThread: '13' for queue: 'default'> <> <> <000000> <LOG_FATAL: PipelineFatalException thrown by WeiSearchPC>
com.beasys.commerce.foundation.exception.PipelineFatalException : No message available. Resource bundle not found: WEI catalog
at com.fronteracorp.commerce.ebusiness.search.pipeline.SearchPC.process(SearchPC.java:122)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImpl.process(PipelineExecutorImpl.java:192)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplImpl.process(PipelineExecutorImplImpl.java:110)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplEOImpl.process(PipelineExecutorImplEOImpl.java:31)
at com.beasys.commerce.webflow.PipelineProcessor.callPipeline(PipelineProcessor.java:176)
at com.beasys.commerce.webflow.PipelineProcessor.process(PipelineProcessor.java:99)
at com.beasys.commerce.webflow.WebflowAdvisor.handleTarget(WebflowAdvisor.java:410)
at com.beasys.commerce.webflow.WebflowAdvisor.processTarget(WebflowAdvisor.java:156)
at com.beasys.commerce.webflow.DestinationDeterminer.determineDestination(DestinationDeterminer.java:76)
at com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:554)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
####<Nov 11, 2002 12:53:04 PM PST> <Info> <EJB> <wh-app01> <weiServer1> <ExecuteThread: '21' for queue: 'default'> <> <> <010051> <EJB Exception during invocation from home: com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImplHomeImpl@2a3e06 threw exception: com.beasys.commerce.ebusiness.catalog.CatalogDeploymentException : The environment property /jdbc/commercePool is not properly configured for the component com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImplImpl>
com.beasys.commerce.ebusiness.catalog.CatalogDeploymentException : The environment property /jdbc/commercePool is not properly configured for the component com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImplImpl
at com.beasys.commerce.ebusiness.catalog.service.JdbcCatalogServiceImpl.getDatabaseConnection(JdbcCatalogServiceImpl.java:201)
at com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImpl.getItems(JdbcProductItemManagerImpl.java:203)
at com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImplImpl.getItems(JdbcProductItemManagerImplImpl.java:230)
at com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImplEOImpl.getItems(JdbcProductItemManagerImplEOImpl.java:257)
at com.beasys.commerce.ebusiness.catalog.service.item.ProductItemManagerImpl.getItems(ProductItemManagerImpl.java:247)
at com.beasys.commerce.ebusiness.catalog.service.item.ProductItemManagerImplImpl.getItems(ProductItemManagerImplImpl.java:230)
at com.beasys.commerce.ebusiness.catalog.service.item.ProductItemManagerImplEOImpl.getItems(ProductItemManagerImplEOImpl.java:257)
at com.fronteracorp.plugin.bea.commerce.pipeline.AbstractRetrievePC.retrieveItems(AbstractRetrievePC.java:140)
at com.fronteracorp.plugin.bea.commerce.pipeline.AbstractRetrievePC.process(AbstractRetrievePC.java:103)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImpl.process(PipelineExecutorImpl.java:192)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplImpl.process(PipelineExecutorImplImpl.java:110)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplEOImpl.process(PipelineExecutorImplEOImpl.java:31)
at com.beasys.commerce.webflow.PipelineProcessor.callPipeline(PipelineProcessor.java:176)
at com.beasys.commerce.webflow.PipelineProcessor.process(PipelineProcessor.java:99)
at com.beasys.commerce.webflow.WebflowAdvisor.handleTarget(WebflowAdvisor.java:410)
at com.beasys.commerce.webflow.WebflowAdvisor.processTarget(WebflowAdvisor.java:156)
at com.beasys.commerce.webflow.DestinationDeterminer.determineDestination(DestinationDeterminer.java:76)
at com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:554)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
####<Nov 11, 2002 12:53:04 PM PST> <Info> <EJB> <wh-app01> <weiServer1> <ExecuteThread: '21' for queue: 'default'> <> <> <010051> <EJB Exception during invocation from home: com.beasys.commerce.ebusiness.catalog.service.item.ProductItemManagerImplHomeImpl@73ad9 threw exception: java.rmi.RemoteException: EJB Exception:; nested exception is:
java.rmi.RemoteException: EJB Exception: ; nested exception is:
com.beasys.commerce.ebusiness.catalog.CatalogDeploymentException : The environment property /jdbc/commercePool is not properly configured for the component com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImplImpl>
java.rmi.RemoteException: EJB Exception:; nested exception is:
java.rmi.RemoteException: EJB Exception: ; nested exception is:
com.beasys.commerce.ebusiness.catalog.CatalogDeploymentException : The environment property /jdbc/commercePool is not properly configured for the component com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImplImpl
java.rmi.RemoteException: EJB Exception: ; nested exception is:
com.beasys.commerce.ebusiness.catalog.CatalogDeploymentException : The environment property /jdbc/commercePool is not properly configured for the component com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImplImpl
com.beasys.commerce.ebusiness.catalog.CatalogDeploymentException : The environment property /jdbc/commercePool is not properly configured for the component com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImplImpl
at com.beasys.commerce.ebusiness.catalog.service.JdbcCatalogServiceImpl.getDatabaseConnection(JdbcCatalogServiceImpl.java:201)
at com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImpl.getItems(JdbcProductItemManagerImpl.java:203)
at com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImplImpl.getItems(JdbcProductItemManagerImplImpl.java:230)
at com.beasys.commerce.ebusiness.catalog.service.item.JdbcProductItemManagerImplEOImpl.getItems(JdbcProductItemManagerImplEOImpl.java:257)
at com.beasys.commerce.ebusiness.catalog.service.item.ProductItemManagerImpl.getItems(ProductItemManagerImpl.java:247)
at com.beasys.commerce.ebusiness.catalog.service.item.ProductItemManagerImplImpl.getItems(ProductItemManagerImplImpl.java:230)
at com.beasys.commerce.ebusiness.catalog.service.item.ProductItemManagerImplEOImpl.getItems(ProductItemManagerImplEOImpl.java:257)
at com.fronteracorp.plugin.bea.commerce.pipeline.AbstractRetrievePC.retrieveItems(AbstractRetrievePC.java:140)
at com.fronteracorp.plugin.bea.commerce.pipeline.AbstractRetrievePC.process(AbstractRetrievePC.java:103)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImpl.process(PipelineExecutorImpl.java:192)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplImpl.process(PipelineExecutorImplImpl.java:110)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplEOImpl.process(PipelineExecutorImplEOImpl.java:31)
at com.beasys.commerce.webflow.PipelineProcessor.callPipeline(PipelineProcessor.java:176)
at com.beasys.commerce.webflow.PipelineProcessor.process(PipelineProcessor.java:99)
at com.beasys.commerce.webflow.WebflowAdvisor.handleTarget(WebflowAdvisor.java:410)
at com.beasys.commerce.webflow.WebflowAdvisor.processTarget(WebflowAdvisor.java:156)
at com.beasys.commerce.webflow.DestinationDeterminer.determineDestination(DestinationDeterminer.java:76)
at com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:554)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
####<Nov 11, 2002 12:53:04 PM PST> <Error> <WLCS_PIPELINE_FRAMEWORK> <wh-app01> <weiServer1> <ExecuteThread: '21' for queue: 'default'> <> <> <000000> <LOG_FATAL: PipelineFatalException thrown by RetrieveProductPC>
com.beasys.commerce.foundation.exception.PipelineFatalException : No message available. Resource bundle not found: polaris-commerce
at com.fronteracorp.plugin.bea.commerce.pipeline.AbstractRetrievePC.process(AbstractRetrievePC.java:115)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImpl.process(PipelineExecutorImpl.java:192)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplImpl.process(PipelineExecutorImplImpl.java:110)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplEOImpl.process(PipelineExecutorImplEOImpl.java:31)
at com.beasys.commerce.webflow.PipelineProcessor.callPipeline(PipelineProcessor.java:176)
at com.beasys.commerce.webflow.PipelineProcessor.process(PipelineProcessor.java:99)
at com.beasys.commerce.webflow.WebflowAdvisor.handleTarget(WebflowAdvisor.java:410)
at com.beasys.commerce.webflow.WebflowAdvisor.processTarget(WebflowAdvisor.java:156)
at com.beasys.commerce.webflow.DestinationDeterminer.determineDestination(DestinationDeterminer.java:76)
at com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:554)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
####<Nov 11, 2002 12:53:07 PM PST> <Error> <WLCS_PIPELINE_FRAMEWORK> <wh-app01> <weiServer1> <ExecuteThread: '12' for queue: 'default'> <> <> <000000> <LOG_FATAL: PipelineFatalException thrown by WeiSearchPC>
com.beasys.commerce.foundation.exception.PipelineFatalException : No message available. Resource bundle not found: WEI catalog
at com.fronteracorp.commerce.ebusiness.search.pipeline.SearchPC.process(SearchPC.java:122)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImpl.process(PipelineExecutorImpl.java:192)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplImpl.process(PipelineExecutorImplImpl.java:110)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplEOImpl.process(PipelineExecutorImplEOImpl.java:31)
at com.beasys.commerce.webflow.PipelineProcessor.callPipeline(PipelineProcessor.java:176)
at com.beasys.commerce.webflow.PipelineProcessor.process(PipelineProcessor.java:99)
at com.beasys.commerce.webflow.WebflowAdvisor.handleTarget(WebflowAdvisor.java:410)
at com.beasys.commerce.webflow.WebflowAdvisor.processTarget(WebflowAdvisor.java:156)
at com.beasys.commerce.webflow.DestinationDeterminer.determineDestination(DestinationDeterminer.java:76)
at com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:554)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
####<Nov 11, 2002 12:53:07 PM PST> <Error> <HTTP> <wh-app01> <weiServer1> <ExecuteThread: '28' for queue: 'default'> <> <> <101020> <[[WebAppServletContext(6745747,wlcs)]] Servlet failed with Exception>
java.sql.SQLException: Pool connect failed: weblogic.common.ResourceException: None available
at weblogic.jdbcbase.pool.Driver.connect(Driver.java:218)
at weblogic.jdbcbase.jts.Driver.getNonTxConnection(Driver.java:303)
at weblogic.jdbcbase.jts.Driver.connect(Driver.java:116)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:44)
at com.beasys.commerce.foundation.pipeline.CommercePipelineComponent.getConnection(CommercePipelineComponent.java:58)
at com.fronteracorp.commerce.cms.pipeline.RetrieveProductExtValuePC.process(RetrieveProductExtValuePC.java:75)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImpl.process(PipelineExecutorImpl.java:192)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplImpl.process(PipelineExecutorImplImpl.java:110)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplEOImpl.process(PipelineExecutorImplEOImpl.java:31)
at com.beasys.commerce.webflow.PipelineProcessor.callPipeline(PipelineProcessor.java:176)
at com.beasys.commerce.webflow.PipelineProcessor.process(PipelineProcessor.java:99)
at com.beasys.commerce.webflow.WebflowAdvisor.handleTarget(WebflowAdvisor.java:410)
at com.beasys.commerce.webflow.WebflowAdvisor.processTarget(WebflowAdvisor.java:156)
at com.beasys.commerce.webflow.DestinationDeterminer.determineDestination(DestinationDeterminer.java:76)
at com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:554)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
--------------- nested within: ------------------
com.beasys.commerce.foundation.exception.SystemException : An error occurred getting connection using data source URL /jdbc/commercePool/.
at com.beasys.commerce.foundation.pipeline.CommercePipelineComponent.getConnection(CommercePipelineComponent.java:70)
at com.fronteracorp.commerce.cms.pipeline.RetrieveProductExtValuePC.process(RetrieveProductExtValuePC.java:75)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImpl.process(PipelineExecutorImpl.java:192)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplImpl.process(PipelineExecutorImplImpl.java:110)
at com.beasys.commerce.foundation.pipeline.PipelineExecutorImplEOImpl.process(PipelineExecutorImplEOImpl.java:31)
at com.beasys.commerce.webflow.PipelineProcessor.callPipeline(PipelineProcessor.java:176)
at com.beasys.commerce.webflow.PipelineProcessor.process(PipelineProcessor.java:99)
at com.beasys.commerce.webflow.WebflowAdvisor.handleTarget(WebflowAdvisor.java:410)
at com.beasys.commerce.webflow.WebflowAdvisor.processTarget(WebflowAdvisor.java:156)
at com.beasys.commerce.webflow.DestinationDeterminer.determineDestination(DestinationDeterminer.java:76)
at com.beasys.commerce.foundation.flow.FlowManager.service(FlowManager.java:554)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:213)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:1265)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
|
|
|
|
|
|
| Re: Huge datafiles. [message #54498 is a reply to message #54481] |
Tue, 19 November 2002 23:55 |
gp
Messages: 46
Registered: September 2002
|
Member |
|
|
read this
The environment property /jdbc/commercePool is not properly configured for the component com.beasys
i guess either your datasource is not configured properly or u r using a wrong driver !!!!
check it out
|
|
|
|
| Re: Huge datafiles. [message #54528 is a reply to message #54440] |
Wed, 20 November 2002 13:25 |
Pakshi
Messages: 6
Registered: November 2002
|
Junior Member |
|
|
Mahesh and GP thanks for your comments.
I think I have not explained the situation correctly. It is not that I am not able to connect at all. What is happening is every now and then I keep getting an error page and when I look at the log file I get those messages..
GP: Were u trying to send a URL for me to go thru? Can you post the URL again please.
Do you want me to post the values in the settings file or something. Suggest.
I would like to have a suggestion on how to reduce the size of the datafile without losing any data. I would like to shrink the datafile size and have multiple small datafiles of manageable size. Would it not be agood practice to have db files of size say 3 GB or so instead of humuongous files like in this case.
Thanks for your help.
Pakshi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
