email360 / ssjs-lib

An open-source library that takes the repetitive and complex tasks and simplifies them, enabling you to get the most out of Salesforce Marketing Cloud.
http://www.email360.io
Other
50 stars 14 forks source link

Update setup.ssjs #11

Closed jpaynesalesforce closed 1 year ago

jpaynesalesforce commented 1 year ago

@shdinx I was trying to reach you to discuss this change first, but it is necessary to just make the change and propose it.

Long story, but more or less, using a text field of length 4000 as part of a Primary Key violates PK maximum lengths allowed. There are more issues as well, which I can explain if you wish to discuss it further. Reach out to me: jpayne@salesforce.com

More or less this automatic declaration of the long text field as part of a PK is causing issues and so going forward anyone using this cannot have those fields as part of PK. For cleanup, I need to now go through and drop the PKs on all the Data Extensions created from this script and then rebuild them, so they do not include "message".

Thank you. Reach out to discuss!