1000 row limit while publishing records from Excel Plug - in

Nair, Siddharth S 1 Reputation point
2022-09-29T08:25:29.477+00:00

Hi Everyone,

We got an issue while inserting records from Excel Plug-in into our Production server.

In production server, when users are trying to publish more than 1000 records at once through excel plug-in they are facing the below issue

Image

245994-image.png

Same Error Message in Script format :

===================================

A database error has occurred. Contact your system administrator.

------------------------------

Number = 245

OperationId = 9ef4f5d5-6***f69857060

------------------------------

Program Location:

at Microsoft.MasterDataServices.AsyncEssentials.AsyncResultBase.EndInvoke()

at Microsoft.MasterDataServices.ExcelAddInCore.AsyncProviderBase`1.EndOperation(IAsyncResult ar)

at Microsoft.MasterDataServices.ExcelAddInCore.DataView.<>c__DisplayClass41.<PublishAll>b__3f(IAsyncResult ar)

at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization)

NOTE - Here excel plug-in is using SQL server environment

Can anyone please advice what can be done to resolve this issue?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,558 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,653 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Oskar Shon 866 Reputation points MVP
    2022-11-09T11:24:44.157+00:00

    Palpably you're using loop with insert command in recordset. That's wrong for multiple rows.
    You should builds stored procedure
    There you can find tutorial for VBA: watch
    or for vb.net: watch

    Regards

    0 comments No comments