Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Error -404 When Running cdr realize template

  • 1.  Error -404 When Running cdr realize template

    Posted 04/04/22 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

    Posted 04/04/22 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

    Posted 04/04/22 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 04/04/22 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
    ------------------------------

    Original Message


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

    Posted 04/04/22 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 "



    Original Message


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

    Posted 04/04/22 12:02 PM

    Throw it at sqliprint ?

     




    Original Message


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

    Posted 04/04/22 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 "



    Original Message


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

    Posted 04/05/22 05:36 AM
    Hello Tom, 
    Can you please post the cdr define template command you executed ?
    Thanks

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

    Original Message


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

    Posted 04/05/22 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 "



    Original Message


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

    Posted 04/05/22 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
    ------------------------------

    Original Message


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

    Posted 04/05/22 12:48 PM
    Apologies, that is a single b.  cdr_deltab_%

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

    Original Message


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

    Posted 04/05/22 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 "



    Original Message


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

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

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

    Original Message


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

    Posted 05/24/22 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

    Posted 05/24/22 09:22 PM
    Ouch! That's definitely works as expected.

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

    Original Message


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

    Posted 05/24/22 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
    ------------------------------

    Original Message


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

    Posted 05/25/22 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.



    Original Message


Related Content