Question

Import Excel to Database Smart service failing to write a Data in Staging Table

Forum|Forum|2 years ago
July 2, 2024
12 replies
1 view

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,

Y

yogip3177

Check "Data Source Name" configuration of Import Excel to Database node.

H

harshadd0001Author

Hi [mention:3510a5189ce1477eaf2e09f5858c87e9:e9ed411860ed4f2ba0265705b8793d05:label=Abhishek%20Karumuru%20%28karumurua0001%29%20%20] [mention:c3d4bf332aba4695885fdc0e0110ec6e:e9ed411860ed4f2ba0265705b8793d05] 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

karumurua531442

hi [mention:692df133f71e449ca1e549caf2d37f49:e9ed411860ed4f2ba0265705b8793d05] could you check you have given the datastore name in the input of the smart service

H

harshadd0001Author

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].???]