Test Incident
Jump to navigation
Jump to search
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE Incidents SYSTEM "http://xfracassqlvm/8/DTD/Incident.dtd"[]> <Incidents xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ExportData>
<ReportGenerated>08/30/2013 09:07 AM</ReportGenerated>
<GeneratedBy>
<FirstName>ALEXANDER</FirstName>
<LastName>BEHLEN</LastName>
<Login>RELIASOFT\ABEHLEN</Login>
</GeneratedBy>
<GMTOffset>-7</GMTOffset>
</ExportData>
<Incident>
<IncidentID>FR-I-3744</IncidentID>
<Title>DIU Resource Update</Title>
<Entity>
<EntityID>1</EntityID>
<EntityName>XFRACAS Software</EntityName>
</Entity>
<Creator>
<FirstName>ALEXANDER</FirstName>
<LastName>BEHLEN</LastName>
<Login>RELIASOFT\ABEHLEN</Login>
</Creator>
<Owner>
<FirstName>ROOSEVELT</FirstName>
<LastName>JOHNSON</LastName>
<Login>RELIASOFT\RJOHNSON</Login>
</Owner>
<AssignedProblems>
<ProblemID>QTMS-78</ProblemID>
</AssignedProblems>
<Type>
<Issue IssueTypeID="20">
<Description>Simple Incident</Description>
</Issue>
</Type>
<ASPFieldServiceTech>
<FirstName />
<LastName />
</ASPFieldServiceTech>
<OccurrenceDate>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>5</Minute>
<Second>0</Second>
<FormattedDate>04/12/2013 09:05 AM</FormattedDate>
</OccurrenceDate>
<CreatedDate>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>7</Minute>
<Second>52</Second>
<FormattedDate>04/12/2013 09:07 AM</FormattedDate>
</CreatedDate>
<CloseDate />
<ResponseTime />
<DownTimeForService />
<RepairDurationTime />
<CustomerSupportNumber />
<ResponsibleParts>
<ResponsiblePart>
<Part>
<PartID>1305</PartID>
<PartName>Import XML</PartName>
<PartNumber>Import</PartNumber>
<PartVersion />
<RetiredDate />
</Part>
<ResponsibleUser />
</ResponsiblePart>
</ResponsibleParts>
<Chargeable>Yes</Chargeable>
<UnderWarranty />
<WarrantyOverride />
<CustomerRequestedFeedback>No</CustomerRequestedFeedback>
<ServiceResponseDate />
<Address />
<Statuses>
<Status>
<Issue IssueTypeID="8">
67
<Description>Submitted for Translation</Description>
</Issue>
<Date>
<Year>2013</Year>
<Month>4</Month>
<Day>16</Day>
<Hour>21</Hour>
<Minute>36</Minute>
<Second>33</Second>
<FormattedDate>04/16/2013 02:36 PM</FormattedDate>
</Date>
<UpdatedBy>
<FirstName>GEORGANA</FirstName>
<LastName>FERNANDEZ</LastName>
<Login>RELIASOFT\GFERNANDEZ</Login>
</UpdatedBy>
<Retired>No</Retired>
</Status>
<Status>
<Issue IssueTypeID="8">
01
<Description>Open/New</Description>
</Issue>
<Date>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>7</Minute>
<Second>52</Second>
<FormattedDate>04/12/2013 09:07 AM</FormattedDate>
</Date>
<UpdatedBy>
<FirstName>ALEXANDER</FirstName>
<LastName>BEHLEN</LastName>
<Login>RELIASOFT\ABEHLEN</Login>
</UpdatedBy>
<Retired>Yes</Retired>
</Status>
<Status>
<Issue IssueTypeID="8">
46
<Description>Under Initial DBA</Description>
</Issue>
<Date>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>12</Minute>
<Second>13</Second>
<FormattedDate>04/12/2013 09:12 AM</FormattedDate>
</Date>
<UpdatedBy>
<FirstName>ALEXANDER</FirstName>
<LastName>BEHLEN</LastName>
<Login>RELIASOFT\ABEHLEN</Login>
</UpdatedBy>
<Retired>Yes</Retired>
</Status>
<Status>
<Issue IssueTypeID="8">
46
<Description>Under Initial DBA</Description>
</Issue>
<Date>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>47</Minute>
<Second>1</Second>
<FormattedDate>04/12/2013 09:47 AM</FormattedDate>
</Date>
<UpdatedBy>
<FirstName>ALEXANDER</FirstName>
<LastName>BEHLEN</LastName>
<Login>RELIASOFT\ABEHLEN</Login>
</UpdatedBy>
<Retired>Yes</Retired>
</Status>
<Status>
<Issue IssueTypeID="8">
47
<Description>Initial DBA Completed</Description>
</Issue>
<Date>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>34</Minute>
<Second>40</Second>
<FormattedDate>04/12/2013 09:34 AM</FormattedDate>
</Date>
<UpdatedBy>
<FirstName>GEORGANA</FirstName>
<LastName>FERNANDEZ</LastName>
<Login>RELIASOFT\GFERNANDEZ</Login>
</UpdatedBy>
<Retired>Yes</Retired>
</Status>
<Status>
<Issue IssueTypeID="8">
48
<Description>Code Complete - Updating Test Scripts</Description>
</Issue>
<Date>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>49</Minute>
<Second>9</Second>
<FormattedDate>04/12/2013 09:49 AM</FormattedDate>
</Date>
<UpdatedBy>
<FirstName>ALEXANDER</FirstName>
<LastName>BEHLEN</LastName>
<Login>RELIASOFT\ABEHLEN</Login>
</UpdatedBy>
<Retired>Yes</Retired>
</Status>
<Status>
<Issue IssueTypeID="8">
50
<Description>Submitted for Testing</Description>
</Issue>
<Date>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>21</Hour>
<Minute>3</Minute>
<Second>32</Second>
<FormattedDate>04/12/2013 02:03 PM</FormattedDate>
</Date>
<UpdatedBy>
<FirstName>GEORGANA</FirstName>
<LastName>FERNANDEZ</LastName>
<Login>RELIASOFT\GFERNANDEZ</Login>
</UpdatedBy>
<Retired>Yes</Retired>
</Status>
<Status>
<Issue IssueTypeID="8">
60
<Description>Under Database PVC</Description>
</Issue>
<Date>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>22</Hour>
<Minute>54</Minute>
<Second>33</Second>
<FormattedDate>04/12/2013 03:54 PM</FormattedDate>
</Date>
<UpdatedBy>
<FirstName>DAVE</FirstName>
<LastName>ROCK</LastName>
<Login>RELIASOFT\ADMIN101</Login>
</UpdatedBy>
<Retired>Yes</Retired>
</Status>
</Statuses>
<Categories>
<Category>
<Issue IssueTypeID="20">
<Description>Functionality</Description>
</Issue>
<Date>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>7</Minute>
<Second>52</Second>
<FormattedDate>04/12/2013 09:07 AM</FormattedDate>
</Date>
<UpdatedBy>
<FirstName>ALEXANDER</FirstName>
<LastName>BEHLEN</LastName>
<Login>RELIASOFT\ABEHLEN</Login>
</UpdatedBy>
<Retired>No</Retired>
<Chargeable>Yes</Chargeable>
</Category>
</Categories>
<ReportTypes>
<ReportType>
<Issue IssueTypeID="38">
<Description>Prerelease or Staging</Description>
</Issue>
<Date>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>7</Minute>
<Second>52</Second>
<FormattedDate>04/12/2013 09:07 AM</FormattedDate>
</Date>
<UpdatedBy>
<FirstName>ALEXANDER</FirstName>
<LastName>BEHLEN</LastName>
<Login>RELIASOFT\ABEHLEN</Login>
</UpdatedBy>
<Retired>No</Retired>
</ReportType>
</ReportTypes>
<TimeMetric>
<ItemOrder>0</ItemOrder>
</TimeMetric>
<RepairReplaces />
<ActualCriticality>0</ActualCriticality>
<PotentialCriticality>0</PotentialCriticality>
<Criticalities />
<TeamMembers>
<TeamMember>
<MemberUser>
<FirstName>ALEXANDER</FirstName>
<LastName>BEHLEN</LastName>
<Login>RELIASOFT\ABEHLEN</Login>
</MemberUser>
<MemberRole>
<Issue IssueTypeID="50">
<Description>Programming</Description>
</Issue>
</MemberRole>
</TeamMember>
<TeamMember>
<MemberUser>
<FirstName>GEORGANA</FirstName>
<LastName>FERNANDEZ</LastName>
<Login>RELIASOFT\GFERNANDEZ</Login>
</MemberUser>
<MemberRole>
<Issue IssueTypeID="50">
<Description>DB Administrator</Description>
</Issue>
</MemberRole>
</TeamMember>
</TeamMembers>
<Actions />
<Details>
<Detail>
<DetailTypeID>772</DetailTypeID>
<DisplayOrder>2</DisplayOrder>
<DetailStep>1</DetailStep>
<DetailSpan>No</DetailSpan>
<DetailUIType>RadioButtonsYesNoDetail</DetailUIType>
<DetailName>PO Required</DetailName>
<RadioYesNo>
<Value>no</Value>
</RadioYesNo>
</Detail>
<Detail>
<DetailTypeID>814</DetailTypeID>
<DisplayOrder>4</DisplayOrder>
<DetailStep>1</DetailStep>
<DetailSpan>No</DetailSpan>
<DetailUIType>RadioButtonsYesNoDetail</DetailUIType>
<DetailName>PO Received</DetailName>
<RadioYesNo>
<Value>no</Value>
</RadioYesNo>
</Detail>
<Detail>
<DetailTypeID>753</DetailTypeID>
<DisplayOrder>5</DisplayOrder>
<DetailStep>2</DetailStep>
<DetailSpan>No</DetailSpan>
<DetailUIType>DropDownListDetail</DetailUIType>
<DetailName>Target Release</DetailName>
<DropDownList>
<SelectedValue>
<Issue IssueTypeID="1004">
58
<Description>9.0.0</Description>
</Issue>
</SelectedValue>
</DropDownList>
</Detail>
<Detail>
<DetailTypeID>788</DetailTypeID>
<DisplayOrder>4</DisplayOrder>
<DetailStep>2</DetailStep>
<DetailSpan>No</DetailSpan>
<DetailUIType>DropDownListDetail</DetailUIType>
<DetailName>Reported in Version</DetailName>
<DropDownList>
<SelectedValue>
<Issue IssueTypeID="1020">
58
<Description>9.0.0</Description>
</Issue>
</SelectedValue>
</DropDownList>
</Detail>
<Detail>
<DetailTypeID>754</DetailTypeID>
<DisplayOrder>7</DisplayOrder>
<DetailStep>1</DetailStep>
<DetailSpan>No</DetailSpan>
<DetailUIType>DropDownListDetail</DetailUIType>
<DetailName>Priority</DetailName>
<DropDownList>
<SelectedValue>
<Issue IssueTypeID="1005">
2
<Description>High</Description>
</Issue>
</SelectedValue>
</DropDownList>
</Detail>
<Detail>
<DetailTypeID>752</DetailTypeID>
<DisplayOrder>8</DisplayOrder>
<DetailStep>1</DetailStep>
<DetailSpan>No</DetailSpan>
<DetailUIType>DropDownListDetail</DetailUIType>
<DetailName>OS</DetailName>
<DropDownList>
<SelectedValue>
<Issue IssueTypeID="1003">
01
<Description>Unspecified</Description>
</Issue>
</SelectedValue>
</DropDownList>
</Detail>
<Detail>
<DetailTypeID>773</DetailTypeID>
<DisplayOrder>3</DisplayOrder>
<DetailStep>1</DetailStep>
<DetailSpan>No</DetailSpan>
<DetailUIType>DropDownListDetail</DetailUIType>
<DetailName>Requested by</DetailName>
<DropDownList>
<SelectedValue>
<Issue IssueTypeID="1008">
<Description>Internal</Description>
</Issue>
</SelectedValue>
</DropDownList>
</Detail>
<Detail>
<DetailTypeID>776</DetailTypeID>
<DisplayOrder>3</DisplayOrder>
<DetailStep>2</DetailStep>
<DetailSpan>No</DetailSpan>
<DetailUIType>MultipleSelectListWithAdminDropDownListDetail</DetailUIType>
<DetailName>Completed for</DetailName>
<MultipleSelectListWithAdminDropDownList>
<SelectedValues>
<SelectedValue>
<Issue IssueTypeID="1010">
<Description>DB - DOC Database</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1010">
<Description>DB - SQL MODEL Database</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1010">
<Description>XFRACAS Code</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1010">
<Description>DB - Upgrade Script</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1010">
<Description>DB - SQL DEV Database</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1010">
<Description>DB - Reference Database</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1010">
<Description>DB - Oracle MODEL Database</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1010">
<Description>DB - Oracle DEV Database</Description>
</Issue>
</SelectedValue>
</SelectedValues>
</MultipleSelectListWithAdminDropDownList>
</Detail>
<Detail>
<DetailTypeID>775</DetailTypeID>
<DisplayOrder>2</DisplayOrder>
<DetailStep>2</DetailStep>
<DetailSpan>No</DetailSpan>
<DetailUIType>MultipleSelectListWithAdminDropDownListDetail</DetailUIType>
<DetailName>Applies to</DetailName>
<MultipleSelectListWithAdminDropDownList>
<SelectedValues>
<SelectedValue>
<Issue IssueTypeID="1009">
<Description>DB - SQL MODEL Database</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1009">
<Description>DB - Reference Database</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1009">
<Description>DB - Upgrade Script</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1009">
<Description>DB - Oracle MODEL Database</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1009">
<Description>XFRACAS Code</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1009">
<Description>DB - Oracle DEV Database</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1009">
<Description>Translation</Description>
</Issue>
</SelectedValue>
<SelectedValue>
<Issue IssueTypeID="1009">
<Description>DB - SQL DEV Database</Description>
</Issue>
</SelectedValue>
</SelectedValues>
</MultipleSelectListWithAdminDropDownList>
</Detail>
<Detail>
<DetailTypeID>816</DetailTypeID>
<DisplayOrder>3</DisplayOrder>
<DetailStep>4</DetailStep>
<DetailSpan>Yes</DetailSpan>
<DetailUIType>AttachmentsDetail</DetailUIType>
<DetailName>Attachments - Resolution</DetailName>
<DetailAttachments>
<DetailAttachment>
<AttachmentType>Blob Data</AttachmentType>
<DataSourceTypeID>17</DataSourceTypeID>
<Relationship />
<AttachmentTitle>FR-I-3744_ORA.sql</AttachmentTitle>
<AttachmentDescription>SQL for this Incident - Oracle version</AttachmentDescription>
<FileName>FR-I-3744_ORA.sql</FileName>
<RelatedID>12099</RelatedID>
</DetailAttachment>
<DetailAttachment>
<AttachmentType>Blob Data</AttachmentType>
<DataSourceTypeID>17</DataSourceTypeID>
<Relationship />
<AttachmentTitle>01-DEV-FR-I-3744-SQL.txt</AttachmentTitle>
<AttachmentDescription>01 Development SQL</AttachmentDescription>
<FileName>01-DEV-FR-I-3744-SQL.txt</FileName>
<RelatedID>12095</RelatedID>
</DetailAttachment>
<DetailAttachment>
<AttachmentType>Blob Data</AttachmentType>
<DataSourceTypeID>17</DataSourceTypeID>
<Relationship />
<AttachmentTitle>FR-I-3744_SQL.sql</AttachmentTitle>
<AttachmentDescription>SQL for this Incident - SQL Server version</AttachmentDescription>
<FileName>FR-I-3744_SQL.sql</FileName>
<RelatedID>12100</RelatedID>
</DetailAttachment>
</DetailAttachments>
</Detail>
<Detail>
<DetailTypeID>34</DetailTypeID>
<DisplayOrder>3</DisplayOrder>
<DetailStep>3</DetailStep>
<DetailSpan>Yes</DetailSpan>
<DetailUIType>StatusDetail</DetailUIType>
<DetailName>Status of Troubleshooting</DetailName>
<DetailStatus>
<DetailStatusData>
<DetailStatusDate>
<Year>2013</Year>
<Month>4</Month>
<Day>16</Day>
<Hour>21</Hour>
<Minute>36</Minute>
<Second>31</Second>
<FormattedDate>04/16/2013 02:36 PM</FormattedDate>
</DetailStatusDate>
<DetailStatusDescription>
Implemented against the DOC database and MODEL database/scripts. Placed the SQL in FINAL UPGRADE scripts. Since Translation is in the Applies To drop down, changed the status to "Submitted For Translation".
</DetailStatusDescription>
<WrittenBy>
<FirstName>GEORGANA</FirstName>
<LastName>FERNANDEZ</LastName>
<Login>RELIASOFT\GFERNANDEZ</Login>
</WrittenBy>
</DetailStatusData>
<DetailStatusData>
<DetailStatusDate>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>48</Minute>
<Second>57</Second>
<FormattedDate>04/12/2013 09:48 AM</FormattedDate>
</DetailStatusDate>
<DetailStatusDescription>Code update complete. Changed status to code complete.</DetailStatusDescription>
<WrittenBy>
<FirstName>ALEXANDER</FirstName>
<LastName>BEHLEN</LastName>
<Login>RELIASOFT\ABEHLEN</Login>
</WrittenBy>
</DetailStatusData>
<DetailStatusData>
<DetailStatusDate>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>34</Minute>
<Second>5</Second>
<FormattedDate>04/12/2013 09:34 AM</FormattedDate>
</DetailStatusDate>
<DetailStatusDescription>Looked over attached script and resource 35600 was in there twice. I commented it out the 2nd instance of it. Verified this had been implemented against the SQL dev and reference databases. Implemented against the Oracle DEV database. Attached scripts. Changed the status to "Initial DBA Completed". Once all code changes are complete OR I can run this against the weekly test database then set the status to "Code Complete - Updating TEST Scripts". Thanks! </DetailStatusDescription>
<WrittenBy>
<FirstName>GEORGANA</FirstName>
<LastName>FERNANDEZ</LastName>
<Login>RELIASOFT\GFERNANDEZ</Login>
</WrittenBy>
</DetailStatusData>
<DetailStatusData>
<DetailStatusDate>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>22</Hour>
<Minute>54</Minute>
<Second>29</Second>
<FormattedDate>04/12/2013 03:54 PM</FormattedDate>
</DetailStatusDate>
<DetailStatusDescription>Looks good in April 12th build. Under Database PVC.</DetailStatusDescription>
<WrittenBy>
<FirstName>DAVE</FirstName>
<LastName>ROCK</LastName>
<Login>RELIASOFT\ADMIN101</Login>
</WrittenBy>
</DetailStatusData>
<DetailStatusData>
<DetailStatusDate>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>16</Hour>
<Minute>11</Minute>
<Second>56</Second>
<FormattedDate>04/12/2013 09:11 AM</FormattedDate>
</DetailStatusDate>
<DetailStatusDescription>The required SQL is attached and has been run against SQL_XFRACAS_Reference_70X and SQL_XFRACAS_DEV_80X. Changed status to Under Initial DBA.</DetailStatusDescription>
<WrittenBy>
<FirstName>ALEXANDER</FirstName>
<LastName>BEHLEN</LastName>
<Login>RELIASOFT\ABEHLEN</Login>
</WrittenBy>
</DetailStatusData>
<DetailStatusData>
<DetailStatusDate>
<Year>2013</Year>
<Month>4</Month>
<Day>12</Day>
<Hour>21</Hour>
<Minute>3</Minute>
<Second>29</Second>
<FormattedDate>04/12/2013 02:03 PM</FormattedDate>
</DetailStatusDate>
<DetailStatusDescription>Implemented database changes/additions related to this Incident against the TEST databases hitting http://xfracassqlvm/8/ and http://xfracassqlvm/9/ for today's build (db version 8.0.33 on 4/12/2013). Set Incident status to "Submitted For Testing".</DetailStatusDescription>
<WrittenBy>
<FirstName>GEORGANA</FirstName>
<LastName>FERNANDEZ</LastName>
<Login>RELIASOFT\GFERNANDEZ</Login>
</WrittenBy>
</DetailStatusData>
</DetailStatus>
</Detail>
<Detail>
<DetailTypeID>49</DetailTypeID>
<DisplayOrder>1</DisplayOrder>
<DetailStep>2</DetailStep>
<DetailSpan>No</DetailSpan>
<DetailUIType>DescriptionDetail</DetailUIType>
<DetailName>Description</DetailName>
<DetailDescription>
<DetailDescriptionData>
<DetailDescriptionText>Text was missing resources.</DetailDescriptionText>
<TargetDate />
<TargetUser />
<CompletedDate />
<CompletedBy />
</DetailDescriptionData>
</DetailDescription>
</Detail>
</Details>
</Incident>
</Incidents>