Oracle, Database and collaboration suite, 10g

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?

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

No for the restart, the changes are dynamic.  Let me know the job outcome.

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
 

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)
 

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.

How can do it?

Serkan

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

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

I uploaded IF_LYKE screenshot
untitled.JPG

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

Thank you

I resolve that problem to use that sql command below.

ALTER INDEX CONTENT.IFS_LYKE ENABLE;

Thanks