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
Hi Dinesh,
Please refer Design Error Log (design_errors.csv under <APPIAN_HOME>/logs directory) for any errors.
<APPIAN_HOME>/logs
It will detail you the root cause.
Do you have sufficient privileges to access the data?Check your data store security permission.
Xsd option is worked. Thanks. But the issue is creating CDT from table/view.
Yes, I have access to that data.
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.