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

GouthamKrishna over 10 years ago

Appian Primary DS is working. Getting the following error:

java.lang.IllegalStateException: [jdbc/primaryds] The schema is invalid.

Please let me know, what can be done to solve this error...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 10 years ago

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?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 10 years ago

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?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data