Scheduler Error.

jerrywm · May 31, 2016, 12:47pm

Hi Team,

I have newly Installed the latest version WM 9.9 Trial Version and latest version of Oracle 11G Version.
Now my IS has started successfully and also I have configured the DB configurator as well successfully.

But I am getting an DB error as [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist when I click on the scheduler tab under server in my IS Page.

So because of this I am unable to create any schedulers as well.So can someone please help me out of out to fix out this issue please.Its urgent for me.

Also I have attached the attachment as well for your reference.

Nivesh_Jain · May 31, 2016, 1:21pm

Hi Jerry,

It seems you did not configure the database schema using database configuration manager.

I do not know the exact steps to configure it, hope some one help you here.

jerrywm · May 31, 2016, 1:56pm

Actually I have created the tables and user VIA database configuration.

Holger_von_Thomsen · May 31, 2016, 2:06pm

Hi Jerry,

which set of tables did you select in the Db Configurator?

Are there further informations in either server or error log of IS related to this?

For the schedulers you will at least need the tables of ISInternal, the table you are lookinfg for is IS_USERS_TASKS.

Is the JDBC Pool configured and connecting to the database?
Is the function ISInternal assigned a JDBC Pool?

Regards,
Holger

jerrywm · May 31, 2016, 2:39pm

Hi holger,

I have selected created TYPE as CREATE and Component as ALL in the DB Configurator, where I hope it would be create all the tables with respect to all the components in WM9.9.

These are the list of errors which I have got in my Server.log file during my IS Startup.

2016-05-24 04:00:25 CDT [ISS.0137.0006E] Scheduler: Error initializing scheduler: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2016-05-24 04:00:27 CDT [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2016-05-24 04:00:41 CDT [ISS.0028.0013E] Startup service exited with the following error: com.wm.app.b2b.server.ServiceException: [Exception: Unable to connect to database!] not found in “com.wm.resources.CoreExcpMsgs”.
2016-05-24 04:00:42 CDT [ISS.0137.0016E] Scheduler: Exception getting task IDs from database: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2016-05-24 04:00:44 CDT [ISS.0137.0012E] Scheduler: Error inserting task into database: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2016-05-24 04:01:04 CDT [ISU.0000.9999C] com.wm.app.tn.db.DatastoreException: Trading Networks could not retrieve data from your database. Go to the JDBC Pools page in the Integration Server Administrator and make sure your database URL, user name, and password are set correctly. Also make sure you created the Trading Networks database tables as described in the webMethods Installation Guide.
(0) java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2016-05-24 04:01:11 CDT [TNS.0002.1082I] Warning: SQLException retrieving Delivery Services from database: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2016-05-24 04:01:11 CDT [ISU.0000.9999W] java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2016-05-24 04:01:11 CDT [TNS.0002.1082I] TN Task Manager - Job Ordering Method is set to = default
2016-05-24 04:01:11 CDT [TNS.0002.1082I] Warning: SQLException retrieving Delivery Jobs from database: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2016-05-24 04:01:11 CDT [ISU.0000.9999W] java.sql.SQLSyntaxErrorException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2016-05-24 04:01:29 CDT [ISS.0153.0094E] Unable to start webMethods Messaging connection alias IS_UM_CONNECTION. The server will attempt to reconnect every 20 seconds: [ISS.0153.9051] Error initializing UM session: com.pcbsys.nirvana.client.nRealmUnreachableException: Realm is currently not reachable:com.pcbsys.foundation.base.fException: Retry count=2 exceeded attempting to connect to host - [nsp://localhost:9000/]
2016-05-24 04:02:12 CDT [ISS.0137.0006E] Scheduler: Error initializing scheduler: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

2016-05-24 04:03:12 CDT [ISS.0137.0006E] Scheduler: Error initializing scheduler: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

Also the JDBC pool has been configured successfully and when I test it its showing as successfull and even for ISInternal as well.

Also attached the Screenshot and complete server logs for your reference.

Regards,
Jerry.

server.log (619 KB)

Holger_von_Thomsen · May 31, 2016, 6:10pm

Hi Jerry,

please increase the logging level for the following Log Factories:
Integration Server - 0003 Database Connection Manager
Integration Server - 0096 JDBC Connection Manager
Trading Networks - 0000 Database

Hopefully this will reveal which tables can not be accessed.

Can you check directly in the database schema for the tables?
See the view Installed_Components for an overview.
Eventually there have been issues during creation.
Can you check the log file of the DatabaseConfigurator for this?

Regards,
Holger

jerrywm · June 4, 2016, 8:51pm

Thanks Holger… That made me to fix the issue…thanks alot:) :lol: :lol: :lol:

Gireesh_Mullapally1 · August 25, 2018, 12:26pm

@Jerrywm - How did you fix this ? Running database configuration again ?