Database error running SORT Data Collector to generate offline License Deployment Report (LDR)
|Article:TECH158760|||||Created: 2011-04-26|||||Updated: 2011-05-10|||||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.|
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/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
Data Collector version: Build: 18.104.22.16800901
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 http://sort.symantec.com and click My Sort link
Browse directly to http://mysort.symantec.com
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