?
Solved

Oracle, Database and collaboration suite, 10g

Posted on 2008-06-16
13
Medium Priority
?
1,214 Views
Last Modified: 2013-12-19
I use Oracle Colalboration Suite and When I upload any file or to create any folder on Content Service, an error occurs on Content Service

2008/06/16 10:29:58 [oracle.ifs.ecm.agents.MostRecentDocAgent] [34] 469069 system WARNING:
Exception adding Most Recent Document for 458367

oracle.ifs.common.IfsException: IFS-30002: Unable to create new LibraryObject

java.sql.SQLException: ORA-30554: function-based index CONTENT.IFS_LYKE is disabled

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)

at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:698)

at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:630)

at
oracle.jdbc.driver.T2CPreparedStatement.execute_for_describe(T2CPreparedStatemen
t.java:850)

at oracle.jdbc.driver.T2CPreparedStatement.execute_for_rows(T2CPreparedStatement.ja
va:1012)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:115
3)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStateme
nt.java:2932)

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:
3023)

at oracle.ifs.server.S_LibrarySession.execute(S_LibrarySession.java:18589)

at oracle.ifs.server.S_LibraryObject.insertRow(S_LibraryObject.java:3802)

at oracle.ifs.server.S_LibraryObject.insertRows(S_LibraryObject.java:3705)

at
oracle.ifs.server.OperationState.executeAtomicOperations(OperationState.java:492
)

at oracle.ifs.server.S_LibraryObject.createInstance(S_LibraryObject.java:3193)

at
oracle.ifs.server.S_LibrarySession.newLibraryObject(S_LibrarySession.java:9990)


at oracle.ifs.server.S_LibrarySession.newPublicObject(S_LibrarySession.java:10031)


at oracle.ifs.server.S_LibrarySession.newPublicObject(S_LibrarySession.java:10013)


at oracle.ifs.server.S_LibrarySession.DMNewPublicObject(S_LibrarySession.java:9811)


at oracle.ifs.beans.LibrarySession.DMNewPublicObject(LibrarySession.java:10381)

at oracle.ifs.beans.PublicObject.handleCreate(PublicObject.java:2471)

at
oracle.ifs.beans.LibrarySession.createPublicObject(LibrarySession.java:4447)

at oracle.ifs.ecm.beans.MostRecentDoc.addMostRecentDoc(MostRecentDoc.java:515)

at
oracle.ifs.ecm.agents.MostRecentDocAgent.processRetainedEvent(MostRecentDocAgent
.java:213)

at oracle.ifs.ecm.agents.RetainedEventAgent.processRetainedEvents(RetainedEventAgen
t.java:498)

at oracle.ifs.ecm.agents.RetainedEventAgent.run(RetainedEventAgent.java:222)

at
oracle.ifs.management.domain.IfsServer$ServerRunner.run(IfsServer.java:2579)

And I look up at CONTENT.IFS_LYKE on database.

CONTENT.IF.LYKE has not tablespace and an error occured like that


Failed to initialize Related Segments Space Info: ORA-00600: internal error code, arguments:
[ktsircinfo_num1], [0], [0], [0], [], [], [], [] ORA-06512: at
"SYS.DBMS_SPACE", line 429 ORA-06512: at line 1

I try that ALTER INDEX REBULD CONTENT.IFS_LYKE. But an error occured again like that

Invalid option ALTER INDEX ....

I need help urgently
0
Comment
Question by:serkanakyol
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 4
13 Comments
 
LVL 23

Expert Comment

by:David
ID: 21793249
If your DDL for IFS_LYKE does not specify a tablespace, it will default into your schema's default tablespace.  Would you please check to confirm you have sufficient quota remaining on that tablespace, and that the tablespace has sufficient free space?
0
 

Author Comment

by:serkanakyol
ID: 21793390
CONTENT_IFS_MAIN is the default tablespace. So I check its free space. So Rate of file size % 99.7.

I increase usefull size 198mb to 500mb. Then Must I restart database?

Serkan
0
 
LVL 23

Expert Comment

by:David
ID: 21793660
No for the restart, the changes are dynamic.  Let me know the job outcome.
0
Optimum High-Definition Video Viewing and Control

The ATEN VM0404HA 4x4 4K HDMI Matrix Switch supports 4K resolutions of UHD (3840 x 2160) and DCI (4096 x 2160) with refresh rates of 30 Hz (4:4:4) and 60 Hz (4:2:0). It is ideal for applications where the routing of 4K digital signals is required.

 

Author Comment

by:serkanakyol
ID: 21793934
I guess this problem fixed. So that error did not occur. But, this time another error occurs below.

2008/06/16 17:25:12 [oracle.ifs.management.servers.OidCredentialManagerAgent] [22] INFO: Starting synchronizing process...
 
2008/06/16 17:25:13 [oracle.ifs.management.servers.OidCredentialManagerAgent] [22] INFO: Number of OiD events = 0
 
2008/06/16 17:25:22 [oracle.ifs.ecm.agents.RetainedEventAgent] [23] INFO: Processing retained events:
 
