Registry 2.6.0 problem with Definition field

[TeijoKal]

When adding data to the system the definition field is not accepting for example the following entries:

• radanpitäjällä
• tienpitäjällä
• särskild förmån

Only if you remove the skandic letters the field value is accepted.

Trying to add the following causes an error message.

The error message is the following:

The requested URL was rejected. Please consult with your administrator.

Your support ID is: 2168295541177837152

[Go Back]

[iratigarzon]

Dear @TeijoKal,

I tried to recreate this error in our local instance, but I did not encounter any issues. Does it happen when you click on the Save button? I created a new item and used "radanpitäjällä" as the definition, and it worked without any problems. Could you please provide more information so I can better replicate the issue?

Best regards,

Irati.

[TeijoKal]

Yes i made an entry named Test. And saved it. And the change the description field to

• radanpitäjällä
• tienpitäjällä
• särskild förmån

The language was Finnish and in the last try used Swdish.

That three description was not the only ones to crash the saving. So that happened when trying to save the modified Description field.

[iratigarzon]

Dear @TeijoKal,

Could you please tell me which languages are currently active and which one is the master language?

Best regards,

Irati.

[TeijoKal]

The languages installed are finnish, swedish and english. Master language is finnish.

[iratigarzon]

Dear @TeijoKal,

I created a local instance with these three languages. I made a test item with "särskild förmån," and I could publish it without any problem. As you can see in the picture below, the status of the item is valid, and I passed through all the workflow stages.

And I can see it in the frontend application:

Does the error "The requested URL was rejected. Please consult with your administrator. Your support ID is: 2168295541177837152" appear in a pop-up when you click the save button? If you could provide more detailed information, it would be really helpful as I can't recreate the problem you are experiencing.

Best regards,

Irati.

[TeijoKal]

Yes the error appears in a pop-up when i click the save button.

It might be database related. We are using postgresql database as follows:

psql (13.14, server 12.10)

[iratigarzon]

Dear @TeijoKal,

When you click the save button, even though this pop-up appears, do you see the new entry in the database? We need to check if the pop-up error is related to the application trying to retrieve the data after the new entry has been saved in the database.

Best regards,

Irati.

[TeijoKal]

In which table in the database it will try to write?

So what table is should check to verify?

[iratigarzon]

Dear @TeijoKal,

You can check this in two tables:

1. If the item has been published: This means the status is valid. In this case, you can find the radanpitäjällä value in the reg_localization table, in the value column.

2. If the item hasn't been published yet: The item should appear in the reg_localizationProposed table.

Apart from checking that, you can try saving this item using an incognito mode window or a browser where you don't have a cache. Sometimes, browsers can produce this error due to cache issues, which are not related to the registry software itself but to the browser's configuration. Please try this test if possible and let me know if the error persists!

Best regards,

Irati.

[TeijoKal]

Tested and nothing goes to database after that failure.

But i tested with definition 'Ääliö älä lyö, ööliä läikkyy'
So there is multiple skandic letters and no problem.

So far the definitions

• radanpitäjällä
• tienpitäjällä
• särskild förmån
  These are not working but other definitions which skandic letters have no problem

[iratigarzon]

Dear @TeijoKal,

Could you please send me a dump of your database? This will allow me to try to recreate the error using the database.

Best regards,
Irati

[TeijoKal]

dump_20240802.txt

Here is dump from our database

[iratigarzon]

Dear @TeijoKal,

I installed your database on my local instance, edited the item labeled "test," and changed the definition to "radanpitäjällä." It didn't present any issues:

I have also published this item:

Additionally, I created another item with a different localID, using the same definition, and published it as well:

Could you please upload screenshots of your step-by-step process so we can see how the error occurs for you?

Best regards,

Irati.

[TeijoKal]

Here are screen shots of my step by step process.

First i created an entry labeled Test

Then i changed the Definition field to Radanpitäjällä

And pressed to save 'Save clarification'

And after that i got the following error...

[iratigarzon]

Dear @TeijoKal,

