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 » Problem with DB operations   XML
 
Author Message
AshokJ



Joined: 12/10/2017 23:57:22
Messages: 8
Offline

In the Log message box in using ED, can you use it to print variables like ucid, handles etc? I need it to know that what is ED retrieving from a DB. I am using a simple query like:

select name from whitelist where number=? --> Whitelist table just a simple number, Name columns

In the ED flow Read from DB task i have:

----Mapped the number vairable to the incoming handle from call events and retrieved input schema.

----Output schema shows ResultSet (Multiple Objects) & Name: String. O/P is sotred in variable ReadFromDB1_Output_1

I have then used below condition on a gateway to allow a call

------ReadFromDB1_Output_1["resultSet"][0]["Name"] == "Y"

I expect Y as the parameter retrieved from the DB in the resultset. And for simplicity i have ensured only entry for each number. So i am testing and expecting a Y to be returned when i make a call (as that number is there is DB with Name parameter as Y against it).

However i get errors.

java.lang.RuntimeException: Could not access element 0 of array
java.lang.RuntimeException: Could not access element 0 of array
com.roobroo.bpm.exceptions.InstanceCreatedWithErrorException: Could not access element 0 of array

Any idea where an i going wrong? I tested with array element 1 as well but to no avail.


AnuragAggarwal



Joined: 01/06/2014 21:52:05
Messages: 57
Offline

Hi Ahsok, can you please go to admin console and find your instance and click on db task, it would open a window showing what are the inputs and outputs of db task, can you please provide that information
AshokJ



Joined: 12/10/2017 23:57:22
Messages: 8
Offline

Thanks Anurag. I fixed this problem, i did not handle the problem of the resultset being returned empty.

However, i am still looking for info in the log message we can print the variable values? I currently think it allows only to print fixed statements, but i might be wrong. Looking for ways in which the log messages can print variable values?
AnuragAggarwal



Joined: 01/06/2014 21:52:05
Messages: 57
Offline

you can go to input mapping in log message and do the mapping to log message input (from varaible value), then that varaible value would be shown in logs
 
 
Go to: