Hi, I have tried to configure DB2 as the database with IS 5.4.0-Alpha2. When I try to execute identity DB2 scripts, I came across the following errors. I have attached the corrected scripts here with. Created the following jira to track this [1].
1) CREATE TABLE IDN_RECOVERY_DATA ( ... *TENANT_ID INTEGER DEFAULT -1,* ... REMAINING_SETS VARCHAR(2500) *DEFAULT NULL)*, PRIMARY KEY(USER_NAME, USER_DOMAIN, TENANT_ID, SCENARIO,STEP), UNIQUE(CODE) Errors:- 1. The column named "TENANT_ID" cannot be a column of a primary key or unique key constraint because it can contain null values. 2. Mistakenly used DEFAULT NULL. Syntax error is here. Either it should be "WITH DEFAULT NULL" or no need to specify the default value as null because implicitly it will be NULL anyhow. 3. Closing bracket was misplaced. 2) CREATE TABLE :- IDN_PASSWORD_HISTORY_DATA Error:- The columns named "TENANT_ID" and "SALT_VALUE" cannot be a column of a primary key or unique key constraint because it can contain null values. 3) CREATE TABLE :- IDN_CLAIM Error:- The column named "DIALACT_ID" cannot be a column of a primary key or unique key constraint because it can contain null values. 4) CREATE TABLE :-IDN_CLAIM_MAPPED_ATTRIBUTE Error:- The column named LOCAL_CLAIM_ID cannot be a column of a primary key or unique key constraint because it can contain null values. 5) CREATE TABLE :-IDN_CLAIM_PROPERTY Error:- The column named LOCAL_CLAIM_ID cannot be a column of a primary key or unique key constraint because it can contain null values. 6) CREATE TABLE IDN_SAML2_ASSERTION_*STORE (* ID INTEGER NOT NULL, SAML2_ID VARCHAR(255) , SAML2_ISSUER VARCHAR(255) , SAML2_SUBJECT VARCHAR(255) , SAML2_SESSION_INDEX VARCHAR(255) , SAML2_AUTHN_CONTEXT_CLASS_REF VARCHAR(255) , SAML2_ASSERTION VARCHAR(4096) , *PRIMARY KEY (ID)* Error:- Closing bracket was missed [1] https://wso2.org/jira/browse/IDENTITY-6377 <https://wso2.org/jira/browse/IDENTITY-6377> Thanks, Nila. -- Nilasini Thirunavukkarasu Software Engineer - WSO2 Email : [email protected] Mobile : +94775241823 <+94%2077%20524%201823> Web : http://wso2.com/ <http://wso2.com/signature>
db2_identity.sql
Description: application/sql
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
