Scheduler error

, ,
1

Hi All,

I’m seeing the below err in my server log, how can i get rid of this… ?

[1051] [1050]2010-07-06 16:38:50 IST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist [1049] [1048]2010-07-06 16:37:50 IST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist [1047] [1046]2010-07-06 16:36:50 IST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist [1045] [1044]2010-07-06 16:35:50 IST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist [1043] [1042]2010-07-06 16:34:50 IST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist [1041] [1040]2010-07-06 16:33:50 IST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

Thank you,
Naidu

2

have you configured IS-Internal/IS Core Audit… scheduler information is stored in tables there, make sure the database is up and running.

3

Yeah Dev is right and also, Check the JDBC pools if you already installed the cored Audit tables.

Cheers,
Akshith

4

Hi,

I checked out the jdbc pools, they all were connected successfully. I checked in trying to install all the tables again using db configurator. Everything was done, and my db is up in running.

FYI …

When i try to see what are the sheduled services running in the admin page… the scheduler page is also with the same error.
[wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

thank you,
Naidu

5

Naidu,

The user ID that you are using in the JDBC pools to connect to the database, what privileges does it have? It should have select,insert,update and delete privileges on the tables.

Cheers,
Akshith

6

Ya, the user is a DBA, and he has access to everything. But the issue is sill there…

FYI… the prob was not there before… but came recently not sure of the reason, as the error is not stopping me from my work

This is webM 8.0

  • Naidu
7

Naidu,

Have you tried restarting JDBC pools / IS?

8

ya… ofcourse… as it will be the first option of getting to any prob. in webMethods :wink:

9

Hmm… that’s true…

Are you using same user in jdbc pools to connect to DB that was used to run DB scripts?

10

Hey… thanks a lot for your responses. I finally found the error… it was the error with the table IS_USER_TASKS table, it was not existing in the tables, though i created all the tables using DB configurator.

Anyways thanks to all ur responses.

Naidu

11

Glad to know that, but just out of curosity how you created this table now … again running DB scripts?

12

This time, I didn’t select the schema ALL in the db configurator. I selected IS INTERNAL schema explicitly for getting this table.

13

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.