Error when importing from Excel in SAP

[former_member261527]

Hello experts,

My gets error when importing price list using the import form Xl menu :

(-1200) DBMCconnBase::EndTransaction SQLEndTran sqlState 08S01, nativeErr: 0, errText:[Microsoft][SQL Native Client] Communication link failure

This happens only when connected with SAP Client, it never happens when connected in terminal server directly on SAP server.

Server 2003, MSSQL 2005 SP2

SAP 2007 Sp01 PL08 HF01

This has always been working before, it has stopped working when he changed the motherboard 3 weeks ago. Nothing else have changed.

Any idea where to look at?

Thanks!

Chris

[Former Member · Accepted solution]

Hello Chris,

If he changed the motherboard 3 weeks ago, did he still keep the same Windows? If that is true, the problem may affect more applications not only B1.

Reinstall the OS is the right direction to fix the problem.

Thanks,

Gordon

[former_member261527]

hello Gordon,

Thanks for your answer. that would have probaly fix the issue

my techs fixed the issue by doing the 2 following thinks, i don't know if only one of them would have fix it.

1. in the boot.ini file there was a /3G in the end, restricting the memory to 1G for the OS. The tech deleted it.

2. in management studio, the technician changed the memory reserved for sql from 9/12 to 14/16Gb

there was probably not enough RAM available for the import.

since that change it works well.

Thanks again!

Christophe