IDS Forum

Re: IWA: Error loading datamart

Posted By: Martin Fuerderer
Date: Tuesday, 24 July 2012, at 1:45 p.m.

In Response To: Re: IWA: Error loading datamart (VICENTE SALVADOR)

Hi,

> ...<text>An internal processing error occurred
> in the stored procedure. Diagnostic information:
> An assertion 'false' failed. Additional info:
> timeout while reading from
> /tmp/iwapipe.d6f14231-40fa-4bf7-8128-3ae05e5377ce
> </text>...

This message points to a problem on the side of
generating the load data, i.e. the IDS side rather
than the side of the accelerator.

The load data is extracted from IDS via external tables
that use a pipe, from where the data is read and then
sent to the accelerator. The message suggests, that
for some reason there's no (more) data arriving at the
pipe. There's a good possibility, that in /tmp there's
some file of a name beginning with "iwa" containing
more information as to what went wrong ... Try to
remove all /tmp/iwa* files, then start another attempt
at loading the data mart, then check again in /tmp
to see what files of a name starting with "iwa" are
there.

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 07/24/2012 04:46:41 PM:

> From: "VICENTE SALVADOR" <vsalvador@deister.es>
> To: ids@iiug.org,
> Date: 07/24/2012 04:47 PM
> Subject: Re: IWA: Error loading datamart [27795]
> Sent by: ids-bounces@iiug.org
>
> This is the error returnet:
>
> loadMart IWA1 rips_ac_consulta NONE
>
>
--------------------------------------------------------------------------------

> Warning: AQT10205I DETAILS IN MESSAGE OUTPUT PARAMETER 4 / SQLSTATE:
01H08
>
>
--------------------------------------------------------------------------------

> result message:
> <?xml version="1.0" encoding="UTF-8" ?> <dwa:messageOutput
> xmlns:dwa="http://www.ibm.com/xmlns/prod/dwa" version="1.0"> <message
> severity="severe" reason-code="AQT10205I"><text>An internal processing
error
> occurred in the stored procedure. Diagnostic information: An assertion
'false'
> failed. Additional info: timeout while reading from
>
/tmp/iwapipe.d6f14231-40fa-4bf7-8128-3ae05e5377ce</text></message></dwa:messageOutput>

>
> And this is the /var/log/messages
>
> Jul 24 18:40:53 iwa1 DWA[4389]: [TRACER][ERROR]: [2012-07-24
18:40:53.696339]
> [ERROR] [Task: 0] [Thread: 1332504896] [Component: DRDA] [EXCEPTION]
>
/vobs/tristarp/iwa/dwaroot/accelerator/sources/controller/base/DBMSControllerBase.cpp:392

> ForceDRDAConnectionCloseException: A irreparable error occured. The
connection
> to the peer needs to be closed. The reason to do this is: Base exception

> caught in Controller Framework. Close the network connection. Thrown at
>
/vobs/tristarp/iwa/dwaroot/accelerator/sources/controller/base/DBMSControllerBase.cpp:392

> Jul 24 18:40:53 iwa1 DWA[4389]: [TRACER][ERROR]: [2012-07-24
18:40:53.696433]
> [ERROR] [Task: 0] [Thread: 1332504896] [Component: CONTROLLER] [MESSAGE]

>
/vobs/tristarp/iwa/dwaroot/accelerator/sources/controller/base/DBMSControllerBase.cpp:443

> DRDAForceConnectionCloseException rethrown to notify the DRDA daemon.
> Jul 24 18:41:23 iwa1 DWA[4389]: [TRACER][ERROR]: [2012-07-24
18:41:23.998527]
> [ERROR] [Task: 101330991615836180] [Thread: 1363974464] [Component:
DRDA]
> [EXCEPTION]
> /vobs/tristarp/iwa/dwaroot/accelerator/sources/drda/DRDAElement.cpp:372
> DRDATCPIPException: DRDATCPIPException: A network connection is gone
where it
> is not expected to be on message type 0x0000: While trying to receive
message
> data Thrown at
> /vobs/tristarp/iwa/dwaroot/accelerator/sources/drda/DRDAElement.cpp:372
> Jul 24 18:41:24 iwa1 DWA[4389]: [TRACER][ERROR]: [2012-07-24
18:41:24.025244]
> [ERROR] [Task: 101330991615836180] [Thread: 1363974464] [Component:
LOAD]
> [MESSAGE]
>
/vobs/tristarp/iwa/dwaroot/accelerator/sources/controller/load_mart/LoadMessageConverter.cpp:327

> Exception in job 0: DRDATCPIPException: A network connection is gone
where it
> is not expected to be on message type 0x0000: While trying to receive
message
> data
> Jul 24 18:41:24 iwa1 DWA[4389]: [TRACER][ERROR]: [2012-07-24
18:41:24.025328]
> [ERROR] [Task: 101330991615836180] [Thread: 1112217920] [Component:
SERVICES]
> [MESSAGE]
>
/vobs/tristarp/iwa/dwaroot/accelerator/sources/services/thread/ProducerConsumerQueue.hpp:270

> Queue was aborted with exception DRDATCPIPException: A network
connection is
> gone where it is not expected to be on message type 0x0000: While trying
to
> receive message data
> Jul 24 18:41:24 iwa1 DWA[4389]: [TRACER][ERROR]: [2012-07-24
18:41:24.036477]
> [ERROR] [Task: 101330991615836180] [Thread: 1112217920] [Component:
LOAD]
> [MESSAGE]
>
/vobs/tristarp/iwa/dwaroot/accelerator/sources/controller/load_mart/CoordinatorLoadController.cpp:115

> Load for mart rips_ac_consulta, task 101330991615836180 (type=2;
> subtask=false) aborting with error in task status receiving
> "informix"."rips_ac_consulta"(1 of 1)
> Jul 24 18:41:24 iwa1 DWA[4389]: [TRACER][ERROR]: [2012-07-24
18:41:24.100583]
> [ERROR] [Task: 101330991615836180] [Thread: 1112217920] [Component:
> CONTROLLER] [EXCEPTION]
>
/vobs/tristarp/iwa/dwaroot/accelerator/sources/controller/base/ControllerBase.cpp:1796

> TriggerTaskAbortionException: The abortion of task 101330991615836180
was
> triggered by the coordinator controller. Thrown at
>
/vobs/tristarp/iwa/dwaroot/accelerator/sources/controller/base/ControllerBase.cpp:1796

> Jul 24 18:41:24 iwa1 DWA[4416]: [TRACER][ERROR]: [2012-07-24
18:41:24.100810]
> [ERROR] [Task: 101330991615836180] [Thread: 1186740544] [Component:
> CONTROLLER] [MESSAGE]
>
/vobs/tristarp/iwa/dwaroot/accelerator/sources/controller/base/ControllerBase.cpp:1850

> Received remote exception from node 0 on controller for orchestrating
task
> 101330991615836180 (type=2; subtask=true) from task 101330991615836180
> (type=2; subtask=false)
> Jul 24 18:41:24 iwa1 DWA[4413]: [TRACER][ERROR]: [2012-07-24
18:41:24.100823]
> [ERROR] [Task: 101330991615836180] [Thread: 1182566720] [Component:
> CONTROLLER] [MESSAGE]
>
/vobs/tristarp/iwa/dwaroot/accelerator/sources/controller/base/ControllerBase.cpp:1850

> Received remote exception from node 0 on controller for orchestrating
task
> 101330991615836180 (type=2; subtask=true) from task 101330991615836180
> (type=2; subtask=false)
> Jul 24 18:41:24 iwa1 DWA[4416]: [TRACER][ERROR]: [2012-07-24
18:41:24.100885]
> [ERROR] [Task: 101330991615836180] [Thread: 1323108672] [Component:
> CONTROLLER] [MESSAGE]
>
/vobs/tristarp/iwa/dwaroot/accelerator/sources/controller/base/ControllerBase.cpp:2079

> Task LOAD MART (101330991615836180 (type=2; subtask=true)) is failing
because
> an exception has been received
>
>
>
*******************************************************************************

> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• IWA: Error loading datamart
  VICENTE SALVADOR -- Monday, 23 July 2012, at 1:56 p.m.
  • Re: IWA: Error loading datamart
    Carlton Doe -- Monday, 23 July 2012, at 2:36 p.m.
  • Re: IWA: Error loading datamart
    Martin Fuerderer -- Tuesday, 24 July 2012, at 5:38 a.m.
    • Re: IWA: Error loading datamart
      VICENTE SALVADOR -- Tuesday, 24 July 2012, at 10:46 a.m.
      • Re: IWA: Error loading datamart
        Martin Fuerderer -- Tuesday, 24 July 2012, at 1:45 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.