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
job aborted due to Timeout Expired
Moderators: chulett, rschirm, roy
How long does it run before you get this message?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>