Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Error when upload excel

(0) ShareShare
ReportReport
Posted on by 34

Hi Guys,

Do you why I'm getting this error when trying to upload an excel ?

"The value of Seek/OffsetFromEnd parameter is outside of the permitted range. The current value is: -18. The permitted range is: from -6 to 2,147,483,641."

I'm getting the same error for every excel that I'm trying to upload.

The callstack is:

The value of Seek/OffsetFromEnd parameter is outside of the permitted range. The current value is: -18. The permitted range is: from -6 to 2,147,483,641.

Internal session ID:
4d22ebf4-293e-49a9-8c61-bcdc8eed8247

Application Insights session ID:
48500fee-de9f-4d7b-97bb-725f0ca6f9be

Client activity id:
352c069e-cedc-4f14-9a03-e44cf353e56e

Time stamp on error:
2023-01-18T16:32:06.7446221Z

AL call stack:
"Excel Buffer"(Table 370).GetSheetsNameListFromStream line 6 - Base Application by Microsoft
"SUIT Import Events"(CodeUnit 50021).SelectSheetsNameStream line 5 - EN10 - Integration ShipIT-ConnectIT by SucceedIT
"SUIT Import Events"(CodeUnit 50021).OnAfterImportProcess line 13 - EN10 - Integration ShipIT-ConnectIT by SucceedIT
"IDYC Import Events"(CodeUnit 11148638).OnAfterImport(Event) line 2 - ConnectIT 365 by IDYN B.V.
"IDYC Import Mgt."(CodeUnit 11148601).Import line 114 - ConnectIT 365 by IDYN B.V.
"IDYC Import Mgt."(CodeUnit 11148601).OnRun(Trigger) line 2 - ConnectIT 365 by IDYN B.V.
"IDYC Import Definition Header"(Table 11148599).Import line 13 - ConnectIT 365 by IDYN B.V.
"IDYC Import Definition Card"(Page 11148601)."Import - OnAction"(Trigger) line 24 - ConnectIT 365 by IDYN B.V.

I debugged it and when trying to Open XlWrkBkReader then is throwing the error (XlWrkBkReader := XlWrkBkReader.Open(FileStream);).

Do you know what could be the cause ?

  • Manthan Thesiya Profile Picture
    59 on at
    RE: Error when upload excel

    Hello Daniel,

    If this customization done by you than check the code which is written for Import function.

    also similar case i found of old version issue check might it help you any.

    "The value of the COPYSTR parameter 2 is outside of the permitted range" error message when you run the Reconciliation function in the Dutch version of Microsoft Dynamics NAV 2009 - Microsoft Support

    If possible than share code for Import function.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/globalsearch/?q=WHS-32578454+++" - Nested quantifier +.