Why does DBConnect sometime index events that's lacking field value?

[phamxuantung]

This happen sometime on this DB and the only one that I experience this. The view, fields and value are pretty simple, my input also. But sometime it don't index certain fields that make it difficult to make statistical report.

I checked the view and they certainly have those fields and value but the events are lacking them

Another weird thing is some events are duplicate and some aren't. The events that are not duplicate is the one lacking fields.

I never seen this before and don't know how to resovle this.

[richgalloway]

Are you certain the fields are present in the DB?  DB Connect cannot fetch what is not there.

[phamxuantung]

Yes, I'm certain that the fields are present in the DB, does have value and not null. In fact, it cannot fetch what I specify it to fetch although that fields have values. 

[richgalloway]

Check the DBX logs for messages that might explain why the fields were not extracted.  Perhaps they contain bad characters or something like that (just guessing).