Export to excel Error

(0) Share

Report

Posted on by Anthony90288

Hello,

I have a class where I am exporting data to excel after some dialog options are chosen by the user. However, I keep on getting the error "An internal error has occurred. Please contact your system administrator" once it timeouts.

I am using at the end the below code snippet once the cells are filled

package.Save();
file::SendFileToUser(memoryStream, strFmt('Allowance %1', payPeriodFormat  '.xlsx'));

I have the same question (0)

All responses (4)

Answers (0)

Komi Siabi 13,107 Most Valuable Professional on at

Like (0)

Report

Hello ,

Are you using SysOperationExecutionMode in your code? If yes which mode are you using ?

Please, did you try debugging your entire code to see where the operation gets hooked?

The snippet shared doesn't really give us much insight.

Was this reply helpful? Yes No
Anthony90288 87 on at

Like (0)

Report
Hi Komi,

I have not used SysOperationExecutionMode in my code. It already works perfectly fine on the development environment so debugging doesnt give me any additional insight on why it behaves as such on the production instance. I am only facing this issue on the production environment.

Would the below fix the issue?

package.Save(); SysOperationExecutionMode executionMode = SysOperationExecutionMode::Synchronous; file::SendFileToUser(memoryStream, strFmt('Allowance %1', payPeriodFormat '.xlsx'));

Was this reply helpful? Yes No
Komi Siabi 13,107 Most Valuable Professional on at

Like (0)

Report

Hi Anthony,

It will be nice to tell us if you are extending a base class or you are using a custom one. If you are using SysOperationServiceBase, then you can make use of SysOperationExecutionMode to handle the time out.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Anthonymgy,

Looks like you are getting a timeout error. You may handle it in the code.

Also, could you try running the report with parameters which gives less number of records to export?

This may give you an idea about the error.

Thanks

Was this reply helpful? Yes No

Join the conversation

Community site session details

Export to excel Error

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Export to excel Error

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates