Enterprise Business Solution Specialists in Atlanta, Charlotte and Tampa

Field Service Anywhere Device Data Purge

October 6th, 2008 by Jack Sowers

Field Service Anywhere is architected to maintain historical data on the each mobile device. As such, the device data storage can become quite large over time depending on the transaction volume of the technician. Therefore, it is advised to periodically reset the mobile data set to a clean state and perform an initial sync again. The initial sync process is the process performed to initially load data once a new mobile device is added to the FSA system. It is recommended that you perform this process on a bi-weekly or monthly process.

Server

1. Using the FSA Configuration tool, go to the Technicians Tab.

2. Highlight the Tech, and then select the Data tab. Note – If there are multiple subscriber ids, make sure you have the right one selected for the device. You can find out what device the SyncSubscriberId is using by examining the SyncSubscriber table in the FSA_[N] database. Look for the Tech’s User ID and find the DeviceId value.

3. Click the Remove button. This will remove the server db for the Tech.

4. In Dynamics GP, Open the Tech Card and go to the Additional > FSA Tech Extensions table. Note – Tech should be marked for Mobile Access, with a valid GP UserID.

5. Mark the Reset at Next Logon checkbox.

6. Save and close the Tech card.

Laptop (Windows Client)

1. Open the Windows Client folder where Field Service Anywhere is installed.

2. Delete the subscriber database. The database should be named FsaSubscriber2.sdf. FsaSubscriber1.sdf is for the sample database.

3. Login to FSA client application using work online to synchronize and create the new database using the new parameters.

Pocket PC

1. Delete the FsaSubscriber2.sdf from the mobile device.

2. Login to the FSA client application using work online to synchronize and create the new database using the new parameters.

Note: FSA is configured by default to transmit and store historical data for the previous 90 days upon initial sync. Therefore, it may be desirable to change the default period for historical data on the host SQL Server. This setting is in DbOperationalSetting table in the FSA host database. The FSA host databases begin with ‘FSA_’ and there is one for each Dynamics GP company running FSA. Change the SettingValue column to the number of days desired for history or completed service calls on the row where the SettingCode is equal to ‘SubscriberTimeWindowBefore’. For example, using the FSA_1 database, the following commands will change the default number of days to 30.

TSQL Command

use FSA_1

update DbOperationalSetting set SettingValue = ‘30′ where   SettingCode = ‘SubscriberTimeWindowBefore’

Leave a Reply