Error verifying datastore

Hi,

I made changes to the View (added a column to the view with datatype = text). Added the same definition to the CDT by adding new column with datatype=text.

When i try to verify the datastore, it is giving me the below error

The data source schema does not match the type mappings: Wrong column type in Appian.p_my_view for column fs_structure. Found: text, expected: VARCHAR(341) (APNX-2-4056-000). see below for CDT definition and view definition. There are other column exists in the view with text and it doesnt complain.

any help is appreciated.

  Discussion posts and replies are publicly visible

Parents
  • For what DB the system is connecting to, check your admin console and the Appian-ds file.

    You should also check synonyms and roles that you are connecting as and to. They may be connecting to the correctly indicated schema, but not looking at the object you think.

    Regards, 

    Woodyman

    Reach back freely if ur still facing a problem

Reply
  • For what DB the system is connecting to, check your admin console and the Appian-ds file.

    You should also check synonyms and roles that you are connecting as and to. They may be connecting to the correctly indicated schema, but not looking at the object you think.

    Regards, 

    Woodyman

    Reach back freely if ur still facing a problem

Children
No Data