BusinessObjects Board

Extend Named Pipe Timeout in 12.3.1

We are experiencing a named pipe error:

3812	8816	FIL-080133	
9/17/2014 12:05:20 PM	The database client cannot connect to named pipe
<\\.\pipe\159d2cbc-5800-4d15-9dec-2f8f7e99c9ff>.

This happens at exactly 10 minutes of launching the job, and is
presumably caused by a timeout between a parent and child subflow. We are
running a DISTINCT as a separate process because without it we hit the 32bit process memory limit of 2 GB.

The complex flow works successfully when the database queries return
in less than 10 minutes. Our production queries are coming back in about 12
minutes. I tried updating the DSConfig.txt file and setting
DFRegistrationTimeoutInSeconds = 900 (was 300) and restarted the DS
service. But this did not affect the timeout.

Can someone advise if the 10 minute timeout is configurable and where I
would adjust that setting?

Steps for Reconstruction
Create a dataflow with a SQL query that takes longer than 10 minutes in the
database. Set a QUERY transform to do a distinct as a separate process, and
then join that into another SQL query. It appears the first query times out
waiting on the second query’s subflow.


cfachris :us: (BOB member since 2003-09-03)

Hello,

Try to create an ODBC connection at the source side and import the table and run the job. Since, in our Project also we faced same issue and we resolved it by creating the ODBC connection .

Regards,
Prasna


pnr6kor (BOB member since 2014-05-14)