Hi Community,
I am facing an issue while uploading the excel file using the (Import Excel to Database ) smart service in one of the process , Could you please provide some inputs why this is occurring as we have already configured with correct business DB, Error has been attached as below,
Discussion posts and replies are publicly visible
Check "Data Source Name" configuration of Import Excel to Database node.
hi harshadd0001 could you check you have given the datastore name in the input of the smart service
Hi harshadd0001,
If you are using data source connected systems, then use a!getDataSourceForPlugin() Function - Appian 24.2 function in data Data source name field.
If you are using basic Appian Maria DB, then use "jdbc/Appian"
Hi Abhishek Karumuru (karumurua0001) Yogi Patel Data source name is correctly configured. Is there anything apart from that? this plugin is not working in new migrated server still it's working on old infra. configuration level - in old infra, DS has been configured at host level but in new infra at admin console level could be reason for failing? other operations like read/write able to do with same configuration but plugin is failing.
one more point - in new infra that smart service has different configuration compared to old infra plugin it could be the reason. will post the screenshots
Hi Yogi,
have attached screenshots for your reference, DS name is same only the difference i see into the JDBC driver version.
new infra - DS
old infra -DS
Hi Abhishek, yes we have same name attached in screenshot also adding the logs
Appian Log
Caused by: com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[Not able to connect to database. Name [businessds] is not bound in this Context. Unable to find [businessds].=???Not able to connect to database. Name [businessds] is not bound in this Context. Unable to find [businessds].???]
Hi Sri Ram Kaja,
Not using the Connected System, we have configured the DS in console Admin level as we are still able to read and write operations by using same DS in same process.
Are you able to write data to DB using write to data store entity? if yes, then some configuration issue with import excel, if you are not able to do then there might be issue at connectivity level.
Hi All,
This issue has been resolved, the issue which we suspected earlier that is correct. Configuration is required at host level for business DS. its working fine now. Thank you all for your help and support.