session.Write 10000 records limit | Community
Skip to main content
RaulOcana
RaulOcana
Level 3
August 21, 2018
Solved

session.Write 10000 records limit

  • August 21, 2018
  • 4 replies
  • 3573 views

Hi guys,

We have a Javascript code in a workflow that reads the whole database and updates a field. The problem is that it only updates the first 10.000 records so have to re-run it each time it finshes.

How can we overwrite that limit? By paging or something similar? I'm new to the platform so I don't understand the SDK or the coding limitations.

Thank you!

- Raul

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Adhiyan

Hello Raul,

This is a limitation of the API when you use the querydef function.

The workaround is to use an attribute like noLineCount="1" or lineCount="<max_records>" inside the JS to overcome the limitation .

Else, you the OOB update data activity which does not have any such limitation as Vipul suggested

Regards,
Adhiyan

4 replies

vraghav
Adobe Employee
vraghavAdobe Employee
Adobe Employee
August 22, 2018

Hi Raul,

Any specific reason to perform updates using session.Write JS code and not using the out of box activity?

Regards,
Vipul

RaulOcana
RaulOcanaAuthor
Level 3
August 22, 2018

Hi Vipul,

Yes, we are encrypting a couple of values that we have stored, so we have the whole algorithm there and the update. It is a one time bulk update, after that, it will be updating the records on a weekly basis and there won't be more than 10.000.

- Raul

Adhiyan
Adobe Employee
AdhiyanAdobe EmployeeAccepted solution
Adobe Employee
September 12, 2018

Hello Raul,

This is a limitation of the API when you use the querydef function.

The workaround is to use an attribute like noLineCount="1" or lineCount="<max_records>" inside the JS to overcome the limitation .

Else, you the OOB update data activity which does not have any such limitation as Vipul suggested

Regards,
Adhiyan

RaulOcana
RaulOcanaAuthor
Level 3
September 12, 2018

Hi Adhiyan,

thank you, I'll do that.

- Raúl

Terms & ConditionsAccessibility statement

Loading footer...