2008/06/16 17:25:22 [oracle.ifs.ecm.agents.ReadDocumentAgent] [23] WARNING: Null document or user in processing RetainedEvent VirtualLoggerHierarchy
  (DOCUMENT:3565) null
 
0
 

Author Comment

by:serkanakyol
ID: 21794122
Sorry,

I have same error.

Caused by: oracle.ifs.common.IfsException: IFS-30002: Unable to create new LibraryObject
 
java.sql.SQLException: ORA-30554: function-based index CONTENT.IFS_LYKE is disabled
 
    at oracle.ifs.server.S_LibraryObject.insertRow(S_LibraryObject.java:3842)
 
    at oracle.ifs.server.S_LibraryObject.insertRows(S_LibraryObject.java:3705)
 
    at oracle.ifs.server.OperationState.executeAtomicOperations(OperationState.java:492)
 
    ... 48 more
 
Caused by: java.sql.SQLException: ORA-30554: function-based index CONTENT.IFS_LYKE is disabled
 
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
 
    at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:698)
 
    at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:630)
 
    at oracle.jdbc.driver.T2CPreparedStatement.execute_for_describe(T2CPreparedStatement.java:850)
 
    at oracle.jdbc.driver.T2CPreparedStatement.execute_for_rows(T2CPreparedStatement.java:1012)
 
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1153)
 
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2932)
 
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3023)
 
    at oracle.ifs.server.S_LibrarySession.execute(S_LibrarySession.java:18589)
 
    at oracle.ifs.server.S_LibraryObject.insertRow(S_LibraryObject.java:3802)
 
0
 
LVL 23

Expert Comment

by:David
ID: 21794464
Found this but it may not be relevant.  In the meantime perhaps if you posted your create index statement?

XML Bugs
Bug 1246851  Subclassing through XML to create a ClassObject with an invalid name causes an obscure error.  
Description
 When creating a subclass, the table name created in the database is set to the name of the ClassObject. If the ClassObject name is an invalid tablename, (tablename cannot be a reserved SQL word, nor can it contain spaces or illegal characters) the following exception is thrown:

IFS-30002: Unable to create new LibraryObject.
 
Action
 Edit the XML file.

Change the name of the ClassObject.
0
 

Author Comment

by:serkanakyol
ID: 21794558
How can do it?

Serkan
0
 

Author Comment

by:serkanakyol
ID: 21794642
Hi,

Thank you for your kind interest. But, our Content service in Oracle Collaboration Suite is not running normally. So We can not uploaded any file. I need help sppedly and urgently.

Can u support me online or whatelse you want?

Serkan
0
 

Author Comment

by:serkanakyol
ID: 21794695
Last error message is,

FdkException Details: oracle.ifs.fdk.FdkException: ErrorCode = ORACLE.FDK.UnexpectedError; DetailedErrorCode = ORACLE.FDK.ServerError;
  Cause = IFS-30002: Unable to create new LibraryObject; ServerStackTraceId = 2-1213630925507; Info = null; Entries = null
 
08/06/16 18:42:05 content:  [oracle.ifs.web.action.EcmAction] [28] 2 sakyol SEVERE: Action Failed  
 
oracle.ifs.fdk.FdkException: ErrorCode = ORACLE.FDK.UnexpectedError; DetailedErrorCode = ORACLE.FDK.ServerError; Cause = IFS-30002: Unable
  to create new LibraryObject; ServerStackTraceId = 2-1213630925507; Info = null; Entries = null
 
Main Exception Stack Trace:
 
ORACLE.FDK.UnexpectedError:ORACLE.FDK.ServerError
 
    at oracle.ifs.fdk.FdkException.getInstance(FdkException.java:189)
 
    at oracle.ifs.fdk.FdkException.getInstance(FdkException.java:81)
 
    at oracle.ifs.fdk.impl.FileManagerImpl.createFolder(FileManagerImpl.java:539)
 
    at oracle.ifs.web.action.CreateFolderAction.doAction(CreateFolderAction.java:59)
 
    at oracle.ifs.web.action.EcmAction.execute(EcmAction.java:74)
 
    at oracle.ifs.web.action.EcmApplicationActions.createFolder(EcmApplicationActions.java:513)
 
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 
    at java.lang.reflect.Method.invoke(Method.java:324)
 
    at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)
 
    at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:72)
 
    at oracle.adf.view.faces.component.UIXCommand.broadcast(UIXCommand.java:211)
 
    at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)
 
    at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)
 
    at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)
 
    at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
 
    at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)
 
    at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
 
    at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
 
    at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
 
    at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
 
    at oracle.ifs.web.webapp.NlsFilter.doFilter(NlsFilter.java:47)
 
    at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
 
    at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfFacesFilterImpl.java:351)
 
    at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:320)
 
    at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:190)
 
    at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:87)
 
    at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
 
    at oracle.ifs.web.webapp.FilesApplicationFilter.doFilter(FilesApplicationFilter.java:77)
 
    at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
 
    at oracle.ifs.web.webapp.SetEncodingFilter.doFilter(SetEncodingFilter.java:43)
 
    at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
 
    at oracle.ifs.fdk.http.HttpServerManager.doFilter(HttpServerManager.java:103)
 
    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:659)
 
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
 
    at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
 
    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:224)
 
    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:133)
 
    at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
 
    at java.lang.Thread.run(Thread.java:534)
 
