none
Internal Network library Error HIS 2009 RRS feed

  • Question

  • I tried to query and update data in DB2/AS400 via Host Integration Server 2009. But I got the "Internal Network Library Error".

    I found there are some topics about this issue, but there are no answers for it.

    I copy my trace result here. Please give me your help if you have solved it.

    Connection String:

    Provider=DB2OLEDB;User ID=****;Password=****;Initial Catalog=AS400***;APPC Mode Name=#INTER;Network Transport Library=TCPIP;Host CCSID=37;PC Code Page=1252;Network Address=AS400**.***.COM;Network Port=446;Package Collection=YK;Process Binary as Character=True;Units of Work=RUW;DBMS Platform=DB2/AS400;APPC Security Type=Program;Defer Prepare=True;Rowset Cache Size=0;Authentication=Server;Persist Security Info=True;Connection Pooling=False;Derive Parameters=False;

    Trace Result 1:

     

    Function Entry/Exit7/21/2011       10:07:23.521    Leaving DRDAGetColumnData                                                                            2664            5808            914             DRDAGetColumnDatadrdaardll.cpp   0               

    Function Entry/Exit7/21/2011       10:07:23.521    Entering DRDAReleaseRows                                                                             2664            5808            941             DRDAReleaseRows drdaardll.cpp   0               

    Function Entry/Exit7/21/2011       10:07:23.521    Leaving DRDAReleaseRows                                                                              2664            5808            946             DRDAReleaseRows drdaardll.cpp   0               

    Function Entry/Exit7/21/2011       10:07:23.521    Entering DRDAGetRows                                                                                 2664            5808            828             DRDAGetRows     drdaardll.cpp   0               

    Recoverable     7/21/2011       10:07:23.522    Data exchange exception (-1) in c:\hisv8\private\data\db2\drdaar\source\core\drdaardll.cpp at line 8442664            5808            844             DRDAGetRows     drdaardll.cpp   0               

    Function Entry/Exit7/21/2011       10:07:23.523    Entering DRDAGetDiagRec                                                                              2664            5808            483             DRDAGetDiagRec  drdaardll.cpp   0               

    Function Entry/Exit7/21/2011       10:07:23.523    Leaving DRDAGetDiagRec                                                                               2664            5808            493             DRDAGetDiagRec  drdaardll.cpp   0               

    Function Entry/Exit7/21/2011       10:07:23.523    Entering DRDAReleaseRows        

     

    Trace Result 2:

     

    State Transition7/21/2011       10:07:23.521    Converting multibyte data with CCSID 0X03A9 to multibyte data with CCSID 0X04E4                      2664            5808            107             DRDAGetRows     nlslibrary.cpp  0               

    State Transition7/21/2011       10:07:23.521    NLS   -----------------------------------------------------------------------                        2664            5808            49              DRDAGetRows     nlslibrary.cpp  0               

    State Transition7/21/2011       10:07:23.521    NLS   Input: Length = 5                                                                              2664            5808            51              DRDAGetRows     nlslibrary.cpp  0               

    State Transition7/21/2011       10:07:23.521    NLS   F0F2F0F0 F0                                                                                    2664            5808            86              DRDAGetRows     nlslibrary.cpp  0               

    State Transition7/21/2011       10:07:23.522    NLS   -----------------------------------------------------------------------                        2664            5808            49              DRDAGetRows     nlslibrary.cpp  0               

    State Transition7/21/2011       10:07:23.522    NLS   Output: Length = 0                                                                             2664            5808            51              DRDAGetRows     nlslibrary.cpp  0               

    State Transition7/21/2011       10:07:23.523    No errors in the message sync! Returning a warning.                                                  2664            5808            1708            DRDAGetDiagRec  requester.cpp   0               

    State Transition7/21/2011       10:07:23.523    Closing SQL Select Statement: SELECT ''  AS PROCEDURE_CAT, RTRIM(ROUTINE_SCHEMA)  AS PROCEDURE_SCHEM, RTRIM(ROUTINE_NAME)  AS PROCEDURE_NAME, IN_PARMS+INOUT_PARMS AS NUM_INPUT_PARAMS, OUT_PARMS+INOUT_PARMS AS NUM_OUTPUT_PARAMS, RESULT_SETS AS NUM_RESULT_SETS, RTRIM(LONG_COMMENT)  AS REMARKS FROM QSYS2.SYSPROCS ORDER BY PROCEDURE_CAT, PROCEDURE_SCHEM, PROCEDURE_NAME FOR FETCH ONLY2664            5808            164             DRDAFreeStmt    sqlselectcontrol.cpp0               

    State Transition7/21/2011       10:07:23.523    Buffer pool size: 2   

     

     


    • Moved by Steef-Jan WiggersMVP Thursday, July 21, 2011 9:04 AM HIS related (From:BizTalk Server General)
    Thursday, July 21, 2011 2:51 AM

Answers

  • You can see my trace result at the first beginning:

    State Transition7/21/2011       10:07:23.521    Converting multibyte data with CCSID 0X03A9 to multibyte data with CCSID 0X04E4                      2664            5808            107             DRDAGetRows     nlslibrary.cpp  0      

    CCSID 0X03A9= 937 which is encoding code in HOST system. (Traditional Chinese)

    However CCSID 0X04E4 = 1252 (ANSI Latin 1; Western European (Windows) http://msdn.microsoft.com/en-us/library/dd317756(VS.85).aspx) which is pc page code in windows system

     

    937 can't match 1252. So I change it to 950 (ANSI/OEM Traditional Chinese (Taiwan; Hong Kong SAR, PRC); Chinese Traditional (Big5)), and then it works.

     

    Hopes it can be useful when others get this issue.



    Steven Wang
    • Marked as answer by Wang Qi Friday, July 29, 2011 3:12 AM
    Friday, July 29, 2011 3:12 AM

All replies

  • The error is a generic error. Please open a support case so that we can better diagnose the problem, as we may need additional traces, along with a network capture.


    Charles Ezzell - MSFT
    Thursday, July 21, 2011 3:03 PM
  • Thanks. How can I log a support case and how much does it cost?
    Steven Wang
    Friday, July 22, 2011 1:48 AM
  • You can do the following to open a support case:

    - Go to http://support.microsoft.com/select/Default.aspx?target=assistance

    - Enter Host Integration Server 2009 in the Quick Product finder field.

    - Choose "Integrating Host Data" from the Support Topic drop-down list.

    - Choose "OLE DB Provider for DB2 (DB2OLEDB)" from the Sub-Topic list.

    - Click Continue

    This takes you to the payment methods page. If you have a MSDN contract or Software Assurance License, select the correct option. If you don't, choose the Don’t use a professional support license/contract (charges may apply) option. Click Continue to see the pricing options that are listed. The options shown are $99 for an email only support case and $259 for a phone callback case. These are US costs. If you are not in the US, then you will see location specific pricing.

    Of course, if your company has a Premier Support Contract, you can get a case opened up through that contract. Someone within your organization would have the ability to do that.

    If the problem were to be identified as a bug, then any charges would be refunded.

    Thanks...

     


    Stephen Jackson - MSFT
    Friday, July 22, 2011 5:27 PM
  • OK, it was fixed now.
    Steven Wang
    Thursday, July 28, 2011 9:30 AM
  • Can you share what resolved the issue in case others run into the same problem?

    Thanks...


    Stephen Jackson - MSFT
    Thursday, July 28, 2011 12:38 PM
  • You can see my trace result at the first beginning:

    State Transition7/21/2011       10:07:23.521    Converting multibyte data with CCSID 0X03A9 to multibyte data with CCSID 0X04E4                      2664            5808            107             DRDAGetRows     nlslibrary.cpp  0      

    CCSID 0X03A9= 937 which is encoding code in HOST system. (Traditional Chinese)

    However CCSID 0X04E4 = 1252 (ANSI Latin 1; Western European (Windows) http://msdn.microsoft.com/en-us/library/dd317756(VS.85).aspx) which is pc page code in windows system

     

    937 can't match 1252. So I change it to 950 (ANSI/OEM Traditional Chinese (Taiwan; Hong Kong SAR, PRC); Chinese Traditional (Big5)), and then it works.

     

    Hopes it can be useful when others get this issue.



    Steven Wang
    • Marked as answer by Wang Qi Friday, July 29, 2011 3:12 AM
    Friday, July 29, 2011 3:12 AM