Database error running SORT Data Collector to generate offline License Deployment Report (LDR)

Article:TECH158760  |  Created: 2011-04-25  |  Updated: 2014-01-02  |  Article URL
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution




Running SORT Data Collector in offline mode to generate LDR for almost 10.000 hosts (9969), a database error is encountered after two (2) days.




./vosdc -offline -tardir=/var/tmp/sda/mar2011/ALL-LOC


DBD::SQLite::st execute failed: unable to open database file(14) at dbdimp.c line 423 at lib/VOS/v10/DB/ line 173.
[VOS data collector DBException->Message] Collector, lib/VOS/v10/Collector/, 300, DB::get_from_db [ select distinct status from collector_status where sys_id='Sys::sjcbat114' ] unable to open database file(14) at dbdimp.c line 423 VOS data collector current session log files are saved at: /repo/vos/log/vosdc-201103311436wer


Data Collector version: Build:


Current version: Build: 3.2.20110316 (at time of this writing)


While this issue was discovered in a specific OS environment, it is possible that this can apply to other supported OS's; only the Data Collector version is material, the version of any installed product(s) does not apply.


Running an older version of the Data Collector script.


Upgrade Data Collector script from SORT website (Custom Reports widget)


Browse to and click My Sort link

Or ...

Browse directly to

Supplemental Materials


The system where the Data Collector was run has no direct connectivity to Internet.  Therefore the script was unable to perform an automatic upgrade.

Article URL

Terms of use for this information are found in Legal Notices