I will share my solution, it may be useful to someone.
In my case, the problem arose due to a change in the encoding of the database. As a result of this, lowercase columns were not actually lowercase. XML backup and restore did not help to resolve this.
The query below found all the lowercase columns in the database schema:
select table_schema, table_name, column_name from information_schema.columns where column_name ilike '%lower%';
Compared the source and lowercase data for all found columns:
select title,lowertitle from content where lowertitle!=lower(title);
select application_name,lower_application_name from cwd_application where lower_application_name!=lower(application_name);
select directory_name,lower_directory_name from cwd_directory where lower_directory_name!=lower(directory_name);
select impl_class,lower_impl_class from cwd_directory where lower_impl_class!=lower(impl_class);
select group_name,lower_group_name from cwd_group where lower_group_name!=lower(group_name);
select attribute_value,attribute_lower_value from cwd_group_attribute where attribute_lower_value!=lower(attribute_value);
select user_name,lower_user_name from cwd_user where lower_user_name!=lower(user_name);
select first_name,lower_first_name from cwd_user where lower_first_name!=lower(first_name);
select last_name,lower_last_name from cwd_user where lower_last_name!=lower(last_name);
select display_name,lower_display_name from cwd_user where lower_display_name!=lower(display_name);
select email_address,lower_email_address from cwd_user where lower_email_address!=lower(email_address);
select node_name,node_name_lower from diagnostics_alerts where node_name_lower!=lower(node_name);
select url,lowerurl from extrnlnks where lowerurl!=lower(url);
select destpagetitle,lowerdestpagetitle from links where lowerdestpagetitle!=lower(destpagetitle);
select destspacekey,lowerdestspacekey from links where lowerdestspacekey!=lower(destspacekey);
select spacekey,lowerspacekey from spaces where lowerspacekey!=lower(spacekey);
select url,lowerurl from trackbacklinks where lowerurl!=lower(url);
select username,lower_username from user_mapping where lower_username!=lower(username);
Updated the data in the corresponding columns:
update content set lowertitle=lower(lowertitle);
update links set lowerdestpagetitle=lower(lowerdestpagetitle);
After that, all links regained their functionality.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.