Actions
Defect #2477
closed
Application won't start with existing data under MSSQL database
Start date:
09/04/2020
Due date:
% Done:
100%
Estimated time:
Affected versions:
Owner:
Description
Script V10_05_002__uniform-password-definition.sql alter table sys_system_attribute_mapping and add column password_filter with not null statement. For databases which have already some record inside this script fails because default value missing.
Please create new defensive script that will be OK.
Related issues
Updated by Ondřej Kopr over 3 years ago
- Status changed from In Progress to Needs feedback
- Assignee changed from Ondřej Kopr to Radek Tomiška
- % Done changed from 0 to 90
Solved with @tomiskar help. Thank you. Solved with
Commit: https://github.com/bcvsolutions/CzechIdMng/commit/f3ed5133aa1ffa694f6992f5bbfb15956f71bd11 (branch: hotfix-10.5.1)
Tested scenarios:- move with systems from 10.4.4 to 10.5.1,
- move without systems from 10.4.4. to 10.5.1,
- move with systems from 10.5.0 to 10.5.1.
Please @tomiskar could you provide me a feedback? Thank you and sorry for my mistake.
Updated by Ondrej Husník over 3 years ago
After applying the fix this issue is gone. Tested on locally installed MSSQL version 15.0.2070.41
Updated by Radek Tomiška over 3 years ago
- Status changed from Needs feedback to Closed
- Assignee changed from Radek Tomiška to Ondřej Kopr
- % Done changed from 90 to 100
I did test, it works, thx!
Version 10.5.1 is released.
Updated by Radek Tomiška almost 3 years ago
- Related to Defect #2811: Some flyway scripts depend on a "public" schema (Postgresql). added
Actions