Skip to main content
New Participant
April 6, 2022
Question

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

  • April 6, 2022
  • 8 replies
  • 0 views

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
Participating Frequently
April 6, 2022

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

New Participant
April 6, 2022

Hi Gopalk,

Am creating from existing table/view option.

gopalk2865
Participating Frequently
April 6, 2022

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
April 6, 2022

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
April 6, 2022

Hi Dinesh,

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

New Participant
April 6, 2022

Yes, I have access to that data.