Have you tried clearing your browser's cache and cookies, closing and reopening your browser, or using an incognito tab (which doesn't cache) to repeat the process? Based on our tests, it seems the issue might be related to the browser rather than the software.

Please let me know if this resolves the issue.

Best regards,
Irati

[TeijoKal]

Tried clearing cache in the browser and also tried incognito. No change, still same error.

I tried with Chrome, Firefox and Edge.

[iratigarzon]

Dear @TeijoKal,

Could you please provide any error logs from PostgreSQL or the software so we can analyze and identify the cause of the problem?

Additionally, could you update the item (test) without using Scandinavian letters and save it? If this works, please try editing it again using Scandinavian letters.

Also, could you inform us about the call that occurs when saving the item?

Best regards,

Irati

[TeijoKal]

I can not access the postgresql server. I have only connection to the database. It is totally a separate database server.

But if I try to save the Definition "radanpitäjällä".

But the entry "Ääliö älä lyö, ööliä läikkyy" goes and it is saved.

For example in "sudo tail localhost_access_log.2024-08-09.txt"

/re3gistry2/itemProposedListLoader?itemUuid=05f7347e2f46dd2d4746cd38867629fa&languageUuid=fi&draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=false&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=false&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=false&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1723189122485

And in "sudo tail catalina.out"

@ UserCodesJob.deleteExpiredCodes: generic error.java.lang.IllegalArgumentException: NamedQuery of name: RegUserCodes.findByDate not found.
User [[email protected]] logged in successfully.
@ UserCodesJob.deleteExpiredCodes: generic error.java.lang.IllegalArgumentException: NamedQuery of name: RegUserCodes.findByDate not found.

[TeijoKal]

It seems that because the Definition entry is using html tags. It might be that the skandic letters are interpreted as Ä and so on. This might mix the saving if the letters are translated as parenthesis.

[iratigarzon]

Dear @TeijoKal,

Have you tried updating the item (test) without using Scandinavian letters and saving it? If this works, please try editing it again using Scandinavian letters. Could you also provide me with the call that occurs when saving the item? (This information is crucial for further analysis). Please let me know the results of this test.

Regarding the HTML tag issues, as I mentioned earlier, on our local instance, we can save the definition successfully, and when we check the REST API (JSON), the definition appears correctly. While this doesn't seem to be a problem at first glance, I'll keep it in mind.

Best regards,
Irati.

[TeijoKal]

Ok. Tested again.

First change the Definition field to "Testing". Saved it and published it.

Next tried to change the Definition field to "Radanpitäjällä" and tried to save it. Same error as before. The following logs were written when trying to save (attached in this mail).

localhost_access_log.2024-08-12.txt
catalina.2024-08-12.log.txt
catalina.out.txt

[iratigarzon]

Dear @TeijoKal,

I have reviewed the logs and did not find any errors related to this issue. To help us identify if the problem is specific to this item, could you please create a new item (with a different local ID), then try adding the description to see if the same error occurs?

If the new item works without issue, you can supersede the problematic item and reference it with the new one.

Best regards,
Irati

[TeijoKal]

I tried by creating a new item with different local id. But this did not help anything. Same error again.

[iratigarzon]

Dear @TeijoKal,

Could you please check which character encoding your machine is using? We want to verify if the issue might be coming from that. Our machine is configured with UTF-8.

Best regards,
Irati.

[TeijoKal]

In the server where the re3gistry is running the environment variable is the following
LANG=en_US.UTF-8

The server where the database is running i have no access only connection to the database.

[TeijoKal]

And connected to the database and checked the encoding

server_encoding

UTF8

[TeijoKal]

Made more testing...

Our environment that has the problem

• re3gistry 2.6.0
• postgresql 12.10 (network database)

I tested with the environment

• re3gistry 2.5.0
• postgresql 14.10 (local database)

No problem with this other environment.

All environments were using UTF-8.

So it seems that the problem is that network database.

[arantzaetxebarria]

Dear @TeijoKal

From our side, we are not able to reproduce the bug in version 2.6.0 in our environment, so we understand that this may be more related to environment configurations.