Results 1 to 1 of 1

Thread: DF 23 - WebOrderMobile converted to db2 - Not able to run - Fails with db2 SQLSTATE 22003 at startup

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Brazil
    Posts
    5,648

    Default DF 23 - WebOrderMobile converted to db2 - Not able to run - Fails with db2 SQLSTATE 22003 at startup

    ——— edit ———
    Please, ignore this post !!!

    this issue seems to be related to a bad/corrupted cache .cch file.
    I don’t know what exactly went wrong during the conversion, but after deleting all cch files the issue is not happening anymore!

    ——— end edit ———


    Convert WebOrderMobile to db2.

    Just plain convert.. accept all defaults (DB simply created as "create db <dbname>" , nothing else

    After tables conversion, All tables can be successfully opened by dB Explorer.

    But, when you start the webapplication, you get followin error at startup:

    Code:
    C:\DataFlex 23.0 Examples\WebOrderMobile_db2\Programs\WebApp.exe
    Erro genérico 22003 (-99999)--[IBM][CLI Driver] CLI0111E  Numeric value out of range. SQLSTATE=22003  Table = OrderHeader (30), Source = DB2_DRV.Find
    Erro número: 12289 linha: 6534.
    
    
    MSG_UNHANDLEDERRORDISPLAY (5370) - oErrorHandler (5) - at address 13785
    MSG_BASICERRORREPORT (5372) - oErrorHandler (5) - at address 13842
    MSG_HANDLEERROR (4990) - oErrorHandler (5) - at address 13899
    MSG_ERROR_REPORT (433) - oErrorHandler (5) - at address 9686
    MSG_DATA_SET_POSTFIND (1751) - oOrderHeaderDataDictionary (249) - at address 6536
    MSG_ADD_USER_INTERFACE (381) - oOrderHeaderDataDictionary (249) - in native code
    MSG_ATTACH_DEO_TO_SERVER (340) - oPromptList (257) - at address 18592
    MSG_ATTACH_DEO_TO_SERVER (340) - oPromptList (257) - at address 23912
    MSG_END_CONSTRUCT_OBJECT (459) - oOrderWebLookup (234) - at address 27007
    MSG_END_CONSTRUCT_OBJECT (459) - oOrderWebLookup (234) - at address 28599
    [start] - at address 37524
    Ps. Tested the same approach with DF 19.1 and it worked just fine..

    Ps #2: I can't currently test with DF 24, as my install expired, and I haven't received my permanent license codes yet..
    Last edited by Samuel Pizarro; 14-Jun-2024 at 02:54 PM.
    Samuel Pizarro

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •