Error -404 When Running cdr realize template

This one's new to me. IDS 14.10.FC7W1: $ cdr realize templ tmplt_webmaint -S gprim__webdata -F webdata@gprim__webdatacdr 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

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 ------------------------------

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

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 ------------------------------

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 "

Throw it at sqliprint ?

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 "

Hello Tom, Can you please post the cdr define template command you executed ? Thanks ------------------------------ Ashok Sharma ------------------------------

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 "

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 ------------------------------

Apologies, that is a single b. cdr_deltab_% ------------------------------ Ashok Sharma ------------------------------

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 "

I meant to say those tables are created in the database and not syscdr [ in 12.10 ]. ------------------------------ Ashok Sharma ------------------------------

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 ------------------------------

Ouch! That's definitely works as expected. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------

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 ------------------------------

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.