Skip to main content
armandoh
armandoh
November 13, 2021
Question

The data store "VFM Data Store" [id=3599] was saved but cannot be published

  • November 13, 2021
  • 16 replies
  • 1 view

Hi, I am completing the Appian dev path and on the second exercise, when verifying the data store I am getting the following error:

16 replies

richardm900458
richardm900458
November 14, 2021

How does you cdt look like?

Are there several CDT s connected to the data store?

armandoh
armandohAuthor
November 15, 2021

Hi Richard. First of all thank you for taking the time to help me out! So there is only one CDT connected to this data store. This is how my CDT looks like:

stefanhelzle0001
stefanhelzle0001
Brainy
November 14, 2021

Did you create that DataStore before and modified some CDTs meanwhile? In that case and assuming you do not have any relevant data in that tables, I would just drop the tables and have Appian recreate them.

The root cause here is, that Appian will not modify existing tables or fields.

armandoh
armandohAuthor
November 15, 2021

Hi Stefan, thank you for taking the time to reply to my issue. So I followed the step by step guide and in there it says to create the CDT first and then the DataStore. So to answer your question, the CDT was created first. I only have one CDT connected to this datastore.

stefanhelzle0001
stefanhelzle0001
Brainy
November 15, 2021

What I mean, is that when you have an existing CDT and DS, and then modify the CDT, you might get into this issue. For example, when you forgot to add the field "id" defined as primary key, then published, then added this field.

peter.lewis
peter.lewis
Employee
November 15, 2021

It looks like you're trying to use a text field for your ID - is that correct? Also have you tried to use auto-generate on this field? I believe auto-generate only works on integer fields. Also in general using an integer for the ID is recommended because the performance will be much better when using this field as a foreign key.

stefanhelzle0001
stefanhelzle0001
Brainy
November 15, 2021

[mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05] Great you spotted that.

armandoh
armandohAuthor
November 16, 2021

Thank [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] for also helping me out with this. I really appreciate it!

Terms & ConditionsAccessibility statement