GuitarMan
Well Known Member
I was givin a requirement to create a facility to export text attachments to a custom table so that they could be exported to our data warehouse for use in Web Status display and other 3rd party services.
The BSFNs and UBE I created work fine to read through the F00165 for GT4201A and GT4915 type attachments, unencrypt them and write them to my custom tables.
I also placed a trigger on the F00165 to automatically write to these tables when a record is added or updated. Everything works fine in our lower environments but does not work correctly in Production. When the trigger is called, the lpBhvrCom comes into the code as NULL and the trigger fails. As I said, this does not happen in any of the lower environments.
Has anyone (Whipping Boy...) seen something like this before? I've rebuilt the trigger 3 times and still no change. Could there be some type of corruption in the table itself. All the functionality for attachments works correctly except for this trigger.
Any help or thoughts would be appreciated.
The BSFNs and UBE I created work fine to read through the F00165 for GT4201A and GT4915 type attachments, unencrypt them and write them to my custom tables.
I also placed a trigger on the F00165 to automatically write to these tables when a record is added or updated. Everything works fine in our lower environments but does not work correctly in Production. When the trigger is called, the lpBhvrCom comes into the code as NULL and the trigger fails. As I said, this does not happen in any of the lower environments.
Has anyone (Whipping Boy...) seen something like this before? I've rebuilt the trigger 3 times and still no change. Could there be some type of corruption in the table itself. All the functionality for attachments works correctly except for this trigger.
Any help or thoughts would be appreciated.