Hi Hossam,
There are a few different things that can cause this error. You'd need to check the Event Viewer at the MR server. MR will log errors under Applications and Services Logs | Microsoft | Dynamics | MR-Logger | Operational.
One common cause for this is if there are segments that are outside of your account structure. What we usually find is an account that is missing a segment, or a segment is in the wrong position. For example, if I have a three-segment account, there may be one that has a blank second segment. Or we've seen accounts that were imported and the third segment slips into the fourth segment position, even though that segment is not being used.
To look for blank segments, you can run the statements below. You may need to adjust them, depending on how many segments you have. If you only had three segments, then you only need to run the first three from each set.
select * from GL00100 where ACTNUMBR_1 = ''
select * from GL00100 where ACTNUMBR_2 = ''
select * from GL00100 where ACTNUMBR_3 = ''
select * from GL00100 where ACTNUMBR_4 = ''
select * from GL00100 where ACTNUMBR_5 = ''
select * from GL00105 where ACTNUMBR_1 = ''
select * from GL00105 where ACTNUMBR_2 = ''
select * from GL00105 where ACTNUMBR_3 = ''
select * from GL00105 where ACTNUMBR_4 = ''
select * from GL00105 where ACTNUMBR_5 = ''
You can also run this statement to look for invalid accounts. You'll need to scroll through the results and look for anything that doesn't appear correct. For example, if my account structure was 3-4-2 and ACTNUMBR_2 had a value that was 5 characters, that would cause the error.
