Clem Padin 3.Apr.15 11:39 AM a Web browser LC LSX LC LSX - All Releases Windows
Been experiencing an odd problem. I had a Notes-to-postres interface working fine for quite a while. We wanted to refresh the postres table so I shut the data transfer agent down, we cleared out the table and restarted the agent. It started to fail. It was returning 'invalid field' errors on the odbc LCfieldList.MapName call. I checked everything I could think of and then I noticed that there weren't enough fields in the source list argument. That source list argument is a LCFieldList object loaded by a LCConnector.select call to the Notes db. I checked that and noticed that out of the 98 fields which the select should have returned, it was only returning 46!
I did make a security change to the Notes db (hiding/exposing a couple of fields and several buttons depending on Notes roles) so I thought perhaps that had something to do with it so I made sure that the agent signer + server has manager rights to the database but that didn't make a difference.
Does anyone know how the LCConnector.select determines what fields it will accept or what would cause something like this?
I attempted a work-around by constructing the MapName's source list, specifying the fields and types to be selected but then it failed on the Notes LCConnection fetch complaining that "Field type mismatch: '<field name>' Source Connector field is type Text, Target Connector field is type Datetime". And that doesn't make sense since I did specify the correct field type this date/time Notes field.