[Microsoft][ODBC SQL Server Driver]Timeout expired.

system · March 1, 2011, 1:54pm

Hi,

We are using BODS 12.2.2.0 installed in windows XP SP3 and the source and target database is MS SQL Server 2008 installed in window server 2003 R2.

We are getting the below error when we are executing the jobs and it is not frequent.

[Microsoft][ODBC SQL Server Driver]Timeout expired>.Notify Customer Support.

Sometimes the job executes fine and sometimes we get this error. Can any one help me ?

Thanks
Chandrashekar

althatichandrashekar (BOB member since 2009-03-05)

system · March 1, 2011, 6:16pm

Your SQL Server database, most likely the one hosting the repository, has a timeout specified. If a connection is not active for xxxx minutes, SQL Server will drop the connection.
Imagine you have a dataflow which takes 10 hours, so for 10 hours it will read and load but not interact with the repository. With this setting the SQL Server drops this allegedly inactive connection.

Werner Daehn (BOB member since 2004-12-17)

system · May 30, 2011, 9:42am

Hi Werner,

I have the same error, my error log:

(12.2) 05-30-11 03:13:36 (E) (6812:6496) CON-120302: Initialization
ODBC call for data source <SERVERNAME\sqlexpressbodi> failed: <[Microsoft][ODBC SQL Server Driver]Timeout
expired>. Notify Customer Support.
(12.2) 05-30-11 03:13:36 (E) (2136:2352) RUN-050406: |Session 400_JO_COPY_T_TABELLEN_DAILY|Work flow WF_COPY_T_TABELLEN_DAILY|Data flow DF_COPY_T003T
Data flow <DF_COPY_T003T> received a bad system message. Message text from the child process is < >. The process executing data
flow <DF_COPY_T003T> has died abnormally. For NT, check errorlog.txt. For HPUX, check stack_trace.txt. Also, notify Technical
Support.
(12.2) 05-30-11 03:13:38 (E) (6740:3188) CON-120302: Initialization
ODBC call for data source <SERVERNAME\sqlexpressbodi> failed: <[Microsoft][ODBC SQL Server Driver]Timeout
expired>. Notify Customer Support.
(12.2) 05-30-11 03:13:38 (E) (2136:7304) RUN-050406: |Session 400_JO_COPY_T_TABELLEN_DAILY|Work flow WF_COPY_T_TABELLEN_DAILY|Data flow DF_COPY_T016t
Data flow <DF_COPY_T016t> received a bad system message. Message text from the child process is < >. The process executing data
flow <DF_COPY_T016t> has died abnormally. For NT, check errorlog.txt. For HPUX, check stack_trace.txt. Also, notify Technical
Support.
(12.2) 05-30-11 03:13:38 (E) (2136:7304) RUN-050409: |Session 400_JO_COPY_T_TABELLEN_DAILY|Work flow WF_COPY_T_TABELLEN_DAILY
The job process could not communicate with the data flow <DF_COPY_T016t> process. For details, see previously logged error
<50406>.
(12.2) 05-30-11 03:13:40 (2136:2352) RUN-050409: |Session 400_JO_COPY_T_TABELLEN_DAILY|Work flow WF_COPY_T_TABELLEN_DAILY
(12.2) 05-30-11 03:16:45 (E) (3244:1604) CON-120302: |Data flow DF_COPY_TVFKT
ODBC call for data source <SERVERNAME\sqlexpressbodi> failed: <[Microsoft][ODBC SQL Server Driver]Timeout
expired>. Notify Customer Support.
(12.2) 05-30-11 03:17:21 (E) (7104:7620) CON-120302: Initialization
ODBC call for data source <SERVERNAME\sqlexpressbodi> failed: <[Microsoft][ODBC SQL Server Driver]Timeout
expired>. Notify Customer Support.
(12.2) 05-30-11 03:17:22 (2136:7516) RUN-050406: |Session 400_JO_COPY_T_TABELLEN_DAILY|Work flow WF_COPY_T_TABELLEN_DAILY|Data flow DF_COPY_TVTW
(12.2) 05-30-11 03:17:22 (2136:7516) RUN-050409: |Session 400_JO_COPY_T_TABELLEN_DAILY|Work flow WF_COPY_T_TABELLEN_DAILY
(12.2) 05-30-11 03:17:24 (E) (4612:5404) CON-120302: Initialization
ODBC call for data source <SERVERNAME\sqlexpressbodi> failed: <[Microsoft][ODBC SQL Server Driver]Timeout
expired>. Notify Customer Support.
(12.2) 05-30-11 03:17:24 (2136:6392) RUN-050406: |Session 400_JO_COPY_T_TABELLEN_DAILY|Work flow WF_COPY_T_TABELLEN_DAILY|Data flow DF_COPY_TVBVK
(12.2) 05-30-11 03:17:24 (2136:6392) RUN-050409: |Session 400_JO_COPY_T_TABELLEN_DAILY|Work flow WF_COPY_T_TABELLEN_DAILY
(12.2) 05-30-11 03:18:35 (E) (2136:2208) RUN-050406: |Session 400_JO_COPY_T_TABELLEN_DAILY|Work flow WF_COPY_T_TABELLEN_DAILY|Data flow DF_COPY_T016t
Data flow <DF_COPY_T016t> received a bad system message. Message text from the child process is < >. The process executing data
flow <DF_COPY_T016t> has died abnormally. For NT, check errorlog.txt. For HPUX, check stack_trace.txt. Also, notify Technical
Support.

I set the timeout last friday to 0, but nothing happend.

Any idea ?

Holger

h.blum (BOB member since 2008-06-16)

system · May 30, 2011, 5:22pm

What timeout value? The source, the target or - most important - the repository database?

(I hope it’s that, otherwise I am running out of ideas)

Werner Daehn (BOB member since 2004-12-17)

system · May 31, 2011, 5:57am

“the repository database”…

Other DB are Oracle, SAP and local.

Holger

h.blum (BOB member since 2008-06-16)

system · August 16, 2011, 5:35am

so do you have the solution?? I also encountered this timeout error…

Sphenix (BOB member since 2011-04-15)