Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Attach conditional authentication script fails with MSSQL #1657

Open
udarakr opened this issue Jun 21, 2018 · 0 comments
Open

Attach conditional authentication script fails with MSSQL #1657

udarakr opened this issue Jun 21, 2018 · 0 comments

Comments

@udarakr
Copy link
Contributor

udarakr commented Jun 21, 2018

Description:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Implicit conversion from data type nvarchar(max) to varbinary(max) is not allowed. Use the CONVERT function to run this query.

DB script fix:
CREATE TABLE SP_AUTH_SCRIPT (
ID INTEGER IDENTITY NOT NULL,
TENANT_ID INTEGER NOT NULL,
APP_ID INTEGER NOT NULL,
TYPE VARCHAR(255) NOT NULL,
CONTENT NVARCHAR(MAX) DEFAULT NULL,
IS_ENABLED CHAR(1) NOT NULL DEFAULT '0',
PRIMARY KEY (ID)
);

Suggested Labels:

Suggested Assignees:

Affected Product Version:

OS, DB, other environment details and versions:

Steps to reproduce:

Related Issues:

ashendes pushed a commit to ashendes/carbon-identity-framework that referenced this issue Jan 21, 2022
Add config return_only_mapped_local_roles_unmapped_exclusive
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant