Trustwave and Cybereason Merge to Form Global MDR Powerhouse for Unparalleled Cybersecurity Value. Learn More

Request a Demo
Trustwave and Cybereason Merge to Form Global MDR Powerhouse for Unparalleled Cybersecurity Value. Learn More

Request a Demo
Services
Managed Detection & Response

Eliminate active threats with 24/7 threat detection, investigation, and response.

Co-Managed SOC (SIEM)

Maximize your SIEM investment, stop alert fatigue, and enhance your team with hybrid security operations support.

Advisory & Diagnostics

Advance your cybersecurity program and get expert guidance where you need it most.

Penetration Testing

Test your physical locations and IT infrastructure to shore up weaknesses before exploitation.

Database Security

Prevent unauthorized access and exceed compliance requirements.

Email Security

Stop email threats others miss and secure your organization against the #1 ransomware attack vector.

Digital Forensics & Incident Response

Prepare for the inevitable with 24/7 global breach response in-region and available on-site.

Firewall & Technology Management

Mitigate risk of a cyberattack with 24/7 incident and health monitoring and the latest threat intelligence.

View All Trustwave Services
Solutions
BY INDUSTRY
BY REGULATION
BY TOPIC
Microsoft Security
Unlock the full power of Microsoft Security
Offensive Security
Solutions to maximize your security ROI
Rapidly Secure New Environments
Security for rapid response situations
Securing the Cloud
Safely navigate and stay protected
Securing the IoT Landscape
Test, monitor and secure network objects
Why Trustwave
About Us
We reduce cyber risk and fortify organizations
Awards and Accolades
Recognition by analysts and media outlets
Trustwave SpiderLabs Team
Global researchers, ethical hackers, and responders
Trustwave Fusion Security Operations Platform
Unprecedented security visibility and control
Trustwave Security Colony
Access to cybersecurity threat protection resources
Partners
Technology Alliance Partners
Key alliances who align and support our ecosystem of security offerings
Trustwave PartnerOne Program
Join forces with Trustwave to protect against the most advance cybersecurity threats
Register
Login
Resources
BLOGS
UPCOMING
MEDIA & ASSETS
NOTICES
HELP
Loading...
Loading...

Trustwave Knowledge Base

Home » Knowledgebase » Legacy Products » Security Reporting Center » ERRMSG: Error: DbStream::bool Flush(void) error 5004:DbStream...

ERRMSG: Error: DbStream::bool Flush(void) error 5004:DbStream Error 1062: INSERT INTO Site (Sitename) VALUES(?)[HY000][TCX][MyODBC]Duplicate entry.

Expand / Collapse
Show/Hide Article Tools


This article applies to:

  • Security Reporting Center 2.0x

Symptoms:

  • Error: DbStream::bool Flush(void) error 5004:DbStream Error 1062: INSERT INTO Site (Sitename) VALUES(?)[HY000][TCX][MyODBC]Duplicate entry.
  • Report stops with duplicate key error.

Causes:

Strings longer than 255 characters are being truncated when they are exported to the database.  Strings that differ only after 255 characters are considered "duplicate".

Information:

In order to resolve this issue please follow the steps below.
 
1.  Upgrade to Security Reporting Center 2.1.  You can find the download and installation instructions here: https://support.trustwave.com/Security-Reporting-Center/upgrade.asp
 
2.  After the upgrade please make sure to delete the existing FastTrends and Content databases.  The easiest way to do this would be to copy your existing profiles and analyze the copied profile.  If you would like to manually delete the databases instead, please follow these steps:
Clearing FastTrends Database
 
     a. Click Firewall Reporting and/or Proxy Reporting > Options > Fast Trends Database Management.
     b. Highlight profile and click Manage Databases for Selected Profile.
     c. Choose Delete all Days.
     d. Click Delete.
     e. Click Done.
     f. Click Save.
 
Clearing the Content Database
 
     a. Click Firewall Reporting and/or Proxy Reporting > Options > Content Database Management > Content DB Maintenance event.
     b. Check Enable Auto-Delete feature.
     c.  Specify today's date in Delete all report data with a time-stamp earlier than.
     d. Click Queue Event Now.
     e. Click Done.
     f. Click Save.
3.  Analyze your profiles to compile the database without the duplicate entries.
 
After the re-analysis you should then be able to view your reports.
 

Notes:

Always make a backup of your current installation before upgrading.

This article was previously published as:
NETIQKB40360

To contact Trustwave about this article or to request support:

Rate this Article:
     
Tags:

Add Your Comments


Comment submission is disabled for anonymous users.
Please send feedback to Trustwave Technical Support or the Webmaster.


Execution: 0.031. 8 queries. Compression Disabled.
Powered by InstantKB.NET