Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Wed, 08 Aug 2007 11:40:20 -0700 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Problem with OEM 10gR2 References: <1186582066.733516.207910@e16g2000pri.googlegroups.com> In-Reply-To: <1186582066.733516.207910@e16g2000pri.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1186598418.302507@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@216.162.218.178 X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 125 X-Complaints-To: abuse@csolutions.net Xref: usenetserver.com comp.databases.oracle.server:432664 X-Received-Date: Wed, 08 Aug 2007 14:40:19 EDT (text.usenetserver.com) francois.archambault5@gmail.com wrote: > 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. Wish I could be more helpful but ... http://metalink.oracle.com. Check the docs and if no help open an SR. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org