[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Oracle, Database and collaboration suite, 10g

Posted on 2008-06-16
13
Medium Priority
?
1,219 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

649 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