Solved

Oracle, Database and collaboration suite, 10g

Posted on 2008-06-16
13
1,192 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
  • 9
  • 4
13 Comments
 
LVL 23

Expert Comment

by:David
Comment Utility
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
Comment Utility
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
Comment Utility
No for the restart, the changes are dynamic.  Let me know the job outcome.
0
 

Author Comment

by:serkanakyol
Comment Utility
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
Comment Utility
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
Comment Utility
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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:serkanakyol
Comment Utility
How can do it?

Serkan
0
 

Author Comment

by:serkanakyol
Comment Utility
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
Comment Utility
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
Comment Utility
I uploaded IF_LYKE screenshot
untitled.JPG
0
 
LVL 23

Accepted Solution

by:
David earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
Thank you

I resolve that problem to use that sql command below.

ALTER INDEX CONTENT.IFS_LYKE ENABLE;

Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Oracle RMAN Database Restore 5 28
statspack purge automate 7 27
PL/SQL LOOP CURSOR 3 40
history tablespace temp usage 2 15
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now