2 Replies Latest reply: Feb 29, 2012 4:01 AM by Matt Laurenceau RSS

Remedy Server hangs due to Appproval Pending Currupted Data

Mohanad K. Younis

Dears,

 

one of our clients face a strange hanging on the production server and after investigation we found the data stored in Application Pending form is currupted, after delete them it back to normal, we simulate the same again by re-import those data into application pending form and the issue raised again, can somebody help and tell us what is wrong in those data below. thanks in advance

 

 

CHAR-SET windows-1252

SCHEMA "Application Pending"

FIELDS "Assigned To" "Category" "Command" "Create Date" "Field ID 1" "Field ID 2" "Field ID 3" "Form" "Last Changed By" "Last Changed Time" "Other Long" "Other Short" "Pending ID" "Source ID" "Status" "Status-History" "Submitter" "Tag"

FLD-ID 4 8 501 3 505 506 507 502 5 6 509 508 1 503 7 15 2 504

DTYPES CHAR CHAR CHAR TIME INTEGER INTEGER INTEGER CHAR CHAR TIME CHAR CHAR CHAR CHAR ENUM CHAR CHAR CHAR

DATA "" "Approval" "Sig-Reassign" 1329119910 "" "" "" "AP:Signature" "Remedy Application Service" 1329119910 "0;" "a.rasheed" "000000001369358" "000000000079242" 0 "" "f.bakhashwain" ""

DATA "" "Approval" "Sig-Reassign" 1329119911 "" "" "" "AP:Signature" "Remedy Application Service" 1329119911 "0;" "a.rasheed" "000000001369359" "000000000079243" 0 "" "f.bakhashwain" ""

DATA "" "Approval" "Sig-Reassign" 1329119911 "" "" "" "AP:Signature" "Remedy Application Service" 1329119911 "0;" "a.rasheed" "000000001369360" "000000000084394" 0 "" "f.bakhashwain" ""

DATA "" "Approval" "Sig-Approved" 1329119917 "" "" "" "AP:Signature" "Remedy Application Service" 1329119917 "0;" "" "000000001369364" "000000000121418" 0 "" "w.baeisa" ""

DATA "" "Approval" "New-Details" 1329119928 2 "" "" "CHG:Infrastructure Change" "Remedy Application Service" 1329119928 "" "" "000000001369365" "CRQ000000057062" 0 "" "Remedy Application Service" "Change Level IA - Review"

DATA "" "Approval" "New-Details" 1329119975 2 "" "" "CHG:Infrastructure Change" "Remedy Application Service" 1329119975 "" "" "000000001369375" "CRQ000000056244" 0 "" "Remedy Application Service" "Change Level IA - Business"

DATA "" "Approval" "Sig-Approved" 1329119979 "" "" "" "AP:Signature" "Remedy Application Service" 1329119979 "0;" "" "000000001369376" "000000000121760" 0 "" "a.abdalwahab" ""

DATA "" "Approval" "Sig-Notify-State" 1329119988 "" 3 1 "AP:Signature" "Remedy Application Service" 1329119988 "" "" "000000001369377" "000000000079242" 0 "" "f.bakhashwain" ""

DATA "" "Approval" "Sig-Notify-State" 1329119988 "" 3 1 "AP:Signature" "Remedy Application Service" 1329119988 "" "" "000000001369378" "000000000079243" 0 "" "f.bakhashwain" ""

DATA "" "Approval" "Sig-Notify-State" 1329119989 "" 3 1 "AP:Signature" "Remedy Application Service" 1329119989 "" "" "000000001369379" "000000000084394" 0 "" "f.bakhashwain" ""

DATA "" "Approval" "Sig-Approved" 1329120017 "" "" "" "AP:Signature" "Remedy Application Service" 1329120017 "0;" "" "000000001369384" "000000000121761" 0 "" "a.abdalwahab" ""

DATA "" "Approval" "Sig-Approved" 1329120020 "" "" "" "AP:Signature" "Remedy Application Service" 1329120020 "0;" "" "000000001369387" "000000000121427" 0 "" "w.baeisa" ""

