Bookshelf Home | Contents | Index | Search | PDF |
Siebel Forecasting Guide > Forecasting Migration >
Upgrading Using the Data Migration Utility (Administrator)
The data migration tool is designed for customers with recurring revenues entered directly into the Forecasts screen.
NOTE: Because of the data model changes in forecasting, it is recommended that you print out your old forecasts before upgrading. Those forecasts are no longer visible in this version of the Siebel application. Although the data migration described here moves your data, you may want to double-check the results when the migration is finished.
To use the Data Migration Utility
- In the default bin directory on the server, there is a file called fcstcnvrt.exe. This is the program that is used to migrate information from old Siebel forecasting tables to the new Siebel Revenue table. Also in this directory is a set of DLL files used by the data migration utility:
sslcshar.dll
sslcfom.dll
sscfdm.dll
sscfcmn.dll
sscacmbc.dll
sslcsym.dll
sslcosd.dll
Once you have located these files and made sure that they are available for data migration, clean up your existing data.
- You may need to perform some data cleanup on your old Siebel database. Specifically, check for and remove duplicate periods from the periods table, if they exist.
To check for duplicate periods, manually review the periods view in Siebel, or run the following SQL:
select t1.row_id || ' CONFLICTS WITH ' || t2.row_id ||
' (' || t1.period_cd || ',' || t1.start_dt || ')'
from s_period t1, s_period t2
where t1.period_cd = t2.period_cd
and t1.start_dt = t2.start_dt
and t1.row_id <> t2.row_idIf you do have duplicate periods, and you find that they have been used in creating old Siebel forecasts, work with Siebel Systems to address this issue before proceeding to the next step.
- At the command prompt, enable logging using the following commands:
set SIEBEL_LOG_EVENTS=errors
set ForecastUpgdEvent=errorsTo log all events instead of just errors, set each of the preceding variables to "All" instead of "errors."
- To run the data migration, use fcstcnvrt.exe. The syntax for this command is:
fcstcnvrt/u username /p password /d datasource /m masterForecast /date date [/c cfgFile] [/l language] [/postn postn] [/login login] [/sspec searchSpec] [/r revision] [/ submitted [/Opportunity [/OpportunityProduct [/OpptyProduct [/ NP] [/Period period] [/UseStartDate] [/Desc description]
or
fcstcnvrt[/help]
The following table describes each of these:
- The data migration utility takes a few minutes to run. Some messages may appear while the upgrade is running. You might see something like this:
-> "Upgrading forecast for CCONWAY Revision 1.. Success".
-> "Upgrading forecast for CCONWAY Revision 2.. Failure".
-> "*******Upgrade complete**************"
-> "Errors were encountered. Please see the logfile in d:\log\siebel.log for
more details"
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Forecasting Guide Published: 18 April 2003 |