Designer - Missing fields in Full Text Index Rules

Hi,

We recently started using the "Ignore Fields" option for full text index. It does work amazingly well but I noticed that for one critical application, the list of fields was not complete. I couldn't find the fields I want to exclude in the list while the same are available for a different application. Any insights into this?

Thanks in advance.

Satish.

Hi Satish

See by enabling 'Allow more fields in database' under advanced properties and check.

Regards

Sudhakar

Hi Sudhakar,

That property is enabled for us by default for all applications.

Thanks,

Satish.

Hello,

Are those fields created programmatically?. if yes, it will not display in the Full Text Index Rule to exclude Fields in the designer client[current versions]. You may use any other way to exclude those files.

Thanks

Hi Sooraj,

They are not created programmatically but rather normally. I just created another field manually by using Create --> Field in the same application but even that is missing.

Thanks,

Satish.

Hi,

In that case, I would be recommended to create a case with HCL support to investigate the issue along with the sample database.

You can also follow the workaround:-

Create a file called fldrule.txt and place it in the Domino Program directory.

The content of the fldrule.txt should be

-> For a single database

IGNORE DATABASE test.nsf FIELDNAME username
IGNORE DATABASE test.nsf FIELDNAME password
IGNORE DATABASE test.nsf FIELDNAME address
IGNORE DATABASE test.nsf FIELDNAME Location

-> For multiple databases that have similar field names

IGNORE FIELDNAME username
IGNORE FIELDNAME password
IGNORE FIELDNAME address
IGNORE FIELDNAME Location

=> Restart the Domino and redo the FTI.

Thanks Sooraj, I'll pursue the issue through a ticket. Maintaining these fields in a text file is not feasible as they are a huge number and also restarting Domino is not possible at this point of time.

Satish.

@Satish Bolla

Suppose you expect to see a field "UsrNm" in this "Full Text Index Rules" list.

You are not able to see this field. That's the issue with only one of the specific application using DDE.

Is it like you can see this field at FORM level by checking on "Fields" tab as mentioned in below screenshot?
Also, when you say that issue is not appearing for other application, so is it correct to assume those applications are being opened via same DDE?

Regards,

Amit Sharma

Hi Amit,

Yes, you are right, we are using the same DDE to view all the applications. Regarding your query about the fields being visible at the form level, I'm able to view those fields. Below are the various screenshots.

Missing the PConcern fields in the Full Text Index rules:

Thanks,

Satish.

In that case, I request to create a Support case and if possible along with design only copy of impacted database. It would be tough to troubleshoot via this thread.

Might need to analyse that specific DB of yours.

Additional Information -->

Couple of troubleshooting I would recommend.

TROUBLESHOOTING ONE -->

1. Create a new sample database on LOCAL.

2. Copy the FORM from impacted database to this new database.

3. Now, see if issue still persists in this new locally created notes database or not.

TROUBLESHOOTING ONE -->

How about the same impacted DB being opened by some other user or same user using DDE installed on another machine (not the current one)? Is issue appearing there as well.

You can share the outcome of these troubleshooting while creating the case itself as well.

Regards,

Amit

Hi Amit,

I made a copy of this application on both local machine and on the same server and found that these fields are appearing in the Full Text Index rules of both the copies. I need to check about the other machine as the others in the team still have V11 Designer installed. Probably I'll try updating them tomorrow.

Thanks,

Satish.

Well as per your update, it seems by creating a new copy of this application (on Local or Server), the issue is getting resolved on same machine.

So, that means there is something for sure with existing copy of this database.

Regards,

Amit Sharma