Hello All,
I have created a table in Mysql Database and facing the below error when creating CDT against the same table in Appian.
Error Message: The data source [name=jdbc/appian] cannot be reached, does not exist, has been deleted, or you do not have sufficient privileges to access its data.
Note: I can able to query and update the tables in the same data source.
Appreciated it if anyone can answer this issue.
Mike Schmitt
Thanks,
Discussion posts and replies are publicly visible
Hi Dinesh,how are you creating the table? Did you create using xsd or directly from table?
Hi Gopalk,
Am creating from existing table/view option.
Not so sure what can be the reason (some times it happens if you have constraints on your columns) but you can try creating the cdt using xsd. Let me know if it works
Xsd option is worked. Thanks. But the issue is creating CDT from table/view.
Actually some times ago it happened for me as well . Couldn't found out the exact issue . I was having multiple foreign key constraints enabled in that table. Lastly I created using xsd.