Solved

Oracle, Database and collaboration suite, 10g

Posted on 2008-06-16
13
1,210 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
Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

 

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 500 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

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three things…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

688 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