Re: Summary: Error on IWA initialization:Assert SE

Hi, a late response ... and even to the origin of a long thread of e-mails ... Meanwhile we have established, that the described problem is due to changed behaviour of the function tellg(). This new behaviour of tellg() appears with the GNU Standard C++ Library (libstdc++) of version 4.6.0 or higher. Unfortunately, the problems caused by this are not only confined to the configuration routines of the Informix Warehouse Accelerator. Also the parsing of queries sent from the Informix Server to the accelerator is affected. This can result in queries not being accelerated. Hence the recommendation is to refrain from using libstdc++ 4.6.0 or newer with the Informix Warehouse Accelerator. There is also an (updated) blog entry (currently it's the newest entry) in "The IWA-Blog" at http://tinyurl.com/the-iwa-blog Look for "Linux systems with libstdc++ 4.6.x". We are working on solving the problem permanently, but at this time we do not expect to have the solution included in the upcoming release of 11.70.FC5 of the Informix Warehouse Accelerator. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management Read about the Informix Warehouse Accelerator: http://tinyurl.com/the-iwa-blog IBM Deutschland Research & Development GmbH Chairman of the Supervisory Board: Martina Koederitz Board of Management: Dirk Wittkopp Corporate Seat: Boeblingen, Germany Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294 ids-bounces@iiug.org wrote on 05/01/2012 08:14:10 PM: > Trying to create a Demo Informix Warehouse Accelerator (IWA) environment. > > Installation was fine but when trying to execute the ./ondwa start command, > > Error occurs when starting DWA_CM_node0 and DWA_CM_node1 > > on QueueHub initialization with error: > > An assertion 'str.tellg() > 0' failed. Additional info: Invalid size > definition '0' encountered for parameter SEND_QUEUE_SIZE > > I've tried to find some help on docs and internet, but without success. > > IWA Version: 11.70.FC4 > No IDS instance present on server. > > Somebody knows about this error? > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Hi, I am in process of evaluating IWA for my organisation and I have installed IWA on Centos while the ISAOS is installed on my PC. I have managed to install and start the IWA and below is what I see when I run status and getpin [root@iwa1 bin]# ./ondwa status ID | Role | Cat-Status | HB-Status | Hostname | System ID -----+-------------+-------------+--------------+------------------+------------ 0 | COORDINATOR | ACTIVE | Healthy | iwa1 | 1 1 | WORKER | ACTIVE | Healthy | iwa1 | 2 [root@iwa1 bin]# ./ondwa getpin 192.78.139.170 21022 6039 When I connect my ISAOS to an IDS instance on 11.70 and then try to add above accelerator, I get an error 'Add Accelerator' has encountered a problem. Function contains an output parameter. Below are the lines in the log file on my PC !ENTRY com.ibm.datatools.aqt 1 0 2012-07-19 12:02:36.080 !MESSAGE Calling ACCEL_SETUP_CONNECTION for accelerator IWA in database tickdb. Security code: 5750, Address: 192.78.139.170, Port: 21022. !ENTRY com.ibm.datatools.aqt.martmodel 1 0 2012-07-19 12:02:36.112 !MESSAGE Thread: 59 <?xml version="1.0" encoding="UTF-8"?> <aqtmart:messageControl xmlns:aqtmart="http://www.ibm.com/xmlns/prod/dwa"; version="1.0"> <language>en_US</language> <trace>components=ALL level=OFF</trace> </aqtmart:messageControl> !ENTRY com.ibm.datatools.aqt.dse 4 0 2012-07-19 12:02:36.121 !MESSAGE Function contains an output parameter. !STACK 0 java.sql.SQLWarning: Function contains an output parameter. at com.informix.jdbc.IfxCallableStatement.<init>(IfxCallableStatement.java:200) at com.informix.jdbc.IfxSqliConnect.i(IfxSqliConnect.java:6545) at com.informix.jdbc.IfxSqliConnect.prepareCall(IfxSqliConnect.java:2483) at com.ibm.datatools.aqt.dbsupport.informix.InformixStoredProcUtilities.callAccelSe tupConnection(Unknown Source) at com.ibm.datatools.aqt.dse.jobs.AddAcceleratorJob.run(Unknown Source) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55) Please help. regards, Nitin

Hi, Have you created an sbspace (sbspace1 in the example below) and have the following entry in your $ONCONFIG? If you have to create and add the entry to $ONCONFIG, you do need to restart the server. SBSPACENAME sbspace1 # Default sbspace name http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.acc.doc/ids_ acc_019.htm The Informix procedures interacting with IWA use CLOB type and need the sbspace. cheers, Keshav.

Thanks Keshav for the reply, but yes, I had created the sbspace when I saw ondwa setup informing me, see below @tickdb2$ onstat -c|grep sbspacefor system statistics SBSPACENAME sbspace SYSSBSPACENAME sbspace CDR_QDATA_SBSPACE sbspace @tickdb2$ onstat -d|grep sbspace11c19c378 10 0x48001 10 1 2048 N SBA informix sbspace Now I have made things more difficult as I thought I had some issues with Studio, so I un-installed it and when I am try to install it back, it is complaining about "profile directory not found" although I am trying to run below from command prompt C:\\\\IWA> install -Dprofile="c:\\\\iwa\\\\profile.zip" where profile.zip is the media I downloaded from IBM website. regards, Nitin

Pls ignore the 2nd part about the installation problem of ISAOS. regards, Nitin

When I tried to add Accelerator, I noticed below in message log of IDS 16:43:17 Loading Module <$INFORMIXDIR/lib/libdwa.udr> 16:43:17 The C Language Module </opt/IDS11.70.FC4/lib/libdwa.udr> loaded 16:43:17 INFO (autoregvp 3) (Execution of [ autoregvp ] dymamically creating VPCLASS dwavp)16:43:17 Dynamically added 1 dwavp VP But it still failed to add Accelerator on Studio, giving the same error 'Add Accelerator' has encountered a problem. Function contains an output parameter. Please help. regards, Nitin

Nitin, Thanks for your interest in the Warehouse Accelerator. Can you send us the result of this command? ondwa status I guess you have followed the steps in the manual. http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.acc= .doc/ids_acc_032.htm or you can also test our command line interface: http://planetids.com/content/informix-warehouse-accelerator-example-jav= a-cli-1 Kind regards Sandor IBM Deutschland Research & Development GmbH / Vorsitzende des Aufsichtsrats: Martina Koederitz Gesch=E4ftsf=FChrung: Dirk Wittkopp Sitz der Gesellschaft: B=F6blingen = / Registergericht: Amtsgericht Stuttgart, HRB 243294 = "NITIN MATHUR" = <nitin_maths@redi = ffmail.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Re: Summary: Error on IWA = 07/19/2012 10:46 initialization:Assert SE [27728= ] PM = = = Please respond to = ids@iiug.org = = = When I tried to add Accelerator, I noticed below in message log of IDS 16:43:17 Loading Module <$INFORMIXDIR/lib/libdwa.udr> 16:43:17 The C Language Module </opt/IDS11.70.FC4/lib/libdwa.udr> loade= d 16:43:17 INFO (autoregvp 3) (Execution of [ autoregvp ] dymamically creating VPCLASS dwavp)16:43:17 Dynamically added 1 dwavp VP But it still failed to add Accelerator on Studio, giving the same error= 'Add Accelerator' has encountered a problem. Function contains an outpu= t parameter. Please help. regards, Nitin ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Hi Nitin, On Thursday 19 July 2012 22:46:37 you wrote: > When I tried to add Accelerator, I noticed below in message log of IDS > > 16:43:17 Loading Module <$INFORMIXDIR/lib/libdwa.udr> > 16:43:17 The C Language Module </opt/IDS11.70.FC4/lib/libdwa.udr> loaded > 16:43:17 INFO (autoregvp 3) (Execution of [ autoregvp ] dymamically > creating VPCLASS dwavp) > 16:43:17 Dynamically added 1 dwavp VP > > But it still failed to add Accelerator on Studio, giving the same error > 'Add Accelerator' has encountered a problem. Function contains an output > parameter. Please let us know versions of IDS and IWA: onstat -versionondwa -version Did you installed IWA on the same or different machine than IDS? Whats the content of IWA config file $INFORMIXDIR/dwa/etc/dwainst.conf ? Thanks, Andreas > > Please help. > > regards, > > Nitin > > > *************************************************************************** > **** Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks for your responses. I have installed IDS and IWA on different servers. I identified the problem. IDS 11.70 which I was trying to connect was installed on Solaris on x86_64, which I guess is not supported. When I started to use a new instance on Linux Centos, it went ahead but gave another error "A coordinator node with the network address "192.78.139.170":21022" could not be reached. (AQT10119I)" Below are the outputs for getpin and status [root@iwa1 bin]# ./ondwa getpin 192.78.139.170 21022 9254 [root@iwa1 bin]# ./ondwa status ID | Role | Cat-Status | HB-Status | Hostname | System ID -----+-------------+-------------+--------------+------------------+------------ 0 | COORDINATOR | ACTIVE | Healthy | iwa1 | 1 1 | WORKER | ACTIVE | Healthy | iwa1 | 2 Cluster is in state : Fully Operational Expected node count : 1 coordinator and 1 worker nodes Please help. regards, Nitin

It worked. I had to enable port 22 and reboot the server. Thanks for your responses. regards, Nitin