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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Expand all | Collapse all

pub.db.execSQL not giving result in production environment

  • 1.  pub.db.execSQL not giving result in production environment

    Posted 05/22/07 04:33 PM

    Hi all,

    I Varma , I new to WM developer,

    The problem is for making DailyReport, I have one service i ran in development server it is working fine. While running production server it when it comes to pub.db.execSQL whith out giving any result(doc list),row count & db massage moving to next step(it showing priviouly which executed Sql rowcount even i dropped the varible in pipeline)

    Could you please reply for solution.
    Advanced thanks for all.

    Thanks & Records,
    Varma


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


  • 2.  RE: pub.db.execSQL not giving result in production environment

    Posted 05/23/07 04:35 PM

    Hi varma,
    Check whether the db is connected on Production. If connected check whether data exist in the db.

    Regards,
    RDS


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods