 |
Software > WebSphere > WebSphere Portal Family >
|
 |
 |
 |
'Unable to initialize Repository: Default' Error caused by ORA-25153: Temporary Tablespace is Empty
|
| | | Problem(Abstract) | | During the attempt to run the IBM® WebSphere® Portal WPSconfig script enable-security-ldap after the completion of a database transfer from CloudScape™ to Oracle®, you see generic errors in ConfigTrace.log and SystemOut.log indicating the task has failed. In addition, SRVE0026E errors appear at startup of Portal after the Database Transfer. | | | | Symptom | | from SystemOut.log:
........
[date/time] 00000015 ApplicationMg A WSVR0200I: Starting application: icmjcrear
[date/time] 00000015 WebGroup A SRVE0169I: Loading Web Module: icmjcradminwar.
..........
[date/time] 00000015 Datastore$Dat I com.ibm.icm.ci.Datastore$DataSource getInstance Initialized DataStore Environment for repository: Default.
[date/time] 00000015 RepositoryImp I com.ibm.icm.jcr.RepositoryImpl getRepository Loading NodeType cache for repository: Default.
[date/time] 00000015 ServletWrappe E Uncaught init() exception thrown by servlet InitServlet
[date/time] 00000015 WebExtensionP E Error occurred while preparing the servlet for initialization. Check the error logs for details.
[date/time] 00000015 WebExtensionP E SRVE0026E: [Servlet Error]-[javax.servlet.ServletException: Unable to initialize RepositoryFactory due to exception of type: javax.jcr.RepositoryException with message: Unable to initialize Repository: Default.. at com.ibm.icm.jcr.init.InitServlet.init(InitServlet.java:57)
........
---- Begin backtrace for Nested Throwables
javax.jcr.RepositoryException: Unable to initialize RepositoryFactory due to exception of type: javax.jcr.RepositoryException with message: Unable to initialize Repository: Default..
at com.ibm.icm.jcr.RepositoryFactory.init(RepositoryFactory.java:316)
........
Caused by: javax.jcr.RepositoryException: Unable to initialize Repository: Default.
at com.ibm.icm.jcr.RepositoryImpl.getRepository(RepositoryImpl.java:352)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.icm.jcr.RepositoryFactory.init(RepositoryFactory.java:181)
... 23 more
From ConfigTrace.log:
[xmlaccess] EJPXB0020I: The request was processed successfully on the server.
Sat Dec 01 08:34:23 CST 2007
Target started: action-init-accesscontrol
action-init-accesscontrol:
[echo] Calling ContentModelInitializer
Target finished: action-init-accesscontrol
Target finished: action-configure-content-security
Target finished: enable-security-ldap
---- Begin dump of properties ----
........
---- End dump of properties ----
BUILD FAILEDfile:../config/actions/jcr_cfg.xml:1888: Java returned: 1
Total time: 23 minutes 51 seconds
From trace.log with com.ibm.icm.*=all tracing enabled:
.............
[date/time] 00000044 PPreparedStat 3 com.ibm.icm.da.portable.common.sql.PPreparedStatement executeQuery() ==> [SELECT COMP.ITEMTYPEID, COMPATTR.*, VIEWATTR.ATTRIBUTEFLAGS, COMP.COMPONENTTYPEID FROM icmadmin.ICMSTCOMPATTRS COMPATTR, icmadmin.ICMSTCOMPVIEWATTRS VIEWATTR, icmadmin.ICMSTCOMPDEFS COMP WHERE COMPATTR.COMPONENTTYPEID = COMP.COMPONENTTYPEID AND COMPATTR.COMPONENTTYPEID = VIEWATTR.COMPONENTVIEWID AND COMPATTR.ATTRIBUTEGROUP = VIEWATTR.ATTRIBUTEGROUP AND COMPATTR.ATTRIBUTEID = VIEWATTR.ATTRIBUTEID AND COMP.ITEMTYPEID >=1000 ORDER BY COMP.ITEMTYPEID ASC, COMP.COMPONENTTYPEID ASC, COMPATTR.SEQUENCENUM ASC]
[date/time] 00000044 SchemaService W Error retrieving information from the server.
[ErrorCode:7015] During an SQL operation in the library server, an unexpected error. :ORA-25153: Temporary Tablespace is Empty
java.sql.SQLException: ORA-25153: Temporary Tablespace is Empty
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java(Compiled Code))
| | | |  | | | Cause | | The cause for the ORA-25153 error is because attempt was made to use space in a temporary tablespace with no files (no datafiles defined). | | | | | Resolving the problem | | Consult with your Oracle Database Administrator (DBA) to determine if there is an issue with the Temporary Tablespace that conflicts with the requirements outlined in the Information Center.
Ensure that users for Oracle are set up correctly according to the Information Center:
http://publib.boulder.ibm.com/infocenter/wpdoc/v6r0/index.jsp?topic=/com.ibm.wp.ent.doc/wpf/setup_oracle.html
including the temporary tablespace. Your Oracle DBA will be able to verify that datafiles exist in the Temporary Tablespace.
If user creation steps cannot be verified, you must drop and recreate the users, and complete the database-transfer task again.
| | | | | | | | | |
 |
| IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml. |
 |
 |
 |
| Please take a moment to complete this form to help us better serve you. |
 |
 |
 |
|
|
|
 |
 |
| Product categories: |
 |
| | Software |  |
| | Organizational Productivity, Portals & Collaboration |  |
| | Portals |  |
| | WebSphere Portal |  |
| | Installation & Configuration |  |
 |
| Operating system(s): |
| |
AIX, HP-UX, Linux, Solaris, Windows
|
 |
| Software version: |
| |
6.0
|
 |
| Software edition: |
| |
Enable, Express, Extend
|
 |
| Reference #: |
| |
1290669
|
 |
| IBM Group: |
| | Software Group |
 |
| Modified date: |
| | 2009-11-04 |
 |
|