Timing out when changing period status?

(0) Share

Report

Posted on by RachaelHa

Hi,

Over the past couple of months, when we go to put a period on hold it takes a very long time. Sometimes we let it run for 30 mins plus and it still doesn't complete.

Our partner suggested we do it via excel instead, but when I try to open this page in the excel add in I get the message "the URL used to retrieve data was too long".

Anyone got any ideas what might be causing it or any way we can work around it (either through front end, excel or other)?

Thanks

I have the same question (0)

All responses (4)

Answers (0)

RachaelHa 24 on at

Like (0)

Report

RE: Timing out when changing period status?

Thanks David - really helpful, that's great news

Was this reply helpful? Yes No
Suggested answer

David Bader on at

Like (1)

Report

RE: Timing out when changing period status?

Hi RachaelHa,

Thank you for posting your inquiry to the Communities.

I have seen this type of issue before and it usually related to a missing index and the issue (673245) will be resolved in 10.0.28. In the meantime you can try adding the below index in a Sandbox environment. If that resolves the issue please open a support ticket so the same can be applied to Production.

CREATE NONCLUSTERED INDEX SUBLEDGERVOUCHERGENERALJOURNALENTRY_PERF_IDX_1

ON [dbo].[SUBLEDGERVOUCHERGENERALJOURNALENTRY] ([PARTITION],[SUBLEDGERJOURNALENTRY])

WITH ( ONLINE = ON (WAIT_AT_LOW_PRIORITY (MAX_DURATION = 5 MINUTES, ABORT_AFTER_WAIT = SELF)),

SORT_IN_TEMPDB = ON, FILLFACTOR = 100, DATA_COMPRESSION = PAGE, MAXDOP = 2)

Have a great day!

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 298,911 Super User 2025 Season 2 on at

Like (0)

Report

RE: Timing out when changing period status?

Hi RachaelHa,

If you don't have customizations in this area, I would suggest to check if there is a known issue on LCS issue search. If you can't find it reported before, you can contact Microsoft Support.

You can also do some analysis yourself using e.g. the Trace Parser to check which x++ coding and database calls are consuming the most time.

Was this reply helpful? Yes No
Vishals786 on at

Like (0)

Report

RE: Timing out when changing period status?

Hi RachaelHa ,

You can try to check the customization behind the classes responsible for running Periods.

Then once you get the entity holding the related table data for the periods.

You can go to Entity Execution Parameters and maximise the number of threads for that entity.

You can only do this if you find that class is calling that respective data entity.

After maximizing the thread count you can see a relative performance boost and this might also result in running the periods quickly.

Please check this and let us know if this helps or not.

Was this reply helpful? Yes No