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
Back to discussions
Expand all | Collapse all

JDBC Adapter services Issue(6.5)

  • 1.  JDBC Adapter services Issue(6.5)

    Posted Thu March 06, 2008 05:57 AM

    We are facing an issue while deploying adapter services from one environment to the other in webMethods

    JDBC Adapter Version: 6.5

    Fixes: JDBC_6-5_Fix4
    JDBC_6-5_Fix7
    JDBC_6-5_Fix8

    Procedure followed to deploy adapter services/connections in new environment:

    1.   We have the JDBC adapter connections and adapter services maintained in separate packages.

    a. Across environments (Dev, QA) we have the same JDBC adapter connection name and DB schema name. Therefore upon deployment, we edit the application server name, password for the adapter connection and enable the connection. Connection looks fine.

    b. Install the adapter services package and check references for all adapter services.(storedProcedureWithSignature). All services have correct references to the adapter connection

    The Issue

    1.   When the adapter service (configured for storedProcedureWithSignature) is executed I get the following error:

    Could not run .com.wm.app.b2b.server.ServiceException: [ART.117.4021] Adapter Runtime (Adapter Service): Unable to invoke adapter service cox.cns.eventprocessor.services.adapter:hasOtherActiveServices. Unable to get adapter service template.
    [ART.114.72] Adapter Runtime: Unable to set JavaBean properties.
    [ART.114.542] could not set property “resultSetInfo” in class “com.wm.adapter.wmjdbc.services.ProcedureSignature”.
    Method not found: getResultSetInfo
    Also on subsequent execution of the service , null exception is thrown.

    1.   Though once the adapter service is saved and executed, the service runs successfully. No major changes made to the adapter service when it is saved. 

    2.   This is not the right approach and therefore looking for a solution to this strange problem.

    If anyone has experienced such issues or has any insights on the above condition, please send in your comments. Any suggestion would be helpful!


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: JDBC Adapter services Issue(6.5)

    Posted Tue March 11, 2008 10:09 AM

    I could find the below from troubleshoot guide.

    [B][FONT=ArialNarrow,Bold][SIZE=2]

    ART.0117.4021E Adapter Runtime (Adapter Service): Unable to invoke
    adapter service template.
    Explanation: [/b][/size][/font]WmART failed to create an instance of the specified [FONT=ArialNarrow,Bold][SIZE=2]Recommended Action: [/size][/font][FONT=PalatinoLinotype][SIZE=2][FONT=PalatinoLinotype][SIZE=2]
    Ensure that the implementation class for the adapter service is installed correctly in the package. Call Technical Services if the problem persists.

    Cheers
    Guna

    [/size][/font][/SIZE][/FONT]


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


Related Content