Problem with OEM 10gR2

From: <francois.archambault5_at_gmail.com>
Date: Wed, 08 Aug 2007 07:07:46 -0700
Message-ID: <1186582066.733516.207910@e16g2000pri.googlegroups.com>

Hi all,

I hope someone whos reads this can help me.

In Oracle Enterprise Manager 10g web interface, I am not able to view User detail to add role and privileage to it. An error message pops : "An error occured when processing this request. Please check the log file emoms.log for a complete stack trace.Failed to initialize object:ORA-00979: not a GROUP BY expression"

I would be able to correct this if it was in one of our query but it seems the problem is into OEM.

I am able to view other object detail like Table of SP put users wont open.

Here is the error collected in the emoms.log :

2007-08-08 09:02:23,019 [EMUI_09_02_20_/console/database/security/ user] ERROR adm.misc logException.3446 - oracle.sysman.emSDK.admObj.AdminObjectException: ORA-00979: not a GROUP BY expression

at
oracle.sysman.emo.adm.security.DBGranteeInitializer.initializeConsumerGroupPrivs(DBGranteeInitializer.java: 456)

at
oracle.sysman.emo.adm.security.DBGranteeInitializer.initialize(DBGranteeInitializer.java: 120)

at
oracle.sysman.emo.adm.security.user.DBUserInitializer.initialize(DBUserInitializer.java: 86)

	at oracle.sysman.emo.adm.DBObject.initialize(DBObject.java:152)
	at oracle.sysman.emo.adm.security.user.User.initialize(User.java:195)
	at oracle.sysman.emo.adm.security.user.User.initializeAll(User.java:
178)
	at

oracle.sysman.db.adm.DBController.getBeanForInstantiation(DBController.java: 686)

at
oracle.sysman.db.adm.DBController.instantiateBeanForCreateLike(DBController.java: 883)

at
oracle.sysman.db.adm.DBController.instantiateBean(DBController.java: 605)

at oracle.sysman.db.adm.DBController.getNewBean(DBController.java: 1008)

	at oracle.sysman.db.adm.DBController._getBean(DBController.java:542)
	at oracle.sysman.db.adm.DBController.getBean(DBController.java:523)
	at

oracle.sysman.db.adm.sec.UserController.getUserBean(UserController.java: 1269)

at
oracle.sysman.db.adm.sec.UserController.getBean(UserController.java: 1059)

at
oracle.sysman.db.adm.DBController.validateFileNameState(DBController.java: 3275)

at oracle.sysman.db.adm.DBController.handleEvent(DBController.java: 3080)

at
oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java: 376)

at
oracle.sysman.db.adm.RootController.handleRequest(RootController.java: 170)

at
oracle.sysman.db.adm.DBControllerResolver.handleRequest(DBControllerResolver.java: 114)

	at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:688)
	at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:291)
	at oracle.sysman.eml.app.Console.doGet(Console.java:285)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at

com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java: 65)

at
oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java: 101)

at
com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java: 16)

at
oracle.sysman.db.adm.inst.HandleRepDownFilter.doFilter(HandleRepDownFilter.java: 151)

at
com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java: 20)

at
oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java: 282)

at
com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java: 600)

at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java: 317)

at
com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java: 793)

at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java: 270)

at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java: 112)

at com.evermind.util.ReleasableResourcePooledExecutor $MyWorker.run(ReleasableResourcePooledExecutor.java:192)

at java.lang.Thread.run(Thread.java:534)

Thanks in advance. Received on Wed Aug 08 2007 - 09:07:46 CDT