How to resolve ERROR: function sem_number_to_char(character varying) does not exist
S
Subham Dixit
started a topic
about 2 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 2 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 2 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.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 274 topics