Appian Primary DS is working. Getting the following error: java.lang.

Where would i find the output?

I beleive this is what you are looking for?

sail_state_cache.xlsx

Updating attachment.

sail_state_cache.xlsx

Do you see how my query showed your column is of type image? (see your first output in the XSLX) Even if your other query shows varbinary(max) the one I sent you shows it's an image.

Can you expliclity run:

ALTER TABLE sail_state_cache ALTER COLUMN entry_value varbinary(max) NOT NULL

and try restarting the app server?

I ran that statement, but the output from sp_columns continues to show the TYPE_NAME as an image.

FYI, I am working on this with Clinton.

Did you try restarting JBoss after running the "ALTER TABLE" command? It should start now based on my testing.

Further investigation revealed this happens if you are using and old version of the JDBC driver for SQL Server. You should use version 4.0 www.microsoft.com/.../details.aspx

Thanks Eduardo. We are now using Oracle instead of SQL Server, but good information for anyone else upgrading.