5/5/2024 5:30:24 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss upgrading SalesLogix from version to version. View the code of conduct for posting guidelines.
|
|
|
|
Data deleted on opportunity table after upgrade bundle installation
Posted: 10 Oct 09 8:56 AM
|
Hi slxusers,
As a part of version upgrade process, i ran the 'upgrade bundle v6.2 to 7.5'. After the bundle installation, i found there was a data loss on opportunity table.
Some of the records got deleted, couldn't figure out the issue.
Need help and suggestions. |
|
|
|
Re: Data deleted on opportunity table after upgrade bundle installation
Posted: 10 Oct 09 5:15 PM
|
The problem is due to Field Type conversion.
There are a few fields that were defined differently on earlier versions, and as they are converted, the data may not fit.
So, the data is not copied over correctly, hence your missing data.
Whenever a table is modified, the process goes as follows:
- Copy table to a Temp table (e.g. OPPORTUNITY_X)
- Drop the Table
- Create the Table with the new Schema
- Copy the data over from the Temp table.
Because some fields may no longer have valid data, the process fails to copy over the data.
Your best bet is to determine the fields that have been modified, and then find the values that will no longer fit, and if appropriate modify the data.
If modifying the data is not acceptable, then don't allow for the fields to be modified (but that may introduce additional issues).
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|