Users Received Same Emails Repeatedly and Saw Error "ORA-01950: no privileges on tablespace 'AGILE_DATA2'" in GUI
(Doc ID 2867675.1)
Last updated on JULY 04, 2022
Applies to:
Oracle Agile Product Collaboration - Version 9.3.6.0 and laterInformation in this document applies to any platform.
Symptoms
Agile system experienced the following issues:
1. Some users received more than 200 identical emails.
2. Any users trying to open attachments, approve a process, etc. encountered an error message: “ORA-01950: no privileges on tablespace ‘AGILE_DATA2’ “
Error found in stdout log:
|
<2022-03-11 08:29:21,882> <ExtractService:ERROR> class com.agile.extract.server.TextService.logExtractionEvent(): Failed to log history to history table for object : (Object id: 130596978, Object class=6000) due to exception ORA-01950: no privileges on tablespace 'AGILE_DATA2'
com.agile.util.exception.CMAppException: ORA-01950: no privileges on tablespace 'AGILE_DATA2' at com.agile.pc.cmserver.notification.ChangeHistoryDAO.insertChangeHistory(ChangeHistoryDAO.java:422) ~[agileclasses.jar:?] at com.agile.pc.cmserver.base.BaseServiceChangeHistory.appendHistory(BaseServiceChangeHistory.java:942) ~[agileclasses.jar:?] at com.agile.pc.cmserver.base.BaseServiceChangeHistory.appendHistory(BaseServiceChangeHistory.java:474) ~[agileclasses.jar:?] at com.agile.pc.cmserver.base.BaseServiceChangeHistory.appendHistory(BaseServiceChangeHistory.java:305) ~[agileclasses.jar:?] at com.agile.pc.cmserver.base.BaseServiceChangeHistory.appendHistory(BaseServiceChangeHistory.java:251) ~[agileclasses.jar:?] at com.agile.pc.cmserver.base.BaseServiceRoute.logAction(BaseServiceRoute.java:16552) ~[agileclasses.jar:?] at com.agile.extract.server.ExtractService.logExtractionEvent(ExtractService.java:505) [agileclasses.jar:?] at com.agile.extract.server.ExtractService.extract(ExtractService.java:387) [agileclasses.jar:?] at com.agile.extract.server.TextService.extract(TextService.java:167) [agileclasses.jar:?] at com.agile.extract.server.ExtractSessionBean.extractText(ExtractSessionBean.java:177) [agileclasses.jar:?] at com.agile.extract.server.ExtractSessionBean.extractText(ExtractSessionBean.java:167) [agileclasses.jar:?] at com.agile.extract.server.ExtractSessionBean_p64vlj_EOImpl.__WL_invoke(Unknown Source) [pc.jar:?] at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invokeInternal(SessionRemoteMethodInvoker.java:54) [com.oracle.weblogic.ejb.jar:12.2.1.4] at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:21) [com.oracle.weblogic.ejb.jar:12.2.1.4] at com.agile.extract.server.ExtractSessionBean_p64vlj_EOImpl.extractText(Unknown Source) [pc.jar:?] at com.agile.ui.pcm.lookup.ExportTask$1.run(ExportTask.java:110) [agileclasses.jar:?] at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344) [com.oracle.weblogic.security.subject.jar:12.2.1.4] at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:137) [com.oracle.weblogic.security.subject.jar:12.2.1.4] at weblogic.security.Security.runAs(Security.java:42) [com.oracle.weblogic.security.jar:12.2.1.4] at com.agile.admin.vendor.weblogic.WeblogicServerAdapter.doAs(WeblogicServerAdapter.java:240) [agileclasses.jar:?] at com.agile.ui.pcm.lookup.ExportTask.performTask(ExportTask.java:155) [agileclasses.jar:?] at com.agile.ui.pcm.common.BackgroundTask.run(BackgroundTask.java:38) [agileclasses.jar:?] VFHY1116P-4C82D-TR" Type="0" />, <Notification parentKey="null" fieldId="1053" Value="INITIAL RELEASE" Type="0" />, <Notification parentKey="null" fieldId="1271" Value="Toyota" Type="0" />, <Notification parentKey="null" fieldId="1275" Value="Accessory" Type="0" />, <Notification parentKey="null" fieldId="2000008063" Value="PASMT" Type="0" />, <Notification parentKey="null" fieldId="12872" Value="03/08/2022 04:13:53 PM EST" Type="0" />, <Notification parentKey="null" fieldId="12867" Value="Purch/PPAP Review" Type="0" />, <Notification parentKey="null" fieldId="12871" Value="Carman, Kristy" Type="0" />, <Notification parentKey="null" fieldId="12844" Value="" Type="0" />, <Notification parentKey="null" fieldId="12865" Value="https://agileweb.panasonicautomotive.com/Agile/PLMServlet?action=OpenEmailObject&classid=1450&objid=130728527" Type="0" />] Reason: ORA-01950: no privileges on tablespace 'AGILE_DATA2' java.sql.BatchUpdateException: ORA-01950: no privileges on tablespace 'AGILE_DATA2' at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9775) ~[ojdbc8dms.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1448) ~[ojdbc8dms.jar:19.3.0.0.0] at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9540) ~[ojdbc8dms.jar:19.3.0.0.0] at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:238) ~[ojdbc8dms.jar:19.3.0.0.0] at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:197) ~[com.bea.core.datasource6.jar:12.2.1.4] at com.agile.admin.metadata.BatchedPreparedStatement.executeBatch(BatchedPreparedStatement.java:446) ~[agileclasses.jar:?] at com.agile.admin.metadata.ObjectManager.store(ObjectManager.java:460) ~[agileclasses.jar:?] at com.agile.admin.metadata.ObjectManager.insert(ObjectManager.java:296) ~[agileclasses.jar:?] at com.agile.sourcing.admin.notification.NotiDAO.createNotification(NotiDAO.java:361) ~[agileclasses.jar:?] at com.agile.sourcing.admin.notification.NotiMDBean.onMessage(NotiMDBean.java:64) [agileclasses.jar:?] at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:438) [com.oracle.weblogic.ejb.jar:12.2.1.4] at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:361) [com.oracle.weblogic.ejb.jar:12.2.1.4] at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:297) [com.oracle.weblogic.ejb.jar:12.2.1.4] at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:5107) [com.oracle.weblogic.jms.jar:12.2.1.4] at weblogic.jms.client.JMSSession.execute(JMSSession.java:4778) [com.oracle.weblogic.jms.jar:12.2.1.4] at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:4173) [com.oracle.weblogic.jms.jar:12.2.1.4] at weblogic.jms.client.JMSSession.access$000(JMSSession.java:127) [com.oracle.weblogic.jms.jar:12.2.1.4] at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5632) [com.oracle.weblogic.jms.jar:12.2.1.4] at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:681) [com.bea.core.weblogic.workmanager.jar:12.2.1.4] at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352) [com.bea.core.utils.full.jar:12.2.1.4] at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337) [com.bea.core.utils.full.jar:12.2.1.4] at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57) [com.oracle.weblogic.work.jar:12.2.1.4] at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) [com.bea.core.weblogic.workmanager.jar:12.2.1.4] at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655) [com.bea.core.weblogic.workmanager.jar:12.2.1.4] at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420) [com.bea.core.weblogic.workmanager.jar:12.2.1.4] at weblogic.work.ExecuteThread.run(ExecuteThread.java:360) [com.bea.core.weblogic.workmanager.jar:12.2.1.4] |
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |