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 http://www.symantec.com/docs/TECH158760
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


Environment

Subject

Issue



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.

 

Command:

 

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


Error



DBD::SQLite::st execute failed: unable to open database file(14) at dbdimp.c line 423 at lib/VOS/v10/DB/DB.pm line 173.
[VOS data collector DBException->Message] Collector, lib/VOS/v10/Collector/Collector.pm, 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
 


Environment



Data Collector version: Build: 2.2.3.20100901

 

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.


Cause



Running an older version of the Data Collector script.


Solution



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

 

Browse to http://sort.symantec.com and click My Sort link

Or ...

Browse directly to http://mysort.symantec.com


Supplemental Materials

Description

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 http://www.symantec.com/docs/TECH158760


Terms of use for this information are found in Legal Notices