203 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
Appending MIME item to NotesRichTextItem
Mon, Aug 7th 2017 3
Strange decision within IBM Verse update for June of 2017 on Android devices
Mon, Jun 12th 2017 5
The application requires com.ibm.xsp.extlibx.library. This library cannot be found.
Wed, May 24th 2017 8
Great news about BM Notes/Domino 9.0.1 Feature Pack 8
Fri, Jan 27th 2017 7
How to set Workspace as default homepage in IBM Notes client
Wed, Oct 26th 2016 10
Avoid processing items as both NotesItem and NotesMIMEEntity objects concurrently.
Thu, Jul 21st 2016 4
Third level in "Application links" section of Xpages Application Layout, WTF?
Sat, Jul 16th 2016 6
Top 10
IBM Lotus Notes and Ctrl+Break on new laptops without button "Pause/Break" on keyboard. Is it familiar to you? :-)
Thu, May 29th 2014 10
NotesAgent.Runwithdocumentcontext() - cool thing
Thu, May 29th 2014 10
How to implement "Totals" with Data View control
Fri, Sep 11th 2015 10
How to set Workspace as default homepage in IBM Notes client
Wed, Oct 26th 2016 10
How to focus Lotus Notes window (standard version)
Wed, Dec 17th 2014 9
@NameLookup() - how to exclude local Directories from lookup?
Tue, Jul 8th 2014 9
No such session or session has been closed
Sun, Nov 2nd 2014 8
Corrupted unread list in Mail database caused "This database cannot be read due to an invalid on disk structure"
Thu, Jul 17th 2014 8
A question: do you know how to disable/remove/cleanup Xpages tooltips in Domino Designer? They make me crazy.
Fri, Sep 11th 2015 8
The application requires com.ibm.xsp.extlibx.library. This library cannot be found.
Wed, May 24th 2017 8


How to force UNK table to "see" required type of a field (to use it in FTSearch, for example)
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
   

Hi

If you work with Full-Text search a lot you could get into situation when your database considers field type incorrectly, f.x. it may recognize some field as a number when it is actually a text on a Form so you can't use FT-query like [FieldName]=*partOfText*. Usually it happens when you change field type on a form but your database already contains documents with items based on old-type-fields.

Though IBM knowledge base provides suggestions how to fix such issues it's rather tricky thing to fix. At least the steps suggested by IBM had never worked for me - I mean deleting FT-index and then copy-style compacting. However I found my own. Here is the magic formula...



1) Create a "replica header" of a target database. I use words "replica header" just because I do not know how else to call it. I mean a replica that is created after you disable checkbox "Create immediately"

2) Create a blank template database and replace design of your replica-header to make it initialized


3) Open your initialized blank replica in Domino Designer, create any form, add there field(s) which types were recognized incorrectly earlier, create a single document based on this form and then create Full-text index for this replica. This time full-text index will be created correctly.



4) Replicate your blank replica with the full replica so all documents and design elements will get to your replica with correct full-text index.

5) Do final steps:
- remove test form and test document
- restore database launch options or any other database properties (should be fast and easy)
- remove old replica and start using new one.











---------------------
http://ypastov.blogspot.com/2015/05/how-to-force-unk-table-to-see-required.html
May 23, 2015
7 hits



Recent Blog Posts
3
Appending MIME item to NotesRichTextItem
Mon, Aug 7th 2017 1:59p   Yuriy Pastovenskyy
Hi guys May be this will save someone's day. The story: Some external UI posts HTML-data to Notes. That HTML has to be added to NotesRichtextItem. 1) When I tested simple case manually all worked OK: 1.1) Here is my Notes form 1.2) I put some data in Notes document and save it 1.3) Then I run an agent over this document with code like Sub Initialize Dim s As New NotesSession Dim doc As NotesDocument Dim rt1 As NotesRichTextItem Dim rt2 As NotesRichTextItem Set doc = s.Documentconte
5
Strange decision within IBM Verse update for June of 2017 on Android devices
Mon, Jun 12th 2017 3:41p   Yuriy Pastovenskyy
Hi IBM released a new update for IBM Verse in June 2017 - here is a link to "what's new". There is a new feature for Android about: Verse for Android: Certificate-based authentication However I don't think the way it works is correct. See my story below... Accordingly to documentation there are three authentication options supported by IBM Verse on Android devices: Traditional username/passwordCertificate-only authenticationCertificate and username/passwordOne of my customers had a foll
8
The application requires com.ibm.xsp.extlibx.library. This library cannot be found.
Wed, May 24th 2017 5:26p   Yuriy Pastovenskyy
Hi I want to share one strange thing that happened to me today. I have reinstalled IBM Notes 9.01 but did it a bit unusually: 1) I uninstalled IBM Notes and cleaned up all files and folders which usually stay after uninstallation. 2) Then I installed IBM Notes 9.01 and FP7 but when I wanted to install Extension Library from openntf.org I realized that I forgot to enable Domino Designer and Domino Administrator options during setup. So I run installer again, chose option "Modify", enabled Do
7
Great news about BM Notes/Domino 9.0.1 Feature Pack 8
Fri, Jan 27th 2017 3:22p   Yuriy Pastovenskyy
Notes/Domino Fix List (Copied from here) IBM Notes/Domino 9.0.1 Feature Pack 8 Preliminary Release Notice January 27, 2017 Beginning with 9.0.1 FP8, fix packs have been renamed to feature packs. To ensure quality, these feature packs still have a high focus on addressing high impacting defects. Where possible, these features are optional enabled to minimize risk. The same packaging, architecture and install kits used in previous fix packs remain in use for feature packs. IBM has identified im




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition