DSXchange

Hi all,

I load data from source which contains 60 lakhs of records.when i run that job getting error message as"ACCONTS_FACT:[DataDirect][ODBC SQL Server Driver][libssclient21]Timeout Expired".pls help me out.


Thanks
srini

How long does it run before you get this message?

This job running 2 hr 20 mins afterthat job aborted due to "Timeout Expired" warning message

Have any rows gone down the ODBC link in that time? If not, it is an inactivity timer and perhaps you could make your job write to a file and then write a second job to load that file to the table.

ArndW wrote:Have any rows gone down the ODBC link in that time? If not, it is an inactivity timer and perhaps you could make your job write to a file and then write a second job to load that file to the table. ...

yes, my source is DRS stage which contains 60 lacks of records...

How many rows get processed in DataStage before you get a timeout? I still think that you are doing a big SELECT that doesn't return anything and thus times out. The number of rows in the table isn't the factor here, but the time it takes to deliver might be.

Ask if your database has any kind of 'inactivity timeout' settings, which can be triggered if no rows flow down a link for a period of time.