Author |
Message |
|
|
andywfinlay
Joined: Jan 24, 2017
Messages: 30
Offline
|
I have built out the connection to the DB per the documentation. I am now trying to use the Update DB in a WF. I select the DB server from the dropdown profile name and enter the following SQL Query (format per example in EDDeveloperGuide page 80)
INSERT INTO dbo.Breeze (OriginalANI, OriginalVDN) VALUES ('18015555898',?)
The OriginalANI and OriginalVDN are field names in the DB i'm trying to update. I get the following when Retrieving the input schema:
error getting input schema for update DB task: java.lang.illegalstateexception: Failed to get parameter metadata from SQL
|
|
|
|
|
Shikha
Joined: Jul 28, 2014
Messages: 13
Offline
|
Hi,
Is your connection with DB successful? Can you carry this out under Avaya Breeze -> Configuration -> JDBC Profiles, then select your profile and click on Test Connection.
Also, please share your WF.
Regards,
SHikha
|
|
|
|
|
andywfinlay
Joined: Jan 24, 2017
Messages: 30
Offline
|
I can connect to the DB from Breeze. The test connection shows completed successfully.
attached is my WF (stripped down the Auth info). It is only a test WF for validation purposes.
Filename |
SalesforceAPI-UpdateDB-share.xml |
Download
|
|
|
|
|
|
Shikha
Joined: Jul 28, 2014
Messages: 13
Offline
|
I am not able to open the Input mapping of the UpdateDB task. I am getting syntax error. I hope you have done the mapping there to provide value for OriginalVDN.
Please send us logs at INFO level to investigate.
|
|
|
|
|
andywfinlay
Joined: Jan 24, 2017
Messages: 30
Offline
|
It doesn't allow me to go to input mapping. It shows 'Syntax error in schema'.
I've attached a picture of the Update DB data.
I'll get the LOGS and attach in a bit.
|
|
|
|
|
Shikha
Joined: Jul 28, 2014
Messages: 13
Offline
|
Can you try executing the update command directly in the db?
|
|
|
|
|
andywfinlay
Joined: Jan 24, 2017
Messages: 30
Offline
|
yes, same command in db works fine. see attached picture.
|
|
|
|
|
Shikha
Joined: Jul 28, 2014
Messages: 13
Offline
|
Hi,
I think we do not need to refer dbo.Breeze here but only Breeze, as we have mentioned the name of the db in the connection settings.
Can you try with editing Insert command without using "dbo."
Regards,
Shikha
|
|
|
|
|
andywfinlay
Joined: Jan 24, 2017
Messages: 30
Offline
|
actually, on the contrary, I needed to add to it rather than reduce it. It now works with Telecom.dbo.Breeze.
thanks for everyone's help.
Andy
|
|
|