Hey all,
FYI for anyone upgrading to 7.6.04 The upgrade process nor DDM will catch work-info notes where detailed description (notes) is null. In our case many users made work-info notes and just typed a quick summary and nothing in the notes (detailed description). In 7.6.04 BMC only use detailed description and do a left 100 char to insert into description (summary) for new entries. Well that doesn't help those existing entries where user has not entered work-info detailed description and therefore the work-info tables show a null line. We had to issue a sql update to fix: update HPD_WorkLog set Detailed_Description = Description where Detailed_Description is null; update PBM_Investigation_WorkLog set Detailed_Description = Description where Detailed_Description is null; update CHG_WorkLog set Detailed_Description = Description where Detailed_Description is null; update WOI_WorkInfo set Detailed_Description = Description where Detailed_Description is null; Regards, Andrew C. Goodall Software Engineer Development Services [email protected] jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com <font face="monospace"size="-3"><br>The information transmitted is intended only for the person or entity to which it is addressed and <br>may contain confidential and/or privileged material. If the reader of this message is not the intended<br>recipient, you are hereby notified that your access is unauthorized, and any review, dissemination,<br>distribution or copying of this message including any attachments is strictly prohibited. If you are not<br>the intended recipient, please contact the sender and delete the material from any computer.<br> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
