Greetings. We have a client that upgraded to PxPlus 2019 Update 2 a few months ago. Before their upgrade, we had been successfully using data mirroring to push their data to a SQL server. We have an AR file for them where the key is Customer + Invoice Number + Invoice Type. Invoice Type is a single character element, and it can be a blank space. (In fact, it frequently is; the ones with alphanum in it are less common.)
When the record is new, the mirroring/insert works fine, for any invoice record.
But when it is updating an existing record, the mirroring/update does not result in the table getting the updated data...if the record's Invoice Type is a blank. If the Type has an alphanum in it, it successfully updates the SQL table.
We have not gotten to the point yet of trying to step through it because of the complexity and the timeframe to dig down into it. And I'm not sure if watching our PxPlus command of write(channel) will tell us anything. Does this information trigger any sort of "aha!" explanation? TIA.