Skip to main content
dineshl771529
New Participant
Apr 6, 2022 12:11 AM UTC
Question

The data source [name=jdbc/appian] cannot be reached

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.

[mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] [mention:8b930cc189ea4ddf8fcb9c275d619049:e9ed411860ed4f2ba0265705b8793d05]

Thanks,

8 replies

gopalk2865
gopalk2865
Participating Frequently
Apr 6, 2022 1:53 AM UTC

Hi Dinesh,how are you creating the table? Did you create using xsd or directly from table?

dineshl771529Author
New Participant
Apr 6, 2022 5:31 AM UTC

Hi Gopalk,

Am creating from existing table/view option.

gopalk2865
gopalk2865
Participating Frequently
Apr 6, 2022 5:41 AM UTC

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

dastagirid0004
dastagirid0004
Participating Frequently
Apr 6, 2022 7:13 AM UTC

Hi Dinesh,

Please refer Design Error Log (design_errors.csv under <APPIAN_HOME>/logs directory) for any errors.

It will detail you the root cause.

arockiaprincyv0003
arockiaprincyv0003
Participating Frequently
Apr 6, 2022 4:46 PM UTC

Hi Dinesh,

Do you have sufficient privileges to access the data?Check your data store security permission.

dineshl771529Author
New Participant
Apr 6, 2022 4:49 PM UTC

Yes, I have access to that data.

Terms & ConditionsAccessibility statement