IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Expand all | Collapse all

How to fix these kind of errors

  • 1.  How to fix these kind of errors

    Posted Wed May 10, 2017 10:28 AM

    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)


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 2.  RE: How to fix these kind of errors

    Posted Wed May 10, 2017 01:57 PM

    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


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 3.  RE: How to fix these kind of errors

    Posted Thu May 11, 2017 03:29 AM

    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)


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 4.  RE: How to fix these kind of errors

    Posted Thu May 11, 2017 04:04 AM

    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)


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB


  • 5.  RE: How to fix these kind of errors

    Posted Thu May 11, 2017 08:11 AM

    Did you see that message in the stacktrace ?


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 6.  RE: How to fix these kind of errors

    Posted Thu May 11, 2017 10:14 AM

    Hi Ramesh,

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

    Regards,
    Holger


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 7.  RE: How to fix these kind of errors

    Posted Thu May 11, 2017 11:07 AM

    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


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB


  • 8.  RE: How to fix these kind of errors

    Posted Thu May 11, 2017 11:12 AM

    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


    #Integration-Server-and-ESB
    #webMethods-General
    #webMethods


  • 9.  RE: How to fix these kind of errors

    Posted Thu May 11, 2017 11:17 AM

    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


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General


  • 10.  RE: How to fix these kind of errors

    Posted Thu May 11, 2017 12:57 PM

    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


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 11.  RE: How to fix these kind of errors

    Posted Fri May 12, 2017 02:34 AM