WebSphere Site Analyzer - Install error: SA.POPULATER is an undefined name

This is Interesting: Free IT Magazines  
Home > Archive > WebSphere Site Analyzer > January 2004 > Install error: SA.POPULATER is an undefined name





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Install error: SA.POPULATER is an undefined name
Gord Niguma

2004-01-19, 3:03 pm

Hi all,

When I try to access http://<server>/SiteAnalyzer/index.html, I get the
following error:

SAAM1160E:SiteAnalyzer server problem.

SAAM1201E: Database error encountered: code=-204 SQLState=42S02
text="[IBM][CLI Driver][DB2/NT] SQL0204N "SA.POPULATER" is an undefined
name. SQLSTATE=42704
"

I am performing a manual install of Site Analyzer 4.1 on Windows (my initial
install failed and wouldn't uninstall!).

I believe that the database tables were not properly created. I created the
SAADMIN database and there were no tables. I've tried starting and
restarting Site Analyzer with no luck. I've looked in sastdout.txt and have
not seen any messages of connecting to database, creating tables, etc.

Could anyone help me? Thanks!


Rodrigo Sorriente

2004-01-19, 3:03 pm

Hi Gord!

Which user are you logging in? You need to connect, generally as db2admin
(or the same user you have used in order to execute the installation
process)! Try that and let us know!
We have installed both TSWA 4.1 and 4.2 (FP1) and we have never gotten that
error (But we have gotten several other ones)!. About the SAADMIN, the TWSA
creates the tables on demand, that means which they will be created when you
need them!
Hope this helps!

Best Regards



"Gord Niguma" <niguma@ca.ibm.com> escreveu na mensagem
news:bhgs45$1ci2$1@news.boulder.ibm.com...
quote:

> Hi all,
>
> When I try to access http://<server>/SiteAnalyzer/index.html, I get the
> following error:
>
> SAAM1160E:SiteAnalyzer server problem.
>
> SAAM1201E: Database error encountered: code=-204 SQLState=42S02
> text="[IBM][CLI Driver][DB2/NT] SQL0204N "SA.POPULATER" is an undefined
> name. SQLSTATE=42704
> "
>
> I am performing a manual install of Site Analyzer 4.1 on Windows (my

initial
quote:

> install failed and wouldn't uninstall!).
>
> I believe that the database tables were not properly created. I created

the
quote:

> SAADMIN database and there were no tables. I've tried starting and
> restarting Site Analyzer with no luck. I've looked in sastdout.txt and

have
quote:

> not seen any messages of connecting to database, creating tables, etc.
>
> Could anyone help me? Thanks!
>
>



Gord Niguma

2004-01-19, 3:03 pm

Hi Rodrigo,

When you mean "logging in" do you mean to the Windows machine or the web
application?
I am logging in as the wasadmin on the Windows machine. I tried the manual
install and got to the point where I installed the Enterprise application.
When I go to http://<server>/SiteAnalyze/index..html it prompts me for
username id (I have tried wasadmin and wpsadmin). It authenticated me, but
the first page I see is the error on a web page.


com.ibm.ejs.cm.portability.TableDoesNotExistException: [IBM][CLI
Driver][DB2/NT] SQL0204N "SA.POPULATER" is an undefined name.
SQLSTATE=42704

at java.lang.reflect.Constructor.newInstance(Native Method)
at
com.ibm.ejs.cm.portability.PortabilityLayerImpl.translateException(Portabili
tyLayerImpl.java:263)
at
com.ibm.ejs.cm.portability.ErrorMap.translateException(ErrorMap.java:182)
at com.ibm.ejs.cm.pool.ConnectO.translateException(ConnectO.java:1994)
at com.ibm.ejs.cm.proxy.Proxy.translateException(Proxy.java:355)
at
com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java:3
18)
at
com.ibm.ejs.cm.proxy.StatementProxy.executeQuery(StatementProxy.java:271)
at com.ibm.sa.util.EJBUtils.verifyAccessMgr(EJBUtils.java:512)
at com.ibm.sa.ui.AccessManagerWrapper.<init>(AccessManagerWrapper.java:31)
at _loginIn_jsp_0._jspService(_loginIn_jsp_0.java:305)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:142)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.ja
va:312)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:487)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:620)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager
..java:827)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycl
eServlet.java:167)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServle
t.java:297)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycle
Servlet.java:110)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:47
2)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletMan
ager.java:1012)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManag
er.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(W
ebAppRequestDispatcher.java:678)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequest
Dispatcher.java:331)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestD
ispatcher.java:117)
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
java:239)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedIn
vocation.java:67)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequ
estProcessor.java:151)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener
..java:315)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.ja
va:60)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:323)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:252)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:137)







"Rodrigo Sorriente" <rsorriente@equifax.com.br> wrote in message
news:bhgu6m$4sts$1@news.boulder.ibm.com...
quote:

> Hi Gord!
>
> Which user are you logging in? You need to connect, generally as db2admin
> (or the same user you have used in order to execute the installation
> process)! Try that and let us know!
> We have installed both TSWA 4.1 and 4.2 (FP1) and we have never gotten

that
quote:

> error (But we have gotten several other ones)!. About the SAADMIN, the

