5
Views
1
Comments
Solved
[Trigger Pipeline] Error on adding more than 27 applications to a Pipeline Trigger for CI/CD pipelines
trigger-pipeline
Web icon
Forge component byĀ Rui Mendes
Application Type
Traditional Web
Service Studio Version
11.54.33 (Build 62940)
Platform Version
11.18.1 (Build 37828)

Hello,

On TriggerPipeline plugin, if we try to add more than 27 applications on the Configuration New Pipeline Trigger, we get the error message: "String or binary data would be truncated. The statement has been terminated".

Regards,

Miguel Oliveira



SavePipelineTrigger.png
ConfigurationPipelineTrigger.png
Solution

Hi Miguel,

Probably you are reaching the limit of the number of apps per pipeline.


The number of applications per pipeline is limited by a column that does have a hard limit. 

The good news is that you can increase it to get around that restriction.

To do so, open the LifeTime Trigger plugin in Service Studio and increase the ApplicationKeys and TestApplicationKeys values within the TriggerConfiguration entity.

Note: the value should be under 2000 to keep it as VARTEXT. 



We are aware of this limitation and we plan to refactor the code to save this info via database records instead of saving it as a text attribute.

Cheers,
Duarte CastaƱo | DevOps Domain Expert


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.