Strange characters in database (Urgent please help)

HCL Domino Domino Forum
1

Hi

When I am opening the database in designer to create view. I have found that there are some strange characters along with fields name to select for column values.

Although the template design doesn’t have these characters. When I am refreshing the design with the template it is getting refresh but these strange characters are still there.

Pleas help … its urgent

Thanks in advance

Lalit

2

Subject: Strange characters in database (Urgent please help)

you might have to give us some more info. What kind of characters? What does it look like?

3

Subject: RE: Strange characters in database (Urgent please help)

These charcteres don’t make any sense. These are series of all the possible charcters. Even some of these characters are not present on the keyboard as well. These look like if you open one format file in another format and when it opens you can’t read it because it of soome weired letters which doesn’t make any sense.

4

Subject: RE: Strange characters in database (Urgent please help)

To have an idea of these characters just open a JPG file in notepad. These strange characters are of same type.

5

Subject: Strange characters in database (Urgent please help)

The field list usually lists the fields present in the documents in your database so this is not related to your template at all.Have you checked your documents to see if that is indeed the case? If they all dont make sense you might be dealing with corrupt data.

You can just chose to ignore it and type in your fieldname rather than selecting it from te list

6

Subject: RE: Strange characters in database (Urgent please help)

Thanks for your response Marjan

If this is the case that the field list is the list of fileds present in document then how can I get the handle of the documents which contain these corrupted fields. The database contain around 26 thousands documents.

Secound thing we want to remove these fields so ignoring these fields is not the option.

Please suggest.

7

Subject: RE: Strange characters in database (Urgent please help)

Hi L T

I only work 2 days a week so hence the slow reply.

Well all I can think of is write script that loops through all the docs in your database.

For each document loop through the items on it and see if there are fields that start with invalid characters (or do not match a valid character ). Once you have found one you can either move that doc to a folder.

Once you have done all the docs you can check them in the folder and see what is going on, potentially.

You could write similar script that deletes those fields off the doc (if it is save to do so)