Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

JMS probs during startup

5 views

Skip to first unread message

Eric Homer

unread,

Mar 3, 2004, 3:57:54 PM3/3/04

Hi,

I have been getting this error today. Did not have this prob yesterday and did

a clean shutdown at the time of leaving yesterday. But when I came in today and

tried to start the server, it is throwing the following errors.

The database is SQL Server 2000. I checked the persmissions and they are all
fine.

I also restored my database completely and got a fresh build version of the whole

domain directory. Still, it gives me this error. Any help is greatly appreciated.

This error is causing other errors and the app is not able to deploy.

Thanks,
Eric

<Mar 3, 2004 11:38:30 AM PST> <Alert> <JMS> <BEA-040205> <JMSServer "cgJMSServer".

An error occurred while trying to do a SQL SELECT on table "weblogicJMSState".
Check
privileges on this table. You may
need to specify [schema.[catalog.]] in your
configured prefix.>
<Mar 3, 2004 11:38:30 AM PST> <Alert> <JMS> <BEA-040320> <JMS server "cgJMSServer".

An error occurred while trying to do a
SQL UPDATE on table "weblogicJMSState". Check privileges on this table. You may

need to specify [schema.[catalog.]] in your configured prefix.>
<Mar 3, 2004 11:38:30 AM PST> <Alert> <JMS> <BEA-040052> <JMSServer "cgJMSServer"

store failed to open java.io.IOException:
JMS JDBC store, connection pool = <cgPool>, prefix = <weblogic>: change state

java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Invalid object
name
'weblogicJMSState'.
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

Tom Barnes

unread,

Mar 4, 2004, 11:16:15 AM3/4/04

to Eric Homer

Could you post full stack traces? Hopefully this will
reveal the original exception thrown by the database.

Eric Homer

unread,

Mar 4, 2004, 2:15:11 PM3/4/04

Tom,

Please find below the complete stack trace of the error. I pasted the JMS Error
and Deployment Error from the console. Any help is greatly appreciated.

Eric

Tom Barnes <pleasereplyinnewsgroup.webl...@newsgroups.bea.com>
wrote:

>Could you post full stack traces? Hopefully this will
>reveal the original exception thrown by the database.
>
>Eric Homer wrote:
>
>> Hi,
>>
>> I have been getting this error today. Did not have this prob yesterday
>and did
>>
>> a clean shutdown at the time of leaving yesterday. But when I came
>in today and
>>
>> tried to start the server, it is throwing the following errors.
>>
>> The database is SQL Server 2000. I checked the persmissions and they
>are all
>> fine.
>>
>> I also restored my database completely and got a fresh build version
>of the whole
>>
>> domain directory. Still, it gives me this error. Any help is greatly
>appreciated.
>>
>>
>> This error is causing other errors and the app is not able to deploy.
>
>>
>> Thanks,
>> Eric
>>

====================== JMS Error ============================

<Mar 4, 2004 11:02:06 AM PST> <Info> <JMS> <BEA-040108> <User connection factory
"cgQueue" is started.>
<Mar 4, 2004 11:02:06 AM PST> <Info> <JMS> <BEA-040321> <JMSServer "cgJMSServer"
is resuming.>
<Mar 4, 2004 11:02:07 AM PST> <Alert> <JMS> <BEA-040205> <JMSServer "cgJMSServer".

An error occurred while trying to do a SQ
L SELECT on table "weblogicJMSState". Check privileges on this table. You may
need to specify [schema.[catalog.]] in your co
nfigured prefix.>

<Mar 4, 2004 11:02:07 AM PST> <Alert> <JMS> <BEA-040320> <JMS server "cgJMSServer".

An error occurred while trying to do a S
QL UPDATE on table "weblogicJMSState". Check privileges on this table. You may
need to specify [schema.[catalog.]] in your c
onfigured prefix.>

<Mar 4, 2004 11:02:07 AM PST> <Alert> <JMS> <BEA-040052> <JMSServer "cgJMSServer"

store failed to open java.io.IOException:
JMS JDBC store, connection pool = <cgPool>, prefix = <weblogic>: change state
java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Invalid object name
'weblogicJMSState'.
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at weblogic.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown
Source)
at weblogic.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at weblogic.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:94)
at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:615)
at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2084)
at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
at weblogic.jms.backend.BEStore.open(BEStore.java:262)
at weblogic.jms.backend.BEStore.start(BEStore.java:151)
at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1290)
at weblogic.jms.JMSService.addJMSServer(JMSService.java:2241)
at weblogic.jms.JMSService.addDeployment(JMSService.java:2012)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:330)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:590)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:568)
at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:240)
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 weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:711)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:690)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:476)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:947)
at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:908)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7271)
at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1210)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:362)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:
229)
at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
at weblogic.Server.main(Server.java:32)
.

