I am creating CDT for one table stored in cloud database but one column with datatype 'longtext' is not fetched in the CDT. So I have tried to add this column explicitly in the downloaded XSD file of this CDT by using the below code:
<xsd:element name="abc" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(name="ABC", columnDefinition="LONGTEXT")</xsd:appinfo> </xsd:annotation> </xsd:element>
It is saved properly. Then I have created one constant using this CDT. and used it as 'Data Store Entity' field in 'Export DataStore Entity to Excel' smart service but it is not working and the node is failed with the below error message:
Please help me why the error is there.
Discussion posts and replies are publicly visible
The type longtext might not be supported (see https://docs.appian.com/suite/help/20.2/Generating_Database_Tables_from_CDTs.html#default-column-types-based-on-xsd-types). Which DB are you using?
longtext
Thank you for your response.
The issue has been resolved now. I was facing the issue because of the character limit of excel sheet. The data stored in the appian database table having 'longtext' datatype is having data with more than 32,767 characters which is more than excel character limit i.e. 32,767.
After truncating the data from the column in the appian database, the error got resolved and I am able to export data in the excel sheet successfully.