ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » IBM MQ Performance Monitoring » suggest me

Post new topic  Reply to topic
 suggest me « View previous topic :: View next topic » 
Author Message
jpeela
PostPosted: Tue Jul 18, 2006 2:54 am    Post subject: suggest me Reply with quote

Centurion

Joined: 23 Jan 2006
Posts: 139
hi evry1,

iam using rhel4 ,mq 6.0. can i use qflex for this .Itried installing and running it but got the following error.

Unable to connect to database, please check JNDI settings.
org.netflexity.dorm.command.CommandException: Base table or view not found message from server: "Table 'qflex.COMPANIES' doesn't exist" SQL Failed: SELECT COMPANY_ID,COMPANY_NM,SERIAL_NO,ADDR,CITY,STATE,ZIP,EMAIL,PHONE,MODIFIED_BY,MODIFIED_DT FROM COMPANIES SQL Failed: SELECT COMPANY_ID,COMPANY_NM,SERIAL_NO,ADDR,CITY,STATE,ZIP,EMAIL,PHONE,MODIFIED_BY,MODIFIED_DT FROM COMPANIES at org.netflexity.dorm.command.common.SelectByCriteriaCommand.execute(SelectByCriteriaCommand.java:62) at org.netflexity.dorm.command.CommandExecutor.process(CommandExecutor.java:125) at org.netflexity.dorm.command.CommandExecutor.execute(CommandExecutor.java:62) at org.netflexity.dorm.command.LocalCommandExecutor.execute(LocalCommandExecutor.java:42) at org.netflexity.dorm.command.CommandExecutorLocator.execute(CommandExecutorLocator.java:8icon_cool.gif at org.netflexity.dorm.command.Command.run(Command.java:23) at com.netflexity.qflex.actions.DefaultAction.execute(DefaultAction.java:59) at com.netflexity.qflex.actions.QflexAction.execute(QflexAction.java:111) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.netflexity.qflex.servlet.filters.QflexAuthenticationFilter.doFilter(QflexAuthenticationFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source)

can any one suggest me the solution.

one more thing ,can i use WAS and DB2 instead of tomcat and mysql.

thanx in advance
_________________
Jogi
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
bower5932
PostPosted: Tue Jul 18, 2006 6:47 am    Post subject: Re: suggest me Reply with quote

Jedi Knight

Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA
jpeela wrote:
Unable to connect to database, please check JNDI settings.
org.netflexity.dorm.command.CommandException: Base table or view not found message from server: "Table 'qflex.COMPANIES' doesn't exist"


Does your table exist? Did you connect to the right database?
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
jpeela
PostPosted: Wed Jul 19, 2006 4:00 am    Post subject: Reply with quote

Centurion

Joined: 23 Jan 2006
Posts: 139
hi bower ,

ya i created a database by name qflex,i have seen the tables but there is no such table as qflex.companies.I even set the password to netflexity,the default.
i did not give the serial no bcoz it did not ask me the login id and passwd.could that b a problem.

thanx in advance.
_________________
Jogi
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
bower5932
PostPosted: Wed Jul 19, 2006 5:53 am    Post subject: Reply with quote

Jedi Knight

Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA
jpeela wrote:
i have seen the tables but there is no such table as qflex.companies.


The error message is complaining about a missing table, and you say that you don't have it. I'd say that is your problem. You need to either get the table created or figure out what the table name should be and put it in some kind of profile.
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
jpeela
PostPosted: Wed Jul 19, 2006 7:13 am    Post subject: Reply with quote

Centurion

Joined: 23 Jan 2006
Posts: 139
hi bower ,

I have tables other than that but i did not know what columns or rows i need to create,all i can do is to create a table by that name.But what about the columns by name company name, mail address ,address and so on.Is there any sql script to do that,i have downloaded all the sql scripts available in the netflexity but did not know what else i do need.
I tried running few sql scripts like mysql clean.sql but they ended up with errors saying duplicate key.And im not even familiar with the databases especially,mysql.
can u suggest me any sql script.

thanx in advance.
_________________
Jogi
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
bower5932
PostPosted: Wed Jul 19, 2006 8:21 am    Post subject: Reply with quote

Jedi Knight

Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA
I have no idea what you are trying to do or where you got what you are using. I just looked at the error message and tried to figure out what it was indicating. How does this relate to WMQ? If there was more background information, I (or somebody else) might be able to supply an answer.
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
jpeela
PostPosted: Wed Jul 19, 2006 12:06 pm    Post subject: Reply with quote

Centurion

Joined: 23 Jan 2006
Posts: 139
hi bower,

actually i followed all the steps given in the netflexity to install the qflex.but it was given only for windows,but i installed on rhel 4.It did worked fine until step 9.where i need to connect using the url "http://yourhost:PORT/QFLEX/Default.do" where i have given my sys ip address as your host and 8080 as port no.Asper the instructions it should ask for login id and password but it did not ask,the page opened with structure showing qmanagers,ques but with error given in the first post at the center of the page.have no idea on mysql much.

i have looked for the tables.there is no table by name qflex.COMPANIES. but there is a tableby name companies.but when i queried
mysql> select * from collection_policies; ( it is giving empty set)
Empty set (0.00 sec).
could this be configuration problem,url problem,or problem with sql script that i have run.

thanx in advance.
_________________
Jogi
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
bower5932
PostPosted: Wed Jul 19, 2006 12:34 pm    Post subject: Reply with quote

Jedi Knight

Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA
jpeela wrote:
i have looked for the tables.there is no table by name qflex.COMPANIES. but there is a tableby name companies.but when i queried
mysql> select * from collection_policies; ( it is giving empty set)


To me, this implies that there is a problem with schema names on the tables. However, I have no idea where to tell you to start looking.
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
fjb_saper
PostPosted: Wed Jul 19, 2006 2:09 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
Remember that UNIX and Linux are much more case sensitive than Windows. You might want to get in touch with netflexity and ask for a script to run in Linux to initialize the DB.

Enjoy
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
jpeela
PostPosted: Thu Jul 20, 2006 1:05 am    Post subject: Reply with quote

Centurion

Joined: 23 Jan 2006
Posts: 139
thanq saper and bower,

I had already sent a mail and awaiting a reply since three days.so iam trying alternative solution from this blog.lets hope that i find an answer to that.

anyways thanx again.
_________________
Jogi
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » IBM MQ Performance Monitoring » suggest me
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.