Error verifying datastore

Hi there,

Could you check the XSD for the View CDT and see if you have something similar to the code below:

<xsd:element name="financialStructure" nillable="true" type="xsd:string">
	<xsd:annotation>
	  <xsd:appinfo source="YOURSOURCE">@Column(name="fs_structure", nullable=true, columnDefinition="VARCHAR(341)")</xsd:appinfo>
	</xsd:annotation>
</xsd:element>

I'm not sure if you already tried that, but maybe you just need to download and edit the XSD and create a new version of the CDT.

Regards,

Acacio B.

Hi ramkumars0001,

The data store throws an error because the column data type in the view is different than what you've defined in the XSD. To overcome this you should either:

1. If that column is for sure going to capture text values, then change the columnDefinition in your XSD file to below:

   <xsd:element name="financialStructure" nillable="true" type="xsd:string">
   	<xsd:annotation>
   	  <xsd:appinfo source="YOURSOURCE">@Column(name="fs_structure", nullable=true, columnDefinition="TEXT")</xsd:appinfo>
   	</xsd:annotation>
   </xsd:element>

2. If that column doesn't need to be a text type, you can typecast the column in your view to the defined format.

Also, I could see that all the columns have different definitions in Appian and in the database. Kindly ensure that the data type that you mention in the XSD is the same as the one in the database.

hi Thank you so much for your help. I already tried creating new version from XSD. It still complains

I also tried the solution suggested Selvakumar Kumarasamy below and it still complains the same.

Our DB was migrated from MySQL to MariaDB. Not sure if this is the root causee.

Thank you so much for your time and  attention! You are awesome!. Have  a great day

hi Selvakumar Kumarasamy I tried your solution and it still complains.

Our DB was migrated from MySQL to MariaDB. Not sure if this is the root causee.

Thank you so much for your time and  attention! You are awesome!. Have  a great day

The easiest way to find the correct syntax you need is to generate a new CDT directly from the database view. You won't actually need the CDT later (and can plan to delete it once you're done), but that should tell you what syntax is needed to connect to that field if you then download the XSD of this new CDT. Then, just copy the element from this new CDT into your old CDT XSD and re-upload, and you should be good to go!

I have a problem when importing my datastore, it does not work, it indicates that it does not find some sequences but of those sequences mentioned are not used, I need to know why it requests them.
Where can I find all the sequences used by the system besides the cdts?

I have a problem when importing my datastore, it does not work, it indicates that it does not find some sequences but of those sequences mentioned are not used, I need to know why it requests them.
Where can I find all the sequences used by the system besides the cdts?

It looks like this is a different issue than the original one from this post - can you create a new post? Please als provide more information about what you tried, what error messages you received, etc.

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

 , Selvakumar Kumarasamy, Peter Lewis,  jasong0004

I had to change my view and cast my text columns into varchar and it fixed the problem. 

Many thanks for your time and assistance. Have a great day to you all!