java.io.IOException: JMS JDBC store, connection pool = <cgPool>, prefix = <weblogic>:
change state
java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Invalid object name
'weblogicJMSState'.
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at weblogic.jms.store.JDBCIOStream.throwIOException(JDBCIOStream.java:369)
at weblogic.jms.store.JDBCIOStream.changeState(JDBCIOStream.java:636)
at weblogic.jms.store.JDBCIOStream.setVersion(JDBCIOStream.java:2084)
at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream.java:432)
at weblogic.jms.store.JMSStore.open(JMSStore.java:224)
at weblogic.jms.backend.BEStore.open(BEStore.java:262)
at weblogic.jms.backend.BEStore.start(BEStore.java:151)
at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1290)
at weblogic.jms.JMSService.addJMSServer(JMSService.java:2241)
at weblogic.jms.JMSService.addDeployment(JMSService.java:2012)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:330)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:590)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:568)
at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:240)
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 weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:711)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:690)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:476)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:947)
at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:908)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7271)
at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1210)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:362)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:
229)
at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
at weblogic.Server.main(Server.java:32)
>
<Mar 4, 2004 11:02:07 AM PST> <Error> <JMS> <BEA-040123> <Failed to start JMS
Server "cgJMSServer" due to weblogic.jms.commo
n.JMSException: JMS can not open store cgJMSStore.
weblogic.jms.common.JMSException: JMS can not open store cgJMSStore
at weblogic.jms.backend.BEStore.start(BEStore.java:163)
at weblogic.jms.backend.BackEnd.openStores(BackEnd.java:1171)
at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1290)
at weblogic.jms.JMSService.addJMSServer(JMSService.java:2241)
at weblogic.jms.JMSService.addDeployment(JMSService.java:2012)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:330)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:590)
at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:568)
at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:240)
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 weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:711)
at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:690)
at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:476)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:947)
at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:908)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7271)
at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1210)
at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:362)
at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:
229)
at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:964)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:359)
at weblogic.Server.main(Server.java:32)
Caused by: java.io.IOException: JMS JDBC store, connection pool = <cgPool>, prefix

= <weblogic>: change state
java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Invalid object name
'weblogicJMSState'.
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

============= Deployement Error ============================
<Mar 4, 2004 11:06:45 AM PST> <Warning> <Deployer> <BEA-149004> <Failures were
detected while initiating Deploy task for app
lication ahlPortalApp.>
<Mar 4, 2004 11:06:45 AM PST> <Error> <Deployer> <BEA-149201> <Failed to complete
the deployment task with ID 1 for the appl
ication ahlPortalApp.
weblogic.management.DeploymentException:
Exception:weblogic.management.ApplicationException: activate failed for content_repo.jar
Module: content_repo.jar Error: Exception activating module: EJBModule(content_repo.jar,status=PREPARED)

Unable to deploy EJB: RepoPropertyChoiceEJB from content_repo.jar:

[EJB:011076]Unable to deploy the EJB 'RepoPropertyChoiceEJB' because the database
table 'CM_PROPERTY_CHOICE' is not accessib
le. Please ensure that this table exists and is accessible.

at weblogic.management.deploy.slave.SlaveDeployer$ActivateTask.doCommit(SlaveDeployer.java:2517)
at weblogic.management.deploy.slave.SlaveDeployer$Task.commit(SlaveDeployer.java:2317)
at weblogic.management.deploy.slave.SlaveDeployer$Task.checkAutoCommit(SlaveDeployer.java:2399)
at weblogic.management.deploy.slave.SlaveDeployer$Task.prepare(SlaveDeployer.java:2311)
at weblogic.management.deploy.slave.SlaveDeployer$ActivateTask.prepare(SlaveDeployer.java:2479)
at weblogic.management.deploy.slave.SlaveDeployer.processPrepareTask(SlaveDeployer.java:798)
at weblogic.management.deploy.slave.SlaveDeployer.prepareDelta(SlaveDeployer.java:507)
at weblogic.management.deploy.slave.SlaveDeployer.prepareUpdate(SlaveDeployer.java:465)
at weblogic.drs.internal.SlaveCallbackHandler$1.execute(SlaveCallbackHandler.java:25)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
--------------- nested within: ------------------
weblogic.management.ManagementException: - with nested exception:
[weblogic.management.DeploymentException:
Exception:weblogic.management.ApplicationException: activate failed for content_repo.jar
Module: content_repo.jar Error: Exception activating module: EJBModule(content_repo.jar,status=PREPARED)

Unable to deploy EJB: RepoPropertyChoiceEJB from content_repo.jar:

[EJB:011076]Unable to deploy the EJB 'RepoPropertyChoiceEJB' because the database
table 'CM_PROPERTY_CHOICE' is not accessib
le. Please ensure that this table exists and is accessible.

]
at weblogic.management.deploy.slave.SlaveDeployer$ActivateTask.prepare(SlaveDeployer.java:2491)
at weblogic.management.deploy.slave.SlaveDeployer.processPrepareTask(SlaveDeployer.java:798)
at weblogic.management.deploy.slave.SlaveDeployer.prepareDelta(SlaveDeployer.java:507)
at weblogic.management.deploy.slave.SlaveDeployer.prepareUpdate(SlaveDeployer.java:465)
at weblogic.drs.internal.SlaveCallbackHandler$1.execute(SlaveCallbackHandler.java:25)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
>

Tom Barnes

unread,

Mar 4, 2004, 4:04:05 PM3/4/04

to Eric Homer

Did you mean to configure "weblogic." rather
than "weblogic" as the prefix?

Note that not just JMS JDBC is failing to work with
the database, your EJBs are failing as well,
search for 'CM_PROPERTY_CHOICE' below.

0 new messages