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

pub.alert:fetchUnread throwing error SQL command not properly ended

  • 1.  pub.alert:fetchUnread throwing error SQL command not properly ended

    Posted Tue May 28, 2024 02:27 AM

    Hiii Everyone,

    java.sql.SQLException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended
    Caused by: com.wm.app.b2b.server.ServiceException: java.sql.SQLException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended
    Caused by: java.sql.SQLException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended
    pub.alert:fetchUnread

    I got this error while running the service pub.alert:fetchUnread, please anyone suggest me the solution.


    #Integration-Server-and-ESB
    #Service-Designer
    #webMethods


  • 2.  RE: pub.alert:fetchUnread throwing error SQL command not properly ended

    Posted Tue May 28, 2024 02:28 AM


  • 3.  RE: pub.alert:fetchUnread throwing error SQL command not properly ended

    Posted Wed May 29, 2024 05:09 AM

    Hello Kasim,

    Are you seeing this after applying the fixes? If yes, please raise an itrac with all the required information.

    Regards,
    Manjunath


    #Service-Designer
    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: pub.alert:fetchUnread throwing error SQL command not properly ended

    Posted Wed May 29, 2024 05:27 AM

    Hello Manjunath Sathyanarayana,

    I’m seeing this issue without applying fixes. I do the fresh installation of version 10.15 on linux.

    Regards,
    Kasim


    #Integration-Server-and-ESB
    #Service-Designer
    #webMethods