ISFIRSTOCCURENCE() issue in model when more users are added.

PulkitChawla
PulkitChawla
in Modeling

Hi Everyone, I added 1 user into my system and as soon as I run one process, it is failing to say that "Too many cells for ISFIRSTOCCURENCE calculation: actual =50000094 maximum=50000000".

But as I remove 1 user from the users tab the process starts running fine again.

I am a little bit confused about why this kind of failure is happening in my process.

Below is the screenshot of the issue

image.png

If someone knows the root cause of this problem then please let me know.

Best Answer

Answers

  • Prajjwal88
    Prajjwal88

    Hi @rob_marshall ,

    I wanted to know the best way to handle this error. In my case, I even tried removing the ISFIRSTOCCURRENCE() function from the line item and reimported it, expecting a duplicacy error, but I’m still getting the same limit error for ISFIRSTOCCURRENCE.

    Does this have nothing to do with the source and target module? Ideally, there are only 350 records that need to be added after ISFIRSTOCCURRENCE. How could I cater to this issue without deleting records from the source module list?

  • rob_marshall
    rob_marshall

    @Prajjwal88

    It has everything to do with the module the first occurrence is defined. If the cell limit is above the threshold, you will have issues.

Categories