Description
When attempting to perform Spectrum or Ion searches in Spectrus Processor, the search may fail to return results (e.g., "No hits found") or stall indefinitely (e.g., around 67% progress). This issue occurs if the database being used is in SDF (Structure Data File) format, which does not contain the spectral data required for such searches.
Solution
When to use an SDF File for searching?
SDF files are not designed to store spectral data and cannot be used for Spectrum or Ion searches in Spectrus Processor or Spectrus DB Enterprise. These file types are intended for chemical structure data only, such as:
- Molecular structures
- Associated metadata (e.g., names, properties, or user-defined fields)
Key limitations of SDF files:
- No spectral data: SDF files do not contain NMR, MS, UV/IR, or other spectral information. Attempting to perform Spectrum or Ion searches with an SDF file will result in no hits found or a stalled search (e.g., around 67% progress).
- File size constraints: SDF files larger than 2 GB may fail to open correctly in Spectrus DB or cause performance issues. If your SDF file exceeds this size, split it into smaller files before importing.
While SDF files cannot be used for spectral searches, they do support the following structure-based searches in Spectrus DB Enterprise:
- Substructure Search: Find molecules containing a specific substructure.
- Exact Structure Search: Locate molecules matching an exact structure.
- Similarity Search: Identify molecules with structural similarity to a query.
- Mass Search: Search for molecules based on mass or molecular formula
Use a Spectrus DB (.CFD) Database for Spectral Searches
To perform Spectrum or Ion searches, you must use a Spectrus DB (.CFD) database. These databases are specifically designed to store and retrieve spectral data alongside chemical structures.
Requirements for using .CFD databases:
- Appropriate licensing: Ensure your license includes Spectrus DB Enterprise or the relevant module (e.i., NMR Workbook) with spectral database functionality.
Compatibility: .CFD databases support all spectral search types, including:
- Spectrum Search (NMR, MS, UV/IR, X-Ray, etc.)
- Ion Search (MS, LC/UV/MS)
- Peak Search (1D NMR, UV/IR)
- Structure-based searches (substructure, exact structure, similarity)
- Meta Data Search (Fields with numeric and text values)
Note: If a.CFD database contains no spectral data, searches may fail with an error such as: Exception EOleException: Cannot Open spectrum database file. TSpecManagerLocalDatabase: fail creating object. Ensure the database includes spectral data before performing searches.
Table: Troubleshooting Common Issues
| Issue | Possible Cause | Solution |
|---|---|---|
| No hits found or search stalls at 67% | SDF file used instead of .CFD database | Use a .CFD database with spectra for spectral searches. |
Error: Cannot Open spectrum database file | .CFD database lacks spectral data or is corrupted | Ensure the database contains spectral data. Recreate the database or merge it to a new empty database. |
Error: TChemFolderLocalDatabaseImpl: fail creating object | .CFD database is open in Spectrus DB Enterprise in Update Mode | Close the database in Spectrus DB before performing searches in Spectrus Processor. |
| Greyed-out user-defined fields in search dialog | Fields were not properly mapped during SDF import | Re-import the SDF file into Spectrus database (.CFD) and ensure fields are correctly mapped. |
| Search results do not appear | Database is too large or stored on a slow network drive | Store the database locally and split large files into smaller chunks. |
Comments
0 comments
Article is closed for comments.