Hey TS,
Hey TS,
I'm having some issues with the deployment API throwing validation errors for a liveboard, but the same liveboard TML validates perfectly fine within the UI.
The error in the response looks like this
Visualization <b> Viz_1 </b> has following errors:<br/>Internal API failed while getting answer. Error: Formula addition failed. Formula: EE Pay, Error: Search did not find "EE Pay Type = 'base' ) then" in your data or metadata. Expecting one of the valid keywords, such as, "(", "-", "abs" etc..The viz is referencing a formula
- id: EE Pay name: EE Pay expr: "if ( [EE Pay Type] = 'base' ) then [Annual Base (USD)] else if ( [EE Pay Type] = 'total cash' ) then [Annual TCC (USD)] else if ( [EE Pay Type] = 'total direct cash' ) then [Annual TDC (USD)] else null" was_auto_generated: falseThere is then a parameter that is in the model
name: EE Pay Type data_type: CHAR default_value: Base list_config: list_choice: - value: Base display_name: '' - value: Total Cash display_name: '' - value: Total Direct Cash display_name: '' description: ''The liveboard works fine in my source org. However, attempting to deploy it to my secondary org is running into this validation error. Our SRE also couldn't see anything out of the norm and suggested it may be worth it checking discord. Curious if anyone has any ideas what the disconnect may be? I'd rather not manually deploy the liveboard because I don't want to lose the connection between it and the source. Thanks
12 Replies
Are you creating this parameter and liveboard within the same TML request?
The parameter is defined in the model's TML but the formula is in the Liveboard's TML as part of a visualization
.
I'm not using a TML request specifically. Just using the deploy API but I might be misunderstanding the question
I meant within the same API call.. Which API call are you using?
I'm using "api/rest/2.0/vcs/git/commits/deploy" after commiting the objects to the target branch
So the issue looks like EE Pay Type is not being found in the system when you are trying to deploy the liveboard. And the same liveboard TML is validating perfectly fine in the UI. Can you try deploying after first commiting the model's TML and then again deploy after commiting the liveboard? It could be that it is trying to deploy both at once and is unable to find the parameter in the system since it is not yet present in the system..
thanks for the suggestion. So I did manage to get the worksheet to deploy with the parameter using a PARTIAL deploy but the viz is still throwing that error for the formula
If the worksheet is deployed then there should be no error from the viz now. Can you try again? If you face the error again, can you try to validate from UI to check if the TML is valid there or not?
The TML is validating fine in the import TML wizard. But attempting the
VALIDATE_ONLY deploy or a real deployment still are complaining about the formula
It even let me import and created the liveboard fine so whatever validation it is tripping on seems to be unique to the API unless something else is coming into play
Yes it seems to be a bug. Can you create a support ticket for this as well? Ask the SRE to get help from the relevant eng team
OK sounds good, thanks
cc @Srikanth Jandhyala