How to resolve ERROR: function sem_number_to_char(character varying) does not exist
S
Subham Dixit
started a topic
about 4 years ago
I'm getting an unexpected error while browsing my business view, ERROR: function sem_number_to_char(character varying) does not exist, Can you please help me to get it resolved?
Best Answer
S
Subham Dixit
said
about 4 years ago
While deploying the model having SEM_NUMBER_TO_CHAR (StreamingTagsID ) in the Display card Primary text expression but the StreamingTagsID is already in the string format, This function expects an integer but here is the string that’s why we are getting this error message while trying to access the business view.
Here as you can see the StreamingTagsID is already in String format.
And here we are converting it into the string again through the expression SEM_NUMBER_TO_CHAR(StreamingTagsID), which will be used to convert the number into the string. So we have to remove this and put only StreamingTagsID to solve this error.
1 Comment
S
Subham Dixit
said
about 4 years ago
Answer
While deploying the model having SEM_NUMBER_TO_CHAR (StreamingTagsID ) in the Display card Primary text expression but the StreamingTagsID is already in the string format, This function expects an integer but here is the string that’s why we are getting this error message while trying to access the business view.
Here as you can see the StreamingTagsID is already in String format.
And here we are converting it into the string again through the expression SEM_NUMBER_TO_CHAR(StreamingTagsID), which will be used to convert the number into the string. So we have to remove this and put only StreamingTagsID to solve this error.
Subham Dixit
While deploying the model having SEM_NUMBER_TO_CHAR (StreamingTagsID ) in the Display card Primary text expression but the StreamingTagsID is already in the string format, This function expects an integer but here is the string that’s why we are getting this error message while trying to access the business view.
Here as you can see the StreamingTagsID is already in String format.
And here we are converting it into the string again through the expression SEM_NUMBER_TO_CHAR(StreamingTagsID), which will be used to convert the number into the string. So we have to remove this and put only StreamingTagsID to solve this error.
Subham Dixit
While deploying the model having SEM_NUMBER_TO_CHAR (StreamingTagsID ) in the Display card Primary text expression but the StreamingTagsID is already in the string format, This function expects an integer but here is the string that’s why we are getting this error message while trying to access the business view.
Here as you can see the StreamingTagsID is already in String format.
And here we are converting it into the string again through the expression SEM_NUMBER_TO_CHAR(StreamingTagsID), which will be used to convert the number into the string. So we have to remove this and put only StreamingTagsID to solve this error.
-
LOV label in Named Query
-
How we can set Dynamically changing Form field Description?
-
Is it possible to have a conditional survivorship rule based on a SemQL filter (akin to the filter on privileges)?
-
Where Do I View 2 Merged Records?
-
Show/hide an attribute in a form
-
Restrict access of attributes
-
Is it possible to manage visible/invisible value in List depend on user role??
-
Why am I unable to merge duplicates?
-
How are child records selected when parent records are manually merged?
-
Can the response from the API Call Response can be formatted differently in the JSON output?
See all 178 topics