Policy Breach Notice: We are no longer detecting PII being passed to Google from the account

Recently one of our readers has received an email from Google AdSense Publishers with subject line ‘Policy Breach Notice‘.

As email didn’t give him enough information to clear his doubt, he dropped us email asking more information. He also mentioned that he didn’t receive any prior email regarding policy breach violation.

Email looks like below:

Dear Publisher,

We have now verified that we are no longer detecting PII being passed to Google from the account(s) under your control.

Thank you for helping to resolve this matter.

The Google Policy Team

After our small research, we got to know that this problem is not with our particular reader only. Many of our readers have received the same email.

What is PII and how it is related to Policy Breach Notice?

PII stands for Personally Identifiable Information. To protect your account, Google AdSense policies mandate publishers not to pass any data to Google that may be recognized as Personally Identifiable Information. If any publisher does so, Google sends a notification email with subject line ‘Policy Breach Notice’ first to fix the issue. Once the affected publisher fixes the PII issue, Google sends the above email.

As you didn’t not receive any prior email to fix the PII issue, we think Google AdSense has sent this email by mistake.

However we have asked the question to Google also to give more information. If we receive any update, we will share it with you all.

So don’t worry and keep blogging !

*** Updated on 6th March, 2015: We told you that the mail must be sent out by mistake. Today we have received an email from Google asking for an apology for sending erroneous email. Probably you have also received the same email.

If you have any question about ‘Policy Breach Notice‘, Please feel free to comment below.

Keep in touch, follow TechOneStop on Facebook / Twitter / LinkedIn / Goolge+.

Also read: YouTube Linked Comment – why I can’t reply?

What is Operational CRM

Operational crmCRM or Customer Relationship Management software enables organizations to manage their relationships with customers. It helps to retain existing customers, acquire new customers and analyze customer data. There are mainly three types of CRM applications – Operational CRM, Analytical CRM and Collaborative CRM. Here we will discuss about what is Operational CRM.

What is Operational CRM?

Operational CRM streamlines the business process of an organization. It mainly focuses on automation and improvement of customer facing and customer touching business processes. It includes Sales automation, Marketing automation and Service automation. Main purpose of Operational CRM system is to generate leads, convert them into contacts, capture all required details and provide support throughout customer lifecycle.

Sales Force Automation:

Operational CRM - Sales AutomationSales Force Automation (SFA) helps an organization to automate sales process from lead generation to closing sale. Main purpose of sales automation is to set business standard within the organization to acquire new customers and deal with existing customers. It includes various CRM sales modules like

  • Lead Management
  • Contact Management
  • Account Management
  • Tracking Customer Preferences
  • Performance Management
  • Quote-to-Order management
  • Sales Forecasting

Marketing Automation:

Operational CRM - Marketing AutomationMarketing Automation helps the organization to streamline marketing process, automate and measure marketing task to increase sales and earn revenue faster. It includes various CRM marketing modules like Campaign Management, Event Based Marketing.

Campaign Management helps business to design campaign, decide communication channels (like email, call, website, social media, TV ads), segment contacts, allocate budget and analyze effectiveness or quality of the campaign.

Event based marketing helps to reach out customers with more relevant products or services based upon what’s going on in their lives at that moment, like first job or buying new car or getting married.

Marketing Automation can automate response to customer queries, inform sales team about new opportunities.

Service Automation:

Operational CRM - Service AutomationService Automation enables business to provide best quality of customer service by automating the service process. It includes various service modules like call management, case or incident management, knowledge management, service level management.

Call Management automation helps to route customer call to the most appropriate help desk person and retrieve all required information related to the call.

Case/Incident Management helps the organization to assign customers’ problems to the right person, provide solution within the time limit, capture customer response and analyze effectiveness.

Knowledge Management captures information from various sources and makes a pro active approach to give value addition to customers.

Service Level Management enables business to analyze quality of service based on key performance indicators.

Increase sales and improve customers’ loyalty are two main purposes of Operational CRM. There are lots of Operational CRM applications with different features and platforms (SaaS, On Premise, Hybrid). So before choosing any Customer Relationship Management application, organization should have defined goal and strategy to ensure success. You could read our article on ‘How to choose the best CRM software for your business’.

Do you have any question? Please feel free to comment below.

Keep in touch, follow TechOneStop on Facebook / Twitter / LinkedIn / Goolge+.

Clean up Siebel File System – Sfscleanup Utility

Clean up Siebel File System is one of major server maintenance activities. Over the time, Siebel file system becomes loaded with lots of invalid and orphan files. If you don’t clean up such files, it may impact on performance of Siebel application and also block hard disk space unnecessarily. To clean up such invalid and orphan files, Oracle provides an utility ‘Sfscleanup’. Here we will discus how to use sfscleanup utility to clean up Siebel file system.

