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
  • 1.  Trnserv.000012.000114

    Posted Mon February 19, 2007 06:21 PM

    Hi there!!!
    when i try to start the TNConsole its showing this error code
    TRNSERV.000012.000114 with error message TRNCONS.000001.000005
    COULD NOT RETRIEVE ID TYPES FROM DATABASE

    java.sql.SQLexception:[wm-cjdbc36-0007][Oracle JDBC Driver] No more data available to read

    this error is repeating like 16 times with error message heading TRNCONS.000001.000005.

    I ran the dbscripts and also made changes in JDBC tools in ISADMIN page.

    Could any one of you specify the reason ASAP.


    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods


  • 2.  RE: Trnserv.000012.000114

    Posted Mon February 19, 2007 06:36 PM

    what is your IS/TNS version??

    Even though you ran all the necessary Oracle db scripts successfully… the error above indicates SQLexception when it is trying to retreive some ID’s from ext DB…this results db scripts run was not successful…For troubleshooting if possible drop all the created tables and re-execute the db scripts and configure the TN jdbc pools with wM provided drivers,dry run the test function alias connection…Restart the IS and try login thru TNConsole and see what happens.

    HTH,
    RMG


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 3.  RE: Trnserv.000012.000114

    Posted Tue February 20, 2007 03:08 PM

    “No more data available to read” could mean a problem with the connection to the database. Check your JDBC Pool settings for the TN pool. If not done so already, consider setting Minimum Connections for the TN pool to 0.

    • Percio

    #Integration-Server-and-ESB
    #webMethods
    #B2B-Integration