I added two text fields and a number(integer) field to an existing CDT, publishe

How did you add the additional fields? Did you do it through portal or download the XSD? Can you provide a snippet of the two new fields?

check you JPA annotation for any duplicate column names (usually happens when you do copy and paste for new fields)

Hi Patty, I have downloaded the XSD and have amended it to add the new fields.
Please find the entry in the xsd file for these three new fields I mentioned before.
</xsd:element>
<xsd:element name="shiplist" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
          @Column(nullable=true)
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
           <xsd:element name="farlocation" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Column(nullable=true)
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
           <xsd:element name="other" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Column(nullable=true)
</xsd:appinfo>
</xsd:annotation>
</xsd:element>

1. Check your process variables to see if the values were actually mapped.
2. Did you delete the old CDT and upload the new one? After publishing, did you run Impact Analysis to propagate the updated CDT?
3. Do you see the new table in your database?

Hi Venkat, These are new fields and I have checked and confirmed that the column names are unique.

Hi Patty, The answer is yes for all your 3 questions.

Please change nullable to nillable.

Let me rephrase my last comment, please change the tag to <xsd:element name="other" type="xsd:string" nillable="true"> for each element

In addition to Patty's recommendation it seems there's still something pointing to the old version of the CDT where these fields didn't exist. To fix it:

1. Create an application with your problematic model
2. Use the "Check Missing Dependencies" tool to add the data store and data types
3. When the dependencies are listed you may see CDTs of type ^1 meaning they are old versions. This will confirm the theory
4. At this point you have two options:
---> 4.1 Expor the application and re-import it (to automatically remap)
---> 4.2 Or go to the Data Management tab to see all the CDTs this application reported with the ^1, ^2, etc suffix, select them and run Impact Analysis. There will be a report at the end telling you what items will be updated, just click "update" and wait.

Thank a lot for all your comments Patty, Venkat and Eduardo.... The suggestion from Eduardo worked, I reran the imapact analysis for the CDT with new fields and only my Datastore was shown in BOLD. This started working once I updated the entity in datastore.