How to fix these kind of errors

, ,
1

Hi,

I m new to webMethods please help me to fix these issues.

[15624]2017-05-10 17:52:39 IST [WmAuditingSC.destination.1126E] Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15623]2017-05-10 17:52:39 IST [WmAuditingSC.destination.1126E] Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15622] at com.webMethods.sc.auditing.queue.AuditQueueWorker.run(AuditQueueWorker.java:85)
[15621] at com.webMethods.sc.auditing.queue.AuditQueueWorker.processEvent(AuditQueueWorker.java:181)
[15620] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:622)
[15619] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.open(WmDatabaseDestination.java:267)
[15618]com.webMethods.sc.auditing.API.destination.WmAuditDestinationException: Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15617]2017-05-10 17:52:37 IST [WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘ErrorQueue’ failed to log event to destination ‘ErrorDBDest’; reason ‘Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME’; stack trace follows
[15616]2017-05-10 17:52:37 IST [WmAuditingSC.destination.1126E] Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15615]2017-05-10 17:52:37 IST [WmAuditingSC.logger.3405E] In logger ‘Error Logger’, failed to log to destination; reason: Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15614]2017-05-10 17:52:37 IST [WmAuditingSC.destination.1126E] Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15613] at com.webMethods.sc.auditing.queue.AuditQueueWorker.run(AuditQueueWorker.java:85)
[15612] at com.webMethods.sc.auditing.queue.AuditQueueWorker.processEvent(AuditQueueWorker.java:181)
[15611] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:622)
[15610] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.open(WmDatabaseDestination.java:267)
[15609]com.webMethods.sc.auditing.API.destination.WmAuditDestinationException: Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15608]2017-05-10 17:52:37 IST [WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘ErrorQueue’ failed to log event to destination ‘ErrorDBDest’; reason ‘Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME’; stack trace follows
[15607]2017-05-10 17:52:37 IST [WmAuditingSC.destination.1126E] Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15606]2017-05-10 17:52:37 IST [WmAuditingSC.logger.3405E] In logger ‘Error Logger’, failed to log to destination; reason: Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15605]2017-05-10 17:52:37 IST [WmAuditingSC.destination.1126E] Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15604]2017-05-10 17:52:34 IST [WmAuditingSC.destination.1126E] Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15603]2017-05-10 17:52:34 IST [WmAuditingSC.destination.1126E] Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15602]2017-05-10 17:52:29 IST [WmAuditingSC.destination.1126E] Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15601]2017-05-10 17:52:29 IST [WmAuditingSC.destination.1126E] Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15600] at com.webMethods.sc.auditing.queue.AuditQueueWorker.run(AuditQueueWorker.java:85)
[15599] at com.webMethods.sc.auditing.queue.AuditQueueWorker.processEvent(AuditQueueWorker.java:181)
[15598] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:622)
[15597] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.open(WmDatabaseDestination.java:267)
[15596]com.webMethods.sc.auditing.API.destination.WmAuditDestinationException: Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15595]2017-05-10 17:52:24 IST [WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘ErrorQueue’ failed to log event to destination ‘ErrorDBDest’; reason ‘Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME’; stack trace follows
[15594]2017-05-10 17:52:24 IST [WmAuditingSC.destination.1126E] Failed to open connection to database; reason: [SoftwareAG][Oracle JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME
[15593] at com.webMethods.sc.auditing.queue.AuditQueueWorker.run(AuditQueueWorker.java:85)

2

Hi Ramesh,

please check in the IS Admin UI under Settings → JDBC-Pools → Pools section, if the URL for the pools is correct.

If IS is not starting due to this error you will find the appropriate configuration files under:
IntegrationServer/<instances/default/>config/jdbc/pools
These are XML-files which can be edited with any text editor.

Please provide a screen shot of your pool config.

Which version of wM are you using?

Regards,
Holger

3

Hi Holger,

I fixed those errors,could you please provide me solution to these errors.

I am using wM 9.12.

Thanks

[3275]2017-05-11 10:50:36 IST [WmAuditingSC.queue.2416I] In queue ‘ErrorQueue’ worker, the preceding error is non-recoverable; failing-over
[3274] … 2 more
[3273] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:636)
[3272] at com.wm.dd.jdbc.oraclebase.dddz.executeBatch(Unknown Source)
[3271] at com.wm.dd.jdbc.oraclebase.dddz.a(Unknown Source)
[3270] at com.wm.dd.jdbc.oraclebase.dde3.a(Unknown Source)
[3269] at com.wm.dd.jdbc.oraclebase.dddz.l(Unknown Source)
[3268]
[3267]Caused by: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3266] at com.webMethods.sc.auditing.queue.AuditQueueWorker.run(AuditQueueWorker.java:85)
[3265] at com.webMethods.sc.auditing.queue.AuditQueueWorker.processEvent(AuditQueueWorker.java:181)
[3264] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:644)
[3263] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.handleLoggingException(WmDatabaseDestination.java:736)
[3262] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.sqlToAuditingException(WmDatabaseDestination.java:1206)
[3261]com.webMethods.sc.auditing.API.destination.WmFatalDestinationException: Fatal SQLException detected
[3260]'; stack trace follows
[3259]2017-05-11 10:50:36 IST [WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘ErrorQueue’ failed to log event to destination ‘ErrorDBDest’; reason ‘[SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3258]
[3257]2017-05-11 10:50:36 IST [WmAuditingSC.destination.1122E] Destination ‘ErrorDBDest’ caught unexpected Throwable logging audit event: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3256]2017-05-11 10:50:36 IST [WmAuditingSC.logger.3405E] In logger ‘Error Logger’, failed to log to destination; reason: Fatal SQLException detected
[3255]
[3254]2017-05-11 10:50:36 IST [WmAuditingSC.destination.1122E] Destination ‘ErrorDBDest’ caught unexpected Throwable logging audit event: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3253]2017-05-11 10:50:00 IST [WmAuditingSC.queue.2416I] In queue ‘ErrorQueue’ worker, the preceding error is non-recoverable; failing-over
[3252] … 2 more
[3251] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:636)
[3250] at com.wm.dd.jdbc.oraclebase.dddz.executeBatch(Unknown Source)
[3249] at com.wm.dd.jdbc.oraclebase.dddz.a(Unknown Source)
[3248] at com.wm.dd.jdbc.oraclebase.dde3.a(Unknown Source)
[3247] at com.wm.dd.jdbc.oraclebase.dddz.l(Unknown Source)
[3246]
[3245]Caused by: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3244] at com.webMethods.sc.auditing.queue.AuditQueueWorker.run(AuditQueueWorker.java:85)
[3243] at com.webMethods.sc.auditing.queue.AuditQueueWorker.processEvent(AuditQueueWorker.java:181)
[3242] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:644)
[3241] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.handleLoggingException(WmDatabaseDestination.java:736)
[3240] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.sqlToAuditingException(WmDatabaseDestination.java:1206)
[3239]com.webMethods.sc.auditing.API.destination.WmFatalDestinationException: Fatal SQLException detected
[3238]’; stack trace follows
[3237]2017-05-11 10:50:00 IST [WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘ErrorQueue’ failed to log event to destination ‘ErrorDBDest’; reason '[SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3236]
[3235]2017-05-11 10:50:00 IST [WmAuditingSC.destination.1122E] Destination ‘ErrorDBDest’ caught unexpected Throwable logging audit event: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3234]2017-05-11 10:49:59 IST [WmAuditingSC.logger.3405E] In logger ‘Error Logger’, failed to log to destination; reason: Fatal SQLException detected
[3233]
[3232]2017-05-11 10:49:59 IST [WmAuditingSC.destination.1122E] Destination ‘ErrorDBDest’ caught unexpected Throwable logging audit event: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3231]2017-05-11 10:49:59 IST [WmAuditingSC.queue.2416I] In queue ‘ErrorQueue’ worker, the preceding error is non-recoverable; failing-over
[3230] … 2 more
[3229] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:636)
[3228] at com.wm.dd.jdbc.oraclebase.dddz.executeBatch(Unknown Source)
[3227] at com.wm.dd.jdbc.oraclebase.dddz.a(Unknown Source)
[3226] at com.wm.dd.jdbc.oraclebase.dde3.a(Unknown Source)

