Data management

State's passport and visa system crashes

Shutterstock image: United States passport with an unidentifiable credit card resting underneath it.

Passport verifications are one of several functions to be compromised by the Consular Consolidated Database crash.

The colossal data warehouse that supports the State Department's worldwide visa and passport verification operations has crashed, potentially stranding thousands of people waiting for the documents around the world.

The Consular Consolidated Database (CCD) at the State Bureau of Consular Affairs "is currently experiencing technical problems with our passport/visa system," said Marie Harf, deputy spokesperson for the State Department in a July 24 statement to FCW. The Associated Press first reported the CCD problems on July 23.

Harf said the CCD, the agency's system of record, has had "significant performance issues, including outages, since Saturday, July 19." The issues, she said, have resulted in significant backlogs. Visas are approved, recorded and printed through the CCD. "Until the system comes back online, we are unable to print visas. We apologize to applicants and recognize this may cause hardship to applicants waiting on visas and passports. We are working to correct the issue as quickly as possible," she said.

Ongoing problems with the CCD have been no secret, an industry source familiar with the system told FCW. The database crashed earlier this year -- without the visible disruption of the July 19 incident, but seriously enough that Bureau of Consular Affairs CIO Greg Ambrose sent an email to State Department and industry stakeholders about the problem.

The CCD system is massive, containing millions of visa cases and photographs, with links to other federal agency security databases, including the FBI's Integrated Automated Fingerprint Identification System (IAFIS) and the Department of Homeland Security's Automated Biometric Identification System (IDENT). It is also the gateway to the Department of State Facial Recognition system and the NameCheck system.

According to a State Department privacy impact assessment completed in 2010, the CCD is one of the largest Oracle-based data warehouses in the world. As of December 2009, according to the PIA, the database contained more than 100 million visa cases and 75 million photographs, used billions of rows of data, and had a growth rate of about 35,000 visa cases every day.

The PIA said the database was created to provide Consular Affairs a near real-time aggregate of the consular transaction activity collected domestically and at consular post databases worldwide. "The CCD is the IT implementation that provides for a set of centralized visa and American citizen services supporting consular posts and back office functions," the assessment found.

Three of CCD's primary functions include supporting data delivery to approved applications via industry-standard Web Service queries, providing users with easy-to-use data entry interfaces to CCD, and allowing emergency recovery of consular post databases. Additionally, according to the PIA, authorized State Department and other government agency personnel can use the CCD Portal to view centralized data and access other applications.

Harf said the issue is worldwide and not specific to any particular country, citizenship document or visa category. "We apologize to applicants who are experiencing delays or are unable to obtain a passport, Consular Report of Birth Abroad, or visa at this time. We are working urgently to correct the problem and expect our system to be fully operational again soon."

About the Author

Mark Rockwell is a senior staff writer at FCW, whose beat focuses on acquisition, the Department of Homeland Security and the Department of Energy.

Before joining FCW, Rockwell was Washington correspondent for Government Security News, where he covered all aspects of homeland security from IT to detection dogs and border security. Over the last 25 years in Washington as a reporter, editor and correspondent, he has covered an increasingly wide array of high-tech issues for publications like Communications Week, Internet Week, Fiber Optics News, magazine and Wireless Week.

Rockwell received a Jesse H. Neal Award for his work covering telecommunications issues, and is a graduate of James Madison University.

Click here for previous articles by Rockwell. Contact him at [email protected] or follow him on Twitter at @MRockwell4.


  • Acquisition
    Shutterstock ID 169474442 By Maxx-Studio

    The growing importance of GWACs

    One of the government's most popular methods for buying emerging technologies and critical IT services faces significant challenges in an ever-changing marketplace

  • Workforce
    Shutterstock image 1658927440 By Deliris masks in office coronavirus covid19

    White House orders federal contractors vaccinated by Dec. 8

    New COVID-19 guidance directs federal contractors and subcontractors to make sure their employees are vaccinated — the latest in a series of new vaccine requirements the White House has been rolling out in recent weeks.

Stay Connected