Problemin Integration server (Database Storage problem)

, ,
1

Hi All,

I am keep on getting below error in server log, am using wM7.1.1,please give me the solution.

Note:in IS JDBC Pools configuration,i associated pool alias and tested ,it working fine.

2009-07-24 09:16:38 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2009-07-24 09:16:44 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2009-07-24 09:16:49 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2009-07-24 09:16:54 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2009-07-24 09:16:59 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2009-07-24 09:17:04 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2009-07-24 09:17:09 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2009-07-24 09:17:15 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2009-07-24 09:17:20 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2009-07-24 09:17:25 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2009-07-24 09:17:30 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2009-07-24 09:17:35 IST [PRT.0101.0512W] *** Database Storage problem. Exception: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not.

Regards,
Anil kumar Ellendula

2

You need to run the Database Configurator tool to create the necessary tables required by the wM products.

3

If you are running on Oracle 10g with webMethods 7.1 in your local machine with all the components of webMethods, then this would occur. Please check at the DB level when you have this exception, if you are able to log in.

It might throw you an ORA error over there. Your next steps might be based on the ORA error.

Hope this helps.

4

donot have DB in my machine,it is in other machine,am connection from is jdbdc pool,i ran DB configurator correctly,it is created tables,am not not gertting where is mistake,could u pls help me.

5

You will have to check the if the IS INTERNAL schema is loaded properly.
Mostly you are getting this error if some tables are missing for the IS INTERNAL schema.

Regards,
Monish

6

check the database name you have given in the jdbc adapter conection the name is case sensitive for ex data base name is XE you need to give as XE only