Base64 Document Database Integration

Were you able to resolve this issue?

Is this still an issue? This should indeed error gracefully. What is the error in tomcat stdout log?

Dear Community,

The Plug-In works well for us, we are using 'Get Base64 Document from Database' Smart Service.

The documents are downloaded and stored as expected only when there is a data in the database record.

However when the field is empty (we are missing document for certain record), the Process is paused with error. I was rather expecting it will get completed and pass the information to me with output variables 'isSuccess' and 'errorMessage', but for this specific use case it is just crashing.

I am looking for a smart workaround. I can think of using the Query Database node before to check if there is a value in the database and depending on it: end the process or move forward. However that seems not very efficient for me as i will query database twice with this process.

Do you see any other solution ?

Thank you in advance for all suggestions,
Best Regards,
Maciej

Hi Corrado, we have used this plugin in our application. In light of the recent discovery of vulnerabilities with log4j2, we would like to know if this plugin uses the affected version Log4j2, and if yes, would you release an updated version of this plugin to counter the exploit of vulnerability?

Hi there,

This plugin works for me when I use a simple SQL statement: SELECT []  from []  where [] =  [] 

However, I keep getting syntax errors when I try something more complex: SELECT [] from [] where [] = [] AND [] = []

What would be the correct way to format this string?

Thank you

Hi,

I am getting the same issue which you faced. Could you please look into the below attachments and suggest me any pointers to resolve this?

Database structure

Data getting stored in DB

PM Details

it worked !
Thanks

Hi,

I solved this by changing the structure of "base64str" in the database from "varchar(1000)" to "text" .. here below the sql statement:

CREATE TABLE book (
base64str text,
title varchar(100)
)

Hi everybody,

I tried to use this plugin in 19.4 Appian version.

I was able to configure the insert into db smart service but it provides me as output exactly the ID of the document instead of the base64 conversion. 

Here below the configuration i have used:

input data:

*JNDI Name (text):  "jdbc/BusinessData" --> found on the admin console / Data source

*Sql Statement (text): "INSERT INTO dbo.pkbbase64  VALUES     (:documentid,:title)"

*documentid (number-integer): document id present in appian

*title (text): "test string"

what I get in the table is:

*base64 (varchar(4000)) --> exactly the documentID (not converted)

*title (varchar(255)) --> "test string"

This situation happens both for pdf and txt file.

Can anyone support me please?

Thanks

Hello Team,
Im getting the following error : Error in executeUpdate, String or binary data would be truncated.
Can you help resolve this