Informix

 View Only
Expand all | Collapse all

Error -404 When Running cdr realize template

  • 1.  Error -404 When Running cdr realize template

    IBM Champion
    Posted Mon April 04, 2022 08:29 AM

    This one's new to me. IDS 14.10.FC7W1:

    $ cdr realize templ tmplt_webmaint -S gprim__webdata -F webdata@gprim__webdata
    cdr error: Cannot close cursor - cdrcolcur
    SQL code -404 :The cursor or statement is not available.
    
    ISAM 0 :


    I've tried trapping error 404 but nothing gets fired. No errors appear in online log. The messages above are all I get. The above is the "primary" server in a primary-target scheme, so it has to run first.

    Has anyone here encountered this?



    ------------------------------
    TOM GIRSCH
    ------------------------------

    #Informix


  • 2.  RE: Error -404 When Running cdr realize template

    IBM Champion
    Posted Mon April 04, 2022 08:38 AM
    OK, now it's more interesting. There are two server groups in the scheme: gprim__chaos and gprim__webdata. For this particular replset, gprim__webdata is the primary and gprim__chaos is the target. If I run the cdr realize against gprim__webdata, I get the -404. If I run it against gprim__chaos, it works fine. Why in the world?

    ------------------------------
    TOM GIRSCH
    ------------------------------



  • 3.  RE: Error -404 When Running cdr realize template

    IBM Champion
    Posted Mon April 04, 2022 08:41 AM
    Anything when you export MyTrace=1 ?

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 4.  RE: Error -404 When Running cdr realize template

    Posted Mon April 04, 2022 09:19 AM
    MyTrace not gonna help here I'm afraid.
    But what might sched more light on this is SQLI debug:

    $ export SQLIDEBUG=2:/tmp/rea_temp_webdata_sqli
    $ cdr realize templ tmplt_webmaint -S gprim__webdata -F webdata@gprim__webdata
    $ export SQLIDEBUG=2:/tmp/rea_temp_chaos_sqli
    $ cdr realize templ tmplt_webmaint -S gprim__webdata -F webdata@gprim__chaos

    ------------------------------
    Andreas Legner
    ------------------------------



  • 5.  RE: Error -404 When Running cdr realize template

    IBM Champion
    Posted Mon April 04, 2022 10:35 AM
    SQLIDEBUG gives me a giant binary file. Not sure what to do with it.

    Tom Girsch

    Lead System Architect
    Auto Europe Group
    tgirsch@autoeurope.com
    Office #207-842-2139


    " If you think there is something more important than a Client ... think again "





  • 6.  RE: Error -404 When Running cdr realize template

    IBM Champion
    Posted Mon April 04, 2022 12:02 PM

    Throw it at sqliprint ?

     






  • 7.  RE: Error -404 When Running cdr realize template

    IBM Champion
    Posted Mon April 04, 2022 12:28 PM
    I have a ticket open and submitted the sqlidebug with the ticket.

    What's especially "fun" is that both servers -- the one that works and the one that doesn't -- live on the same host, run the same version of IDS and are even running out of the same ${INFORMIXDIR}

    Tom Girsch

    Lead System Architect
    Auto Europe Group
    tgirsch@autoeurope.com
    Office #207-842-2139


    " If you think there is something more important than a Client ... think again "





  • 8.  RE: Error -404 When Running cdr realize template

    Posted Tue April 05, 2022 05:36 AM
    Hello Tom, 
    Can you please post the cdr define template command you executed ?
    Thanks

    ------------------------------
    Ashok Sharma
    ------------------------------



  • 9.  RE: Error -404 When Running cdr realize template

    IBM Champion
    Posted Tue April 05, 2022 08:29 AM
    cdr define templ tmplt_webmaint -C always -M gprim__webdata -S trans -AR -d webdata cartags siteoptions2 supplierlogorules supplierratings wbsubsite xml_promo2

    It's a re-creation of a template that already existed, which I deleted and recreated using the same commands. (Deleted the replicates, deleted the template, created the template, went to realize)

    Tom Girsch

    Lead System Architect
    Auto Europe Group
    tgirsch@autoeurope.com
    Office #207-842-2139


    " If you think there is something more important than a Client ... think again "





  • 10.  RE: Error -404 When Running cdr realize template

    Posted Tue April 05, 2022 12:46 PM
    Thanks, Tom,

    Can you please check if you have any tables like  "cdr_deltabb_%" prior to the creation of the template the second time around?
    This is  peculiar to 12.10.  I have not worked with later versions of Informix.

    If they do , you may want to drop them and redefine your template.

    Thanks
    Ashok

    ------------------------------
    Ashok Sharma
    ------------------------------



  • 11.  RE: Error -404 When Running cdr realize template

    Posted Tue April 05, 2022 12:48 PM
    Apologies, that is a single b.  cdr_deltab_%

    ------------------------------
    Ashok Sharma
    ------------------------------



  • 12.  RE: Error -404 When Running cdr realize template

    IBM Champion
    Posted Tue April 05, 2022 01:01 PM
    I had dropped the entire syscdr database and started "clean," but did resync to a different node upon creation. I'll poke around.

    Tom Girsch

    Lead System Architect
    Auto Europe Group
    tgirsch@autoeurope.com
    Office #207-842-2139


    " If you think there is something more important than a Client ... think again "





  • 13.  RE: Error -404 When Running cdr realize template

    Posted Tue April 05, 2022 04:53 PM
    I meant to say those  tables are created in the database and not syscdr [ in 12.10 ].

    ------------------------------
    Ashok Sharma
    ------------------------------



  • 14.  RE: Error -404 When Running cdr realize template

    IBM Champion
    Posted Tue May 24, 2022 01:57 PM

    L3 support finally figured out the issue and I'm a little embarrassed that I didn't see it. In the environment that fails, IFX_AUTOFREE was set to 1. If I unset it, everything works as expected.

    I've asked whether a bug has been entered for this.



    ------------------------------
    TOM GIRSCH
    ------------------------------



  • 15.  RE: Error -404 When Running cdr realize template

    IBM Champion
    Posted Tue May 24, 2022 09:22 PM
    Ouch! That's definitely works as expected.

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 16.  RE: Error -404 When Running cdr realize template

    Posted Tue May 24, 2022 09:58 PM

    Such problems are hard to solve.
    Generally, I would have tried twice and run strace to see if anything shows up. 

    I wonder if I would have caught it. 

    Thanks for telling us about it. 



    ------------------------------
    Ashok Sharma
    ------------------------------



  • 17.  RE: Error -404 When Running cdr realize template

    IBM Champion
    Posted Wed May 25, 2022 04:46 PM
    What stings is that I had another engine on the same server where it worked fine. I spent a lot of time poring over onconfig differences and whatnot but it never occurred to me to run a diff on env for the two servers.