/
Error when using certain features such as clone and optimizer: 0: [ADvendio__FromHour__c]

Error when using certain features such as clone and optimizer: 0: [ADvendio__FromHour__c]

Summary:

Some customers are reporting an error when they use certain features such as the optimizer, clone and submit to adserver:

"Cloning ADvendio__Campaign_Item__c records: - Insert failed. First exception on row 3; first error: INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST, bad value for restricted picklist field: 0: [ADvendio__FromHour__c]"

The error can also be found in the following fields:

  • From (Minute)

  • Until (Hour)

  • Until (Minute)

https://advendio.atlassian.net/wiki/spaces/SO/pages/1007157284/Known+Issues+limits

The restriction means, that code or imports can not enter picklist values that are not actually defined as active picklist values in the field setup, but it still means an ADvendio user can add new manual picklist values. Since we fixed the behavior in the Gateway, leaving 0 should also not cause further problems.

Solution:

In setup navigate to the “from (hour)” & “minute (hour)” fields, manually add a 0 picklist value, and also add it to the Record Type Picklist value assignment - selected values column (see below).

 

 

Screenshot 2024-07-22 at 10.44.57.png
Screenshot 2024-07-22 at 10.43.56.png

Issue present in Advendio version 2.171.13

 

The same message can be present during certain operations (cloning, optimizing, etc) after update 2.171.13. The solution is the same, but adding a “1” value to the picklist for the campaign item object. This has to be done for the From (Hour), From (Minute), Until (Hour) and Until (Minute) fields for all records types.

 

 

 

Related content