Connection to SQL Server lost when adding Contacts to Segment Lines

(0) Share

Report

Posted on by TK8782

Hi folks,

we are running Business Central 19.5 in an On-Prem Environment and want to add Contacts to Segment Lines with the default Report ID 5198.
When executing the Report with a filter value which results in about more than 300.000 contacts that should be added to the segment lines the system comes up with a failure and the actions is rolled back.
The run-time of the report is about more than 24 hours, but we already customized the max runtime of an report in the administration to "MaxValue". In Windows Event Log there is an error coming up which says that the connection to the sql server was lost. After this error the roll-back is performed and the segment lines are empty.

Does anyone have an idea what the problem could be?

Another error which I found was that there is a problem with an arithemtic operation "The arithmetic operation has caused an overflow"....!

Thanks a lot for any hint :-)

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Marco Mels on at

Like (1)

Report

Hello,

The segment probably cannot handle 300.000 contacts. Better to split these in multiple ones.

Thank you.

Was this reply helpful? Yes No