To clarify (and to restate the followup posting I made on the originally-quoted thread by me)... Patch 020 DOES impact some Solaris/Oracle servers, but does not completely BREAK the functionality. here is what happens, and happened on everyone one of our servers (dev and production)... Evidently, the upgrade works fine, but corrupts two forms or their associated linkage in the process. 1. Installation of 6.03.00 patch 020 takes place without incident. 2. Install the "test" def file posted in the original message (simply files a filter upon submission of a ticket that performs a calculation using the Business Time Dif function). 3. Run a test by submitting a record. 4. On our servers, every time, submission of that record, and the subsequent filter action involving the business time calculation, caused an error/failure. 5. Solution (from Remedy support): backup the data in the 2 business time calculation forms (Business Time Workday and Business Time Holiday). 6. Drop/delete both forms completely (and, of course, associated workflow in doing so). 7. Re-import clean versions of both forms and related workflow from a def file supplied by Remedy Support. 8. Re-import records to the two forms via import tool 9. Re-run test (all our servers passed). Issue solved. Our environment: Solaris 8 (dev lab included a Solaris 9), Oracle 9i (9.2.0). Hope this helps anyone else who runs into this.
Raymond H. Gellenbeck EDS Navy Marine Corps Intranet (NMCI) Remedy Engineering NMCI - Leveraged Delivery 3970 Sherman Street | San Diego, CA 92110 Office: +1 619 817 3223 [EMAIL PROTECTED] [EMAIL PROTECTED] Hall Chad - chahal <[EMAIL PROTECTED]> wrote: Well, BMC was right on this one. Patch 20 actually did fix the DST issues. We found out the hard way that the OS on our server and desktops had not been patched like we thought they had. Everything works fine as long as the OS (server & desktop), AR Server, AR User, and Java have all been patched. So, sorry for the false alarm on this one... Chad Hall (501) 342-2650 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hennigan, Sandra H CTR OSD-CIO Sent: Friday, February 16, 2007 12:34 PM To: [email protected] Subject: Re: Older Business time process broken by patch 020? (U) UNCLASSIFIED Very interesting. I brought this up to Remedy Support and was told, "There are no open DST issues with Application-Bus-Time and Patch 20 and currently there are no open defects related to this" Sandra Hennigan OSD Remedy Administrator Office # 703-602-2525 x251 CACI - Ever Vigilant(tm) Apparently, there is nothing that cannot happen today. Mark Twain -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Friday, February 16, 2007 10:54 AM To: [email protected] Subject: Re: Older Business time process broken by patch 020? ** FYI... This appears to also be a bug in Application-Bus-Time-Add and Application-Bus-Time-Subtract on 6.3 patch 20. After initially reading this email I assumed it only applied to Application-Bus-Time-Diff, but I did my own testing and all three of these functions are an hour off if you use a timestamp that falls in the new DST range. We've opened a ticket with BMC on this but haven't heard anything yet. This will be a huge problem for us. On a slightly related note - Email Engine patch 20 will generate outbound emails with timestamps that are an hour off if you include timestamp fields within the body of your emails. You might want to be aware of that as well. Chad Hall (501) 342-2650 _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ray Gellenbeck Sent: Thursday, February 01, 2007 4:09 PM To: [email protected] Subject: Older Business time process broken by patch 020? ** WARNING: We (BMC support eng and I) believe we may have found a new issue with the latest patch (020). In fixing the DST bug, they may have affected (broke) an older process. Process name Application-Bus-Time-Diff appears to now be broken. If you want to test the process yourself, I have included the def file here. simply copy the block of code below and paste it into a notepad file. If you open the form +SS:Test, enter any characters into the character field and hit save, the process attempts to perform a calculation. On our 6.0.1 servers, it passed. On a 6.03.00 patch 020 server, it results in a popup "ARERROR [639] No Workday form could be found on the server" Good luck, and if anyone else out there has run into this, PLEASE let me know at [EMAIL PROTECTED] or [EMAIL PROTECTED] ---start of def file text---- char-set: windows-1252 # # File exported Thu Feb 01 12:21:06 2007 # begin schema name : +SS:Test core-version : 2 upgrade-version: 0 num-fields : 10 timestamp : 1170361039 owner : Demo last-changed : Demo default-vui : Default Admin View num-vuis : 1 export-version : 8 schema-type : 1 next-field-id : 536870914 archive : 0\0\0 arch-time : 0\0\0\0 arch-from : vui { id : 536870912 name : Default Admin View label : Default Admin View timestamp : 1170360857 vui-locale : vui-type : 1 owner : Demo last-changed : Demo display-prop : 5\20\4\18\Default Admin View\264\6\0\60019\4\21\ViewWebAlias536870912\201\2\93375\202\2\57500\ } field { id : 1 name : Request ID datatype : 4 fieldtype : 1 create-mode : 2 option : 3 timestamp : 1170360858 owner : Demo last-changed : Demo maxlength : 15 menu-style : 2 qbe-match-op : 1 fulltext-optns : 0 permission : 0\1 permission : 3\1 permission : 4\1 display-instance : 536870912\16\20\4\10\Request ID\61\40\18\60\40\1\3\41\2\1012\2500\19799\4900\4\6\1\28\6\4\29\6\1\27\8 \16\7\40\2147483640\231\6\0\143\40\4294967295\21\41\2\0\& display-instance : 400\6862\2400\151\41\2\7425\0\18787\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0 \170\40\0\ } field { id : 2 name : Submitter datatype : 4 fieldtype : 1 create-mode : 1 option : 1 timestamp : 1170360956 owner : Demo last-changed : Demo maxlength : 30 menu-style : 2 qbe-match-op : 1 fulltext-optns : 0 default : $-1$ permission : 3\1 permission : 4\1 display-instance : 536870912\16\20\4\9\Submitter\61\40\30\60\40\1\3\41\2\1012\5000\26099\72 00\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483641\231\6\0\143\40\4294967295 \21\41\2\0\40& display-instance : 0\6075\2200\151\41\2\6637\0\25087\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\1 70\40\0\ } field { id : 3 name : Create Date datatype : 7 fieldtype : 1 create-mode : 2 option : 3 timestamp : 1170360857 owner : Demo last-changed : Demo permission : 3\1 permission : 4\1 display-instance : 536870912\16\20\4\11\Create Date\61\40\23\60\40\1\3\41\2\1012\7500\26212\9800\4\6\1\28\6\4\29\6\1\27 \8\16\7\40\2147483642\231\6\0\143\40\4294967295\170\40\0\& display-instance : 21\41\2\0\400\7200\2300\151\41\2\7762\0\22162\2100\65\41\2\0\0\0\0\66\41 \2\22837\0\25199\2100\ } field { id : 4 name : Assigned To datatype : 4 fieldtype : 1 create-mode : 2 option : 2 timestamp : 1170360857 owner : Demo last-changed : Demo maxlength : 30 menu-style : 2 qbe-match-op : 1 fulltext-optns : 0 permission : 4\1 display-instance : 536870912\16\20\4\11\Assigned To\61\40\30\60\40\1\3\41\2\1012\10000\26212\12100\4\6\1\28\6\4\29\6\1\27 \8\16\7\40\2147483643\231\6\0\143\40\4294967295\21\41\2& display-instance : \0\400\6637\2100\151\41\2\7200\0\25200\2100\65\41\2\0\0\0\0\66\41\2\0\0\ 0\0\170\40\0\ } field { id : 5 name : Last Modified By datatype : 4 fieldtype : 1 create-mode : 2 option : 3 timestamp : 1170360857 owner : Demo last-changed : Demo maxlength : 30 menu-style : 2 qbe-match-op : 1 fulltext-optns : 0 permission : 4\1 display-instance : 536870912\16\20\4\16\Last Modified By\61\40\33\60\40\1\3\41\2\1012\12500\31162\14800\4\6\1\28\6\4\29\6\1\27 \8\16\7\40\2147483644\231\6\0\143\40\4294967295\21& display-instance : \41\2\0\400\9562\2300\151\41\2\10125\0\30150\2100\65\41\2\0\0\0\0\66\41\ 2\0\0\0\0\170\40\0\ } field { id : 6 name : Modified Date datatype : 7 fieldtype : 1 create-mode : 2 option : 3 timestamp : 1170360857 owner : Demo last-changed : Demo permission : 4\1 display-instance : 536870912\16\20\4\13\Modified Date\61\40\23\60\40\1\3\41\2\1012\15000\26999\17300\4\6\1\28\6\4\29\6\1\ 27\8\16\7\40\2147483645\231\6\0\143\40\4294967295\170\4& display-instance : 0\0\21\41\2\0\400\8212\2300\151\41\2\8775\0\22950\2100\65\41\2\0\0\0\0\6 6\41\2\23625\0\25987\2100\ } field { id : 7 name : Status datatype : 6 fieldtype : 1 create-mode : 2 option : 1 timestamp : 1170360858 owner : Demo last-changed : Demo enum-value : New enum-value : Assigned enum-value : Fixed enum-value : Rejected enum-value : Closed default : 0 permission : 3\1 permission : 4\2 display-instance : 536870912\18\20\4\6\Status\64\6\1\61\40\0\60\40\1\3\41\2\1012\17500\3588 7\19400\4\6\1\28\6\4\29\6\1\27\8\16\7\40\2147483646\231\6\0\230\4\46\5\0 \New\1\Assign& display-instance : ed\2\Fixed\3\Rejected\4\Closed\143\40\4294967295\21\41\2\0\400\4162\1900 \151\41\2\4725\400\34875\1800\65\41\2\0\0\0\0\66\41\2\0\0\0\0\170\40\0\ } field { id : 8 name : Short Description datatype : 4 fieldtype : 1 create-mode : 1 option : 1 timestamp : 1170360954 owner : Demo last-changed : Demo maxlength : 254 menu-style : 2 qbe-match-op : 1 fulltext-optns : 0 default : x permission : 3\1 permission : 4\1 display-instance : 536870912\16\20\4\17\Short Description\61\40\50\60\40\1\3\41\2\1012\20000\45224\22100\4\6\1\28\6\4\ 29\6\1\27\8\16\7\40\2147483647\231\6\0\143\40\4294967295\2& display-instance : 1\41\2\0\400\11137\2100\151\41\2\11700\0\41287\2100\65\41\2\0\0\0\0\66\4 1\2\41850\0\44212\2100\170\40\0\ } field { id : 15 name : Status History datatype : 4 fieldtype : 1 create-mode : 2 option : 3 timestamp : 1170360856 owner : Demo last-changed : Demo permission : 3\1 permission : 4\1 } field { id : 536870913 name : Character Field datatype : 4 fieldtype : 1 create-mode : 2 option : 2 timestamp : 1170361039 owner : Demo last-changed : Demo maxlength : 255 menu-style : 2 qbe-match-op : 1 fulltext-optns : 0 permission : 0\2 display-instance : 536870912\18\14\40\1\170\40\0\20\4\15\Character Field\3\41\2\7087\26200\64124\28300\4\6\1\5\6\2\60\40\1\61\40\79\27\8\16 \28\6\4\29\6\1\7\40\2147483648\231\6\& display-instance : 0\143\40\4294967295\21\41\2\0\400\7987\2100\151\41\2\8100\0\54112\2100\6 5\41\2\0\0\0\0\66\41\2\54675\0\57037\2100\ } end begin filter name : +SS:SetApplicationBusinessTime timestamp : 1170361141 owner : Demo last-changed : Demo filter-op : 4 enable : 1 filter-order : 500 wk-conn-type : 1 schema-name : +SS:Test export-version : 8 filter-query : 4\1\2\2\1\2\2\1\ action { set-field : 0\536870913\103\73\Application-Bus-Time-Diff "1170403200" "1170489600" "24HrsTag" "24HrsTag"\ } end _____ Expecting? Get great news right away with email Auto-Check. ilbeta/newmail_tools.html> Try the Yahoo! Mail Beta. ilbeta/newmail_tools.html> __20060125_______________________This posting was submitted with HTML in it___ ************************************************************************ *** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ************************************************************************ **** __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" --------------------------------- Have a burning question? Go to Yahoo! Answers and get answers from real people who know. --------------------------------- Never miss an email again! Yahoo! Toolbar alerts you the instant new Mail arrives. Check it out. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
