Websense veritabanlarını yeni SQL sunucu üzerine taşıdıktan sonra eksi verilerin görülmesi ve yeni verilerin eklenmemesi problemi için aşağıda yer alan adımların kontrol edilmesi gerekmekte.
Tüm websense servisleri hatasız çalıştığı, eski verilerin raporlandığı halde yeni siteler eğer kayıt edilmiyorsa;
Özellikle yeni sunucuda bulunan SQL Server Agent servisinin çalıştığını kontrol etmek gerekiyor.
Websense sitesinde yer alan kontrol etmemiz gereken diğer noktalar
http://www.websense.com/support/article/t-kbarticle/Why-is-data-not-being-logged-to-the-database
Why is data not being logged to the database?
Article Number: 000004794
Products: Websense Enterprise
Versions: 5.2, 6.0, 6.1, 6.2, 6.3
Problem Description
There is no data being logged to my database, or my reports are blank. What can I do to troubleshoot this?
Resolution
Verify that the Log Server service is started. If Log Server is unable to start:
Verify that port 55805 is listening.
Verify that the ODBC connection, connects successfully to the Log Database.
Verify that you are have sufficient disk space.
Verify that the websense.ini file, in the Websense bin directory, lists the correct IP address and UID for Policy Server.
Verify that the file LogServer.ini file, in the Websense bin directory, exists and is not truncated.
If the Log Server service is running as a domain account, change to Local System account to see if the service will start.
Run Log Server in debug mode. Check if the service is able to connect to Websense Policy Server and to the database.
Verify that .tmp files are writing to the Websense bin\Cache directory. (If you are using BCP, the .tmp files are first written to the \Cache directory, then moved to the \BCP directory.) If files are not being written to the \Cache directory:
Verify that the Logging section in Websense Manager is set to point to the Log Server IP address.
Verify that the connection to Log Server by clicking the Check Status button from the Logging section in Websense Manager.
Verify that the correct path has been set for .tmp files to be written, in the Log Server Configuration.
Verify that the Microsoft SQL Server Agent service is started.
Verify that the three Websense SQL Server Agent jobs are running.
Websense_ETL_Job__wslogdbxx
Websense_IBT_Driver__wslogdbxx
Websense_Maintenance_Job__wslogdbxx
The ETL job is the job that writes the data from INCOMINGBUFFER table to the Partition database. The ETL job runs every 10 seconds.
Verify that the status for the Catalog and Partition database are Normal.
Verify that the Partition databases are NOT marked for deletion.
Check for any errors populated for the database under Start > All Programs > Websense > Reporting Tools > Database Administration > Error Log Activity. (Note: The Reporting Tools must be installed to access it. For more information, please see our deployment guide.)
Run Log Server in debug mode to verify insertion to INCOMINGBUFFER.
Verify that you are logging to a supported SQL version and the correct service pack is applied
Verify that all relevant hotfixes posted on MyWebsense have been applied.