Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
14 replies
Subscribers
8 subscribers
Views
6742 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Updated CDT error
judym598
Certified Senior Developer
over 8 years ago
I was recently updating a data type and when Appian validated it with the data store, I got the following error, "The data source schema does not match the type mappings: Wrong column type in Appian.pshactiveagreementsdetail_v for column urlfordocuments. Found: text, expected: varchar(255)"
This data store contains data types associated with views. I recently changed the size of one of the fields in the original table used in this view from a varchar(450) to varchar(1000). The table still shows it as varchar but the view shows it as 'text'. Since the type I selected for this field in the CDT is 'Text', why am I getting this error? Why is it showing up as text in my view vs a varchar type? I'm guessing because of the size. Can I safely change the type in my table to 'text'? I have several tables that have fields with a varchar type > 255. Is that a problem? I need this view in order to display data from multip...
OriginalPostID-235237
Discussion posts and replies are publicly visible
Parents
0
chandu
A Score Level 2
over 8 years ago
If I understand correctly, u have changed the original table column from varchar(450) top varchar(1000). In this case can you delete the view, Create it again,
and Check the Cloumn Definition. Is that still showing as "Text"?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
chandu
A Score Level 2
over 8 years ago
If I understand correctly, u have changed the original table column from varchar(450) top varchar(1000). In this case can you delete the view, Create it again,
and Check the Cloumn Definition. Is that still showing as "Text"?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data