webMethods

webMethods

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.

 View Only
Expand all | Collapse all

[wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specifie

  • 1.  [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specifie

    Posted Wed August 11, 2010 01:03 PM

    Hi all,
    am using wm8SP2 environment,am keep on getting below error in server log

    967]2010-08-11 13:02:35 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [966]2010-08-11 13:01:35 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [965]2010-08-11 13:00:35 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [964]2010-08-11 12:59:35 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [963]2010-08-11 12:58:35 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [962]2010-08-11 12:57:35 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [961]2010-08-11 12:56:35 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [960]2010-08-11 12:55:35 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [959]2010-08-11 12:54:34 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [958]2010-08-11 12:53:34 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [957]2010-08-11 12:52:34 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [956]2010-08-11 12:51:34 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [955]2010-08-11 12:50:34 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [954]2010-08-11 12:49:34 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [953]2010-08-11 12:48:34 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [952]2010-08-11 12:47:34 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.
    [951]2010-08-11 12:46:34 CEST [ISS.0137.0011E] Scheduler: Exception: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specified.

    Regards,
    Anil Kumar Ellendula


    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specifie

    Posted Tue August 17, 2010 05:18 AM

    Hi Anil,

    Are you still getting this error?

    There are some questions that I would appreciate to get answers from you, which will help me understand what the problem is:

    1. Would you know which particular Scheduler when run is causing this error?
    2. Did you ever encounter the same SQL error running any other Service that connects or accesses the database?
    3. What database server are you using? Which JDBC driver?
    4. Can you send me your server.log and server.cnf ?

    Thank you.

    All the best,
    MAC


    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specifie

    Posted Tue August 17, 2010 12:15 PM

    We are using SQL Server 2008 version(10.0.2531), there is no Schedulers using database connections, now am not getting this error in server log,i was getting this error last week, last week end i have restarted the IS and other services from services.msc, than i didnot see this error this week, if i get same error, i will reply on same post, i donot why i can’t attache server log files now, may be more size.

    regards,
    anil kumar ellendula


    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: [wm-cjdbc40-0034][SQLServer JDBC Driver]Invalid SQL specifie

    Posted Fri April 29, 2011 12:16 AM

    did you ever find a solution for this? i’m having the same problem

    thanks!


    #Integration-Server-and-ESB
    #webMethods