TWSA
quote:

> creates the tables on demand, that means which they will be created when

you
quote:

> need them!
> Hope this helps!
>
> Best Regards
>
>
>
> "Gord Niguma" <niguma@ca.ibm.com> escreveu na mensagem
> news:bhgs45$1ci2$1@news.boulder.ibm.com...
> initial
> the
> have
>
>



Rodrigo Sorriente

2004-01-19, 3:03 pm

Hi Gord,

The answer is not. And the point is: You need to use in your JDBC
(DataSource) the same user who you used for create databases (SAPROJEC,
etc). I think the problem is the ALIAS in DB2.


Sorry about my delayed answer and my bad english.


Good luck!




"Gord Niguma" <niguma@ca.ibm.com> escreveu na mensagem
news:bhjm9d$3ici$1@news.boulder.ibm.com...
quote:

> Hi Rodrigo,
>
> When you mean "logging in" do you mean to the Windows machine or the web
> application?
> I am logging in as the wasadmin on the Windows machine. I tried the manual
> install and got to the point where I installed the Enterprise application.
> When I go to http://<server>/SiteAnalyze/index..html it prompts me for
> username id (I have tried wasadmin and wpsadmin). It authenticated me, but
> the first page I see is the error on a web page.
>
>
> com.ibm.ejs.cm.portability.TableDoesNotExistException: [IBM][CLI
> Driver][DB2/NT] SQL0204N "SA.POPULATER" is an undefined name.
> SQLSTATE=42704
>
> at java.lang.reflect.Constructor.newInstance(Native Method)
> at
>

com.ibm.ejs.cm.portability.PortabilityLayerImpl. translateException(Portabili
quote:
[colo
r=darkred]
> tyLayerImpl.java:263)
> at
> com.ibm.ejs.cm.portability.ErrorMap.translateException(ErrorMap.java:182)
> at com.ibm.ejs.cm.pool.ConnectO.translateException(ConnectO.java:1994)
> at com.ibm.ejs.cm.proxy.Proxy.translateException(Proxy.java:355)
> at
>[/color]

com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java:3
quote:

> 18)
> at
> com.ibm.ejs.cm.proxy.StatementProxy.executeQuery(StatementProxy.java:271)
> at com.ibm.sa.util.EJBUtils.verifyAccessMgr(EJBUtils.java:512)
> at

com.ibm.sa.ui.AccessManagerWrapper.<init>(AccessManagerWrapper.java:31)
quote:

> at _loginIn_jsp_0._jspService(_loginIn_jsp_0.java:305)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:142)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>

org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.ja
quote:

> va:312)
> at

org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:487)
quote:

> at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:620)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>

com.ibm.servlet.engine.webapp.StrictServletInstance. doService(ServletManager
quote:

> .java:827)
> at
>

com.ibm.servlet.engine.webapp.StrictLifecycleServlet. _service(StrictLifecycl
quote:

> eServlet.java:167)
> at
>

com.ibm.servlet.engine.webapp.IdleServletState. service(StrictLifecycleServle
quote:
[col
or=darkred]
> t.java:297)
> at
>[/color]

com.ibm.servlet.engine.webapp.StrictLifecycleServlet. service(StrictLifecycle
quote:

> Servlet.java:110)
> at
>

com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:47
quote:

> 2)
> at
>

com.ibm.servlet.engine.webapp.ValidServletReferenceState. dispatch(ServletMan
quote:

> ager.java:1012)
> at
>

com.ibm.servlet.engine.webapp.ServletInstanceReference. dispatch(ServletManag
quote:

> er.java:913)
> at
>

com.ibm.servlet.engine.webapp.WebAppRequestDispatcher. handleWebAppDispatch(W
quote:

> ebAppRequestDispatcher.java:678)
> at
>

com.ibm.servlet.engine.webapp.WebAppRequestDispatcher. dispatch(WebAppRequest
quote:

> Dispatcher.java:331)
> at
>

com.ibm.servlet.engine.webapp.WebAppRequestDispatcher. forward(WebAppRequestD
quote:

> ispatcher.java:117)
> at
> com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
> at
>

com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.
quote:

> java:239)
> at
>

com.ibm.servlet.engine.invocation.CachedInvocation. handleInvocation(CachedIn
quote:

> vocation.java:67)
> at
>

com.ibm.servlet.engine.srp.ServletRequestProcessor. dispatchByURI(ServletRequ
quote:

> estProcessor.java:151)
> at
>

com.ibm.servlet.engine.oselistener.OSEListenerDispatcher. service(OSEListener
quote:

> .java:315)
> at
>

com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.ja
quote:

> va:60)
> at
>

com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:323)
quote:

> at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:252)
> at com.ibm.ws.util.CachedThread.run(ThreadPool.java:137)
>
>
>
>
>
>
>
> "Rodrigo Sorriente" <rsorriente@equifax.com.br> wrote in message
> news:bhgu6m$4sts$1@news.boulder.ibm.com...
db2admin[QUOTE][color=darkred]
> that
> TWSA
> you
the[QUOTE][color=darkred]
undefined[QUOTE][color=darkred]
created[QUOTE][color=darkred]
>
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com