DATA "" "Approval" "New-Details" 1329120027 2 "" "" "CHG:Infrastructure Change" "Remedy Application Service" 1329120027 "" "" "000000001369390" "CRQ000000057063" 0 "" "Remedy Application Service" "Change Level IA - Review"

DATA "" "Approval" "Sig-Approved" 1329120043 "" "" "" "AP:Signature" "Remedy Application Service" 1329120043 "0;" "" "000000001369398" "000000000113765" 0 "" "m.hussain" ""

DATA "" "Approval" "New-Details" 1329120044 "" "" "" "SRM:Request" "Remedy Application Service" 1329120044 "" "" "000000001369400" "000000000108647" 0 "" "w.alharbi" "Service Request - Management Chain"

DATA "" "Approval" "Sig-Approved" 1329120046 "" "" "" "AP:Signature" "Remedy Application Service" 1329120046 "0;" "" "000000001369402" "000000000121714" 0 "" "b.alshaikh" ""

DATA "" "Approval" "Sig-Approved" 1329120046 "" "" "" "AP:Signature" "Remedy Application Service" 1329120046 "0;" "" "000000001369403" "000000000121863" 0 "" "b.alshaikh" ""

DATA "" "Approval" "Add-Sig" 1329120052 0 999 "" "CHG:Infrastructure Change" "Remedy Application Service" 1329120052 "" "m.zakaullah" "000000001369404" "CRQ000000056917" 0 "" "m.mohiuddin.bmc" "Change Level IA - Review"

DATA "" "Approval" "Sig-Approved" 1329120056 "" "" "" "AP:Signature" "Remedy Application Service" 1329120056 "0;" "" "000000001369406" "000000000121762" 0 "" "a.abdalwahab" ""

DATA "" "Approval" "Sig-Approved" 1329120056 "" "" "" "AP:Signature" "Remedy Application Service" 1329120056 "0;" "" "000000001369407" "000000000121855" 0 "" "b.alshaikh" ""

DATA "" "Approval" "Sig-Approved" 1329120080 "" "" "" "AP:Signature" "Remedy Application Service" 1329120080 "0;" "" "000000001369409" "000000000121764" 0 "" "a.abdalwahab" ""

DATA "" "Approval" "Sig-Approved" 1329120109 "" "" "" "AP:Signature" "Remedy Application Service" 1329120109 "0;" "" "000000001369417" "000000000121763" 0 "" "a.abdalwahab" ""

DATA "" "Approval" "Sig-Approved" 1329120137 "" "" "" "AP:Signature" "Remedy Application Service" 1329120137 "0;" "" "000000001369421" "000000000121766" 0 "" "a.abdalwahab" ""

DATA "" "Approval" "New-Details" 1329120152 1 "" "" "CHG:Infrastructure Change" "Remedy Application Service" 1329120152 "" "" "000000001369423" "CRQ000000056218" 0 "" "Remedy Application Service" "Change Level IA - Business"

DATA "" "Approval" "Sig-Approved" 1329120161 "" "" "" "AP:Signature" "Remedy Application Service" 1329120161 "0;" "" "000000001369426" "000000000121767" 0 "" "a.abdalwahab" ""

DATA "" "Approval" "New-Details" 1329120195 2 "" "" "CHG:Infrastructure Change" "Remedy Application Service" 1329120195 "" "" "000000001369438" "CRQ000000057064" 0 "" "Remedy Application Service" "Change Level IA - Review"

DATA "" "Approval" "New-Details" 1329120204 2 "" "" "CHG:Infrastructure Change" "Remedy Application Service" 1329120204 "" "" "000000001369443" "CRQ000000049045" 0 "" "Remedy Application Service" "Change Level IA - Business"

DATA "" "Approval" "New-Details" 1329120244 "" "" "" "SRM:Request" "Remedy Application Service" 1329120244 "" "" "000000001369448" "000000000108656" 0 "" "a.shah" "Service Request - Management Chain"

DATA "" "Approval" "Sig-Approved" 1329120250 "" "" "" "AP:Signature" "Remedy Application Service" 1329120250 "0;" "" "000000001369451" "000000000115735" 0 "" "a.rosyadi" ""