jdbcpool.PNG
jdbcpool.PNG1919×936 94.8 KB

4

hi all,

could you please provide me solution to these errors.

I am using wM 9.12.

Thanks

[3275]2017-05-11 10:50:36 IST [WmAuditingSC.queue.2416I] In queue ‘ErrorQueue’ worker, the preceding error is non-recoverable; failing-over
[3274] … 2 more
[3273] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:636)
[3272] at com.wm.dd.jdbc.oraclebase.dddz.executeBatch(Unknown Source)
[3271] at com.wm.dd.jdbc.oraclebase.dddz.a(Unknown Source)
[3270] at com.wm.dd.jdbc.oraclebase.dde3.a(Unknown Source)
[3269] at com.wm.dd.jdbc.oraclebase.dddz.l(Unknown Source)
[3268]
[3267]Caused by: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3266] at com.webMethods.sc.auditing.queue.AuditQueueWorker.run(AuditQueueWorker.java:85)
[3265] at com.webMethods.sc.auditing.queue.AuditQueueWorker.processEvent(AuditQueueWorker.java:181)
[3264] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:644)
[3263] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.handleLoggingException(WmDatabaseDestination.java:736)
[3262] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.sqlToAuditingException(WmDatabaseDestination.java:1206)
[3261]com.webMethods.sc.auditing.API.destination.WmFatalDestinationException: Fatal SQLException detected
[3260]'; stack trace follows
[3259]2017-05-11 10:50:36 IST [WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘ErrorQueue’ failed to log event to destination ‘ErrorDBDest’; reason ‘[SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3258]
[3257]2017-05-11 10:50:36 IST [WmAuditingSC.destination.1122E] Destination ‘ErrorDBDest’ caught unexpected Throwable logging audit event: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3256]2017-05-11 10:50:36 IST [WmAuditingSC.logger.3405E] In logger ‘Error Logger’, failed to log to destination; reason: Fatal SQLException detected
[3255]
[3254]2017-05-11 10:50:36 IST [WmAuditingSC.destination.1122E] Destination ‘ErrorDBDest’ caught unexpected Throwable logging audit event: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3253]2017-05-11 10:50:00 IST [WmAuditingSC.queue.2416I] In queue ‘ErrorQueue’ worker, the preceding error is non-recoverable; failing-over
[3252] … 2 more
[3251] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:636)
[3250] at com.wm.dd.jdbc.oraclebase.dddz.executeBatch(Unknown Source)
[3249] at com.wm.dd.jdbc.oraclebase.dddz.a(Unknown Source)
[3248] at com.wm.dd.jdbc.oraclebase.dde3.a(Unknown Source)
[3247] at com.wm.dd.jdbc.oraclebase.dddz.l(Unknown Source)
[3246]
[3245]Caused by: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3244] at com.webMethods.sc.auditing.queue.AuditQueueWorker.run(AuditQueueWorker.java:85)
[3243] at com.webMethods.sc.auditing.queue.AuditQueueWorker.processEvent(AuditQueueWorker.java:181)
[3242] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:644)
[3241] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.handleLoggingException(WmDatabaseDestination.java:736)
[3240] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.sqlToAuditingException(WmDatabaseDestination.java:1206)
[3239]com.webMethods.sc.auditing.API.destination.WmFatalDestinationException: Fatal SQLException detected
[3238]’; stack trace follows
[3237]2017-05-11 10:50:00 IST [WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘ErrorQueue’ failed to log event to destination ‘ErrorDBDest’; reason '[SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3236]
[3235]2017-05-11 10:50:00 IST [WmAuditingSC.destination.1122E] Destination ‘ErrorDBDest’ caught unexpected Throwable logging audit event: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3234]2017-05-11 10:49:59 IST [WmAuditingSC.logger.3405E] In logger ‘Error Logger’, failed to log to destination; reason: Fatal SQLException detected
[3233]
[3232]2017-05-11 10:49:59 IST [WmAuditingSC.destination.1122E] Destination ‘ErrorDBDest’ caught unexpected Throwable logging audit event: com.wm.dd.jdbc.oraclebase.ddc: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
[3231]2017-05-11 10:49:59 IST [WmAuditingSC.queue.2416I] In queue ‘ErrorQueue’ worker, the preceding error is non-recoverable; failing-over
[3230] … 2 more
[3229] at com.webMethods.sc.auditing.destination.WmDatabaseDestination.logEvent(WmDatabaseDestination.java:636)
[3228] at com.wm.dd.jdbc.oraclebase.dddz.executeBatch(Unknown Source)
[3227] at com.wm.dd.jdbc.oraclebase.dddz.a(Unknown Source)
[3226] at com.wm.dd.jdbc.oraclebase.dde3.a(Unknown Source)

5

Did you see that message in the stacktrace ?

6

Hi Ramesh,

did you run the DatabaseConfigurator to create the users/schemata and the tables?

Regards,
Holger

7

hi

i m not running any service which is associated with tables or views because i m running a simple service called addTwoNumbers it does not required any db.

Thanks and regards
Ramesh

8

Hi Ramesh,

these tables are internal tables used for auditing by webMethods.

ErrorDBDest is referring o WMERROR table which is part of the Database Component ISCoreAudit.

Please run the Database Configurator tool to create these tables in your database.

Regards,
Holger

9

Hi Holger,

where should i create tables?
what are the table names?
i donot have any idea…
if you know something please help me

Thanks,
Ramesh

10

Hi Ramesh,

please have a look at the Installing webMethods Products Guide, Chapter 6 (Creating and Dropping Database Components).

You should have installed a tool named “Database Configurator” during your installation which also has a “Database Scripts” part, which contains the necceasary scripts for creatiung tablespaces, users, tables, etc.
This tool and its scripts can found under common/db/ directory structure.

For Oracle XE the tablespace directory should be specified as “C:<directory where Oracle XE is installed>\oraclexe\oradata”.
Do not specify the XE directory itself, otherwise the tool will create an additional XE directory under it.

Regards,
Holger

11

Thanks so much Holger…