Please login or register to access secure site features.

Note: By continuing to use DevConnect Program Services you agree to our latest Registered Member Terms.

Sign in using DevConnect ID

Forgot password?

Trouble logging in?

Submit a ticket for Registration Support.

I have an SSO ID

?
sign in

Don't have a DevConnect or SSO ID ?

Create a DevConnect account or join the program.

register now
^
Forum Index » Engagement Designer » Update DB giving me issues   XML
 
Author Message
andywfinlay



Joined: 24/01/2017 14:21:27
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

This message was edited 2 times. Last update was at 03/06/2019 13:34:38

Shikha



Joined: 28/07/2014 00:09:15
Messages: 12
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: 24/01/2017 14:21:27
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 [Disk] Download
 Description No description given
 Filesize 119 Kbytes
 Downloaded:  9 time(s)

This message was edited 2 times. Last update was at 04/06/2019 10:24:31

Shikha



Joined: 28/07/2014 00:09:15
Messages: 12
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: 24/01/2017 14:21:27
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.
[Thumb - BreezeUpdateDB.JPG]
 Filename BreezeUpdateDB.JPG [Disk] Download
 Description No description given
 Filesize 123 Kbytes
 Downloaded:  13 time(s)

This message was edited 2 times. Last update was at 06/06/2019 09:56:40

Shikha



Joined: 28/07/2014 00:09:15
Messages: 12
Offline

Can you try executing the update command directly in the db?
andywfinlay



Joined: 24/01/2017 14:21:27
Messages: 30
Offline

yes, same command in db works fine. see attached picture.
[Thumb - BreezeUpdateDB2.JPG]
 Filename BreezeUpdateDB2.JPG [Disk] Download
 Description No description given
 Filesize 134 Kbytes
 Downloaded:  14 time(s)

Shikha



Joined: 28/07/2014 00:09:15
Messages: 12
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: 24/01/2017 14:21:27
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
 
 
Go to: