Intro
Informal Opening Discussion
Crash DB Systems Review
TraCS Systems and Crash Form development
Dave Malisch / Geri Polster
TOPS Database and WisTransPortal
Steven Parker / Andi Bill
Crash Records Unit
Soujanya Jarabana / Mike Satteson
Questions from Law Enforcement Agencies
CRU business unit provided email, phone, and remote support to law enforcement agencies to resolve Validation errors in the DT4000 crash form.
We received 10 LEA questions in the last 3 weeks about different crash scenarios involving
3 questions about Fatal Supplement
2 questions about Non-Reportable Crashes
2 involving what driver was doing
2 questions unit type pedestrian
1 field validation error
Crash Database & Resolve System Updates
TOPS Server Error
Issue:
Transmission failures occurred due to TOPS Server error that prevented the Crash Database server from accepting new crash reports. This issue was caused due to staging table space reaching its full capacity.
When:
Start time: Friday 9/1 at 1:35 PM
End time: Tuesday 9/5 at 8:32 AM
Impact:
Failed transmissions: 438
Resolution:
Failed transmissions related to DT4002 crashes were retransmitted by TOPS Lab
Badger Tracs transmitted the failed BTHE crashes.
Crash Records Unit handled 26 failed transmissions and did follow up with agencies to retransmit them again.
Enhancements
Manage Finalization in Resolve System & Install new DT3480 XSD for Badger TraCS
CRASHDB-1388 - Getting issue details... STATUS
CRASHDB-1324 - Getting issue details... STATUS
Change Requests submitted to CAB
In the last three weeks, 3 normal change requests were submitted to Change Advisory Board which includes:
[CRASHDB-1393] Development Cycle - September 2023 Tock - Jira (atlassian.net)
Update Web certificates on the WisTransPortal Crash Database web servers [CRASHDB-1387] Web Certificate Update for Web Servers - Jira (atlassian.net)
Monthly server maintenance for September 2023 was cancelled due to conflict in schedule with DB2 upgrade done by DB2 Database team. [CRASHDB-1403] Crash DB Server Maintenance - 2023-09-24 - Jira (atlassian.net)
Transmission failures
We addressed 34 transmission failures in the last 3 weeks after providing solution to the agencies.
6 are transmitted
1 was transmitted as other Document (Duplicate Document Number)
1 is pending with agency.
26 retransmitted due to TOPS Server error
DMV Systems and SR
Ken Matthews
Reference Point Coding
Ben Rouleau / Asadur Rahman
08/31-09/20
Jacob: 3,236
Erickson: 1,477
Total: 4,713
RP coding needed for 2022: 20,050
Crash Data Analysis and Reporting
Valerie Payne
Add Comment