But why files become invalid and orphan?

Well! there could be many reasons, like

  1. If you attach a file with a record and then delete that record
  2. If you attach a file and then change the URL type without deleting the record
  3. If you attach a file against a record and then without deleting that record, attach another file with the same record

How to run Siebel file system cleanup utility ‘Sfscleanup’?

Before running this utility, make sure you have SIEBEL_REPOSITORY environment variable set properly because sfscleanup utility refers environment variable to execute properly. To set SIEBEL_REPOSITORY environment variable correctly, you cloud run another utility ‘siebenv.bat’. We will discus about ‘seibenv’ utility in another article. Sfscleanup utility is located in ‘bin’ sub directory within Siebel server root directory. This utility processes each and every file in the file attachment directory.

Steps to clean up Siebel file system directory using ‘Sfscleanup’:Sfscleanup Siebel Utility

  1. Open command prompt and change the directory to the bin sub directory with in the Siebel Server directory
  2. Run sfscleanup.exe using below parameters

Prompt>sfscleanup /U <User ID> /P <Password> /C <ODBC Data Source> /D <Siebel Table Owner> /F <Path of the Siebel File System Directory> /X <Path of output file, mainly log file> /M <Path to move invalid file>

It would look like:
sfscleanup /U sadmin /P sadmin /C TECHONESTOP /D SIEBEL /F D:\sba81\FS /X D:\sba81\siebsrvr\log\sfscleanup.log /M D:\sba81\siebsrvr\log

Parameter Value Description Required
/U Username Username Id Yes
/P Password Password of the given user Yes
/C ODBC data source name Set this value to ODBC data source if SIEBEL_DATA_SOURCE environment variable is not set properly No if SIEBEL_DATA_SOURCE is set
/D Siebel table owner Set this value to Siebel table owner if SIEBEL_TABLE_OWNER environment variable is not set properly No if SIEBEL_TABLE_OWNER is set
/F Path of the Siebel file system directory Set this value to Siebel file system directory, do not append ‘att’ to the path directory Yes
/X Path of the output file Set this value to the path of out put file, mainly log file No
/M Path to move invalid files Set this value to the path where invalid/orphan files will be moved No
/N Remove older file versions * Set this value to ‘Y’ if you want to delete older version of file attachment. By default Siebel will keep these files marked as ‘ANCIENT’ No
/G Remove garbage file Set this value to ‘Y’ if you want to delete non siebel files from Siebel file system No
/R Generate report file Set this value to ‘Y’ if you want to generate report with File name and File Type No


Older version file means that corresponding attachment record exists in Siebel database but not the file revision number.

If you want to know more about Sfscleanup parameters, refer Cleaning Up the Siebel File System provided by Oracle.

Output file, generated by /X parameter, looks like below. It has three parameters – file name, file type and file operation.

sfscleanup utility

File Name:

This column contains the name of each file that was processed during the execution of Sfscleanup utility

File Type:

This column lists the type of each file that was processed. Below we have listed down all file types and associated operations that this utility performs to clean up Siebel file system.

File Type Description File Operation
CURRENT This file is valid file, it has corresponding record in file attachment table. KEPT
NEW This file is less than one hour old and sfscleanup utility does not check such file in file attachment table. KEPT
ANCIENT This file has corresponding attachment record in database but file version does not match KEPT if /N or /M parameter is not used

  • If /N parameter is set to ‘Y’, operation will be DELETED
  • If /M parameter is set to ‘Y’, operation will be MOVED
INVALID This file or directory is not a valid attachment. KEPT if /G parameter is not set to ‘Y’, otherwise DELETED
ORPHAN This file does not have corresponding record in File attachment table DELETED if /M parameter if not set to any value, otherwise MOVED

File Operation:

This column lists the type of operation performed on each file.

Operation Type Description
KEPT File is not deleted
DELETED File is deleted from file system
MOVED File is moved to the directory specified by /M parameter. Files will only be moved to the directory if the /M parameter is used.
KEPT_DIR Its a directory, not a file and need manual intervention to delete it
KEPT_ERROR File is kept as an error occurred during delete or move operation


Except Sfscleanup, there are another two important utilities ‘Sfspartition‘ and ‘Sfsutl‘ for Siebel file system. We will discuss these in our next article.

Now it’s time for action! Go and Clean Up Siebel File System!

Do you have any question? Please feel free to comment below.

Keep in touch, follow TechOneStop on Facebook / Twitter / LinkedIn / Goolge+.

<< DBCHCK Utility