TimeSeries on 64 linux
I have done a fresh install of Informix 11.50.FC6 on Redhat Enterprise Linux 5 (x64) I then tried to register the TimeSeries datablade with a database and get this error: blademgr s10vm1z>list ts_test There are no modules registered in database ts_test. s10vm1z>show modules 9 DataBlade modules installed on server s10vm1z: mqblade.2.0 ifxrltree.2.00 bts.2.00 wfs.1.00.FC1 binaryudt.1.0 ifxbuiltins.1.1 LLD.1.20.FC2 TimeSeries.4.01.UC7 Node.2.0 c A 'c' indicates DataBlade module has client files. If a module does not show up, check the prepare log. s10vm1z>register TimeSeries.4.01.UC7 ts_test Register module TimeSeries.4.01.UC7 into database ts_test? [Y/n]Y Registering DataBlade module... (may take a while). blademgr: ERROR: DataBlade TimeSeries.4.01.UC7 could not be registered in database ts_test. Use 'show last log' for details of failures in module's scripts. s10vm1z>s10vm1z>show last log blade: TimeSeries.4.01.UC7 err expct: unexpected SQL stmt: create trigger CalendarIns| insert on CalendarTable| referencing new as calendar| for each row| (execute procedure CalNameCheck( calendar.c_name)); SQL state: XIX000:-9793 : User Defined Routine (calnamecheck) module load failed. blade: TimeSeries.4.01.UC7 err expct: unexpected SQL stmt: EXCEPTION SQL state: Registration failed for DataBlade module "TimeSeries.4.01.UC7". Anyone run into this before? Is it possible to run the timeseries datablade from within 64bit informix? ------------------ James Brunskill Computer Engineer - Manufacturing Execution Systems Automation & Process Control Group NZ Technical Fonterra Fonterra Extn: 77808 Ext Line: +64 7 849 2411 x 77808 email: james.brunskill@fonterra.com <mailto:jarrod.teale@fonterra.com> DISCLAIMER: This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email. You may not use, disclose or copy this email or its attachments in any way. Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group. http://www.fonterra.com/
Yes, but you have to get the 64bit version, you have the .UC or 32bit release. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Mar 4, 2010 at 10:29 PM, Jarrod Teale <Jarrod.Teale@fonterra.com>wrote: > I have done a fresh install of Informix 11.50.FC6 on Redhat Enterprise > Linux 5 (x64) > > I then tried to register the TimeSeries datablade with a database and > get this error: > > blademgr > > s10vm1z>list ts_test > > There are no modules registered in database ts_test. > > s10vm1z>show modules > > 9 DataBlade modules installed on server s10vm1z: > > mqblade.2.0 ifxrltree.2.00 > > bts.2.00 wfs.1.00.FC1 > > binaryudt.1.0 ifxbuiltins.1.1 > > LLD.1.20.FC2 TimeSeries.4.01.UC7 > > Node.2.0 c > > A 'c' indicates DataBlade module has client files. > > If a module does not show up, check the prepare log. > > s10vm1z>register TimeSeries.4.01.UC7 ts_test > > Register module TimeSeries.4.01.UC7 into database ts_test? [Y/n]Y > > Registering DataBlade module... (may take a while). > > blademgr: ERROR: DataBlade TimeSeries.4.01.UC7 could not be registered > in database ts_test. > > Use 'show last log' for details of failures in module's scripts. > > s10vm1z>s10vm1z>show last log > > blade: TimeSeries.4.01.UC7 > > err expct: unexpected > > SQL stmt: create trigger CalendarIns| insert on CalendarTable| > referencing new as calendar| for each row| (execute procedure > CalNameCheck( calendar.c_name)); > > SQL state: XIX000:-9793 : User Defined Routine (calnamecheck) module > load failed. > > blade: TimeSeries.4.01.UC7 > > err expct: unexpected > > SQL stmt: EXCEPTION > > SQL state: Registration failed for DataBlade module > "TimeSeries.4.01.UC7". > > Anyone run into this before? > > Is it possible to run the timeseries datablade from within 64bit > informix? > > ------------------ > > James Brunskill > > Computer Engineer - Manufacturing Execution Systems > > Automation & Process Control Group > > NZ Technical > > Fonterra > > Fonterra Extn: 77808 > > Ext Line: +64 7 849 2411 x 77808 > > email: james.brunskill@fonterra.com > <mailto:jarrod.teale@fonterra.com> > > DISCLAIMER: > This email contains confidential information and may be legally privileged. > If > you are not the intended recipient or have received this email in error, > please notify the sender immediately and destroy this email. > You may not use, disclose or copy this email or its attachments in any way. > Any opinions expressed in this email are those of the author and are not > necessarily those of the Fonterra Co-operative Group. > http://www.fonterra.com/ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517447a42eb2e270481059dfc