MSSQL Communication link failure

[Former Member]

Hi All,

i have created a job, it has 9 data foundations are linked serialy.job will load 100crores of data from source system to mssql 2008. each data foundation will load 10 crores of data. when i was run the job after some time. i got the following error

if any one knows the solution how to resolve the solution please help me ASAP.

Thanks,

Ramana

[former_member189153]

Hi Ramana,

Error Screen shot show, Job terminated during reading data itself. Time out/ communication failure may be possible due to not enough space for buffering. refer the below document for process optimization.

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_perf_opt_en.pdf

[former_member200473]

Hi Varra,

Please try with using Varchar Data type instead of 'INT' data type.

Regards,

Shiva Sahu