Transaction Create Date and Activity End Date
FRED.YY.LIN 林宥延 <[email protected]> Wed, 10 Mar 2010 14:09:02 +0800
| Newsgroups | gmane.comp.java.scarab.user |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_6457_22967500.1268201347978 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Dear all, =20 I move the linux system to another disk and restart again. unfortunately th= e system time slipped for 8 hours =20 2 days past away until I figured out the time of scarab was incorrect. =20 I tried to restore the correct time stamp in the data base and figured out = that 3 table recorded time value =20 Scarab_Activity table, in the End_Date column Scarab_Attachment table, modified date, created date Scarab_Transaction table, Created Date =20 =20 I figured out that the End_Date column differs from the Created Date of the= same TRANSACTION_ID in the Scarab Transaction table. =20 In one of my case, it differed for 4 days. =20 A transaction is composed of many activities of the same transaction_id, is= n't it ? =20 Does it normal that the Created_Date differ from the End_Date ? =20 Fred ***************************************************************************= ********************************************** This email message, including any attachments, is for the sole use of the i= ntended recipient(s) and may contain confidential and privileged informatio= n. Any unauthorized review, use, disclosure or distribution is prohibited. = If you are not the intended recipient, please contact the sender by reply e= -mail and destroy all copies of the original message. [Delta Electronic, IN= C. Taiwan] ***************************************************************************= ********************************************** ------------------------------------------------------ http://scarab.tigris.org/ds/viewMessage.do?dsForumId=3D456&dsMessageId=3D24= 57380 To unsubscribe from this discussion, e-mail: [[email protected]= is.org]. ------=_Part_6457_22967500.1268201347978 Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE></TITLE> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Dbig5"> <META content=3D"MSHTML 6.00.2900.3603" name=3DGENERATOR></HEAD> <BODY text=3D#000000 bgColor=3D#ffffff> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D9593= 50106-10032010>Dear=20 all,</SPAN></FONT></DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010></SPAN></FONT> </DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D9593= 50106-10032010>I move the=20 linux system to another disk and restart again. unfortunately the system ti= me=20 slipped for 8 hours</SPAN></FONT></DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010></SPAN></FONT> </DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D9593= 50106-10032010>2 days past=20 away until I figured out the time of scarab was=20 incorrect.</SPAN></FONT></DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010></SPAN></FONT> </DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D9593= 50106-10032010>I tried to=20 restore the correct time stamp in the data base and figured out that 3 tabl= e=20 recorded time value</SPAN></FONT></DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010></SPAN></FONT> </DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010>Scarab_Activity table, in the End_Date=20 column</SPAN></FONT></DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010>Scarab_Attachment table, modified date, created= =20 date</SPAN></FONT></DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010>Scarab_Transaction table, Created=20 Date</SPAN></FONT></DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010></SPAN></FONT> </DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010></SPAN></FONT> </DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D9593= 50106-10032010>I figured out=20 that the End_Date column differs from the Created Date of the same=20 TRANSACTION_ID in the Scarab Transaction table.</SPAN></FONT></DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010></SPAN></FONT> </DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D9593= 50106-10032010>In one of my=20 case, it differed for 4 days.</SPAN></FONT></DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010></SPAN></FONT> </DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D9593= 50106-10032010>A transaction=20 is composed of many activities of the same transaction_id, isn't it=20 ?</SPAN></FONT></DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010></SPAN></FONT> </DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D9593= 50106-10032010>Does it normal=20 that the Created_Date differ from the End_Date ?</SPAN></FONT></DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010></SPAN></FONT> </DIV> <DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20 class=3D959350106-10032010>Fred</SPAN></FONT></DIV></BODY></HTML> <table><tr><td bgcolor=3D#ffffff><font color=3D#000000>********************= ***************************************************************************= **************************<br> This email message, including any attachments, is for the sole use of the i= ntended recipient(s) and may contain confidential and privileged informatio= n. Any unauthorized review, use, disclosure or distribution is prohibited. = If you are not the intended recipient, please contact the sender by reply e= -mail and destroy all copies of the original message. [Delta Electronic, IN= C. Taiwan]<br> ***************************************************************************= **********************************************<br> </font></td></tr></table> ------=_Part_6457_22967500.1268201347978--