Caused by: oracle.ifs.common.IfsException: IFS-30002: Unable to create new LibraryObject
 
java.sql.SQLException: ORA-30554: function-based index CONTENT.IFS_LYKE is disabled
 
    at oracle.ifs.server.S_LibrarySession.newLibraryObject(S_LibrarySession.java:9994)
 
    at oracle.ifs.server.S_LibrarySession.newPublicObject(S_LibrarySession.java:10031)
 
    at oracle.ifs.server.S_LibrarySession.newPublicObject(S_LibrarySession.java:10013)
 
    at oracle.ifs.server.S_LibrarySession.DMNewPublicObject(S_LibrarySession.java:9811)
 
    at oracle.ifs.beans.LibrarySession.DMNewPublicObject(LibrarySession.java:10381)
 
    at oracle.ifs.beans.PublicObject.handleCreate(PublicObject.java:2471)
 
    at oracle.ifs.beans.LibrarySession.createPublicObject(LibrarySession.java:4447)
 
    at oracle.ifs.ecm.beans.EcmFolder.createFolder(EcmFolder.java:799)
 
    at oracle.ifs.fdk.impl.FileManagerImpl.createFolder(FileManagerImpl.java:533)
 
    ... 38 more
 
Caused by: oracle.ifs.common.IfsException: IFS-30002: Unable to create new LibraryObject
 
java.sql.SQLException: ORA-30554: function-based index CONTENT.IFS_LYKE is disabled
 
    at oracle.ifs.server.OperationState.executeAtomicOperations(OperationState.java:496)
 
    at oracle.ifs.server.S_LibraryObject.createInstance(S_LibraryObject.java:3193)
 
    at oracle.ifs.server.S_LibrarySession.newLibraryObject(S_LibrarySession.java:9990)
 
    ... 46 more
 
Caused by: oracle.ifs.common.IfsException: IFS-30002: Unable to create new LibraryObject
 
java.sql.SQLException: ORA-30554: function-based index CONTENT.IFS_LYKE is disabled
 
    at oracle.ifs.server.S_LibraryObject.insertRow(S_LibraryObject.java:3842)
 
    at oracle.ifs.server.S_LibraryObject.insertRows(S_LibraryObject.java:3705)
 
    at oracle.ifs.server.OperationState.executeAtomicOperations(OperationState.java:492)
 
    ... 48 more
 
Caused by: java.sql.SQLException: ORA-30554: function-based index CONTENT.IFS_LYKE is disabled
 
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
 
    at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:698)
 
    at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:630)
 
    at oracle.jdbc.driver.T2CPreparedStatement.execute_for_describe(T2CPreparedStatement.java:850)
 
    at oracle.jdbc.driver.T2CPreparedStatement.execute_for_rows(T2CPreparedStatement.java:1012)
 
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1153)
 
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2932)
 
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3023)
 
    at oracle.ifs.server.S_LibrarySession.execute(S_LibrarySession.java:18589)
 
    at oracle.ifs.server.S_LibraryObject.insertRow(S_LibraryObject.java:3802)
 
    ... 50 more
 
FdkException Details: oracle.ifs.fdk.FdkException: ErrorCode = ORACLE.FDK.UnexpectedError; DetailedErrorCode = ORACLE.FDK.ServerError;
  Cause = IFS-30002: Unable to create new LibraryObject; ServerStackTraceId = 2-1213630925507; Info = null; Entries = null
0
 

Author Comment

by:serkanakyol
ID: 21794839
I uploaded IF_LYKE screenshot
untitled.JPG
0
 
LVL 23

Accepted Solution

by:
David earned 1500 total points
ID: 21795057
ORA-30554 function-based index string.string is disabled
Cause
An attempt was made to access a function-based index that has been marked disabled because the function on which the index depends has been changed.

Action
Perform one of the following actions:
- drop the specified index using the DROP INDEX command
- rebuild the specified index using the ALTER INDEX REBUILD command
- enable the specified index using the ALTER INDEX ENABLE command
- make the specified index usable using the ALTER INDEX UNUSABLE command
0
 

Author Comment

by:serkanakyol
ID: 21795615
Hi,

I tried that ALTER INDEX ENABLE CONTENT_IFS_LYKE;

It must be use sql statement with an option, these are INITRANS, MAXTRANS,or STORAGE.

So my real problem, which one of them will I use?

Thanks
0
 

Author Comment

by:serkanakyol
ID: 21796937
Thank you

I resolve that problem to use that sql command below.

ALTER INDEX CONTENT.IFS_LYKE ENABLE;

Thanks
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question