function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
krish4ukrish4u 

Error while uploading

hi,

 

while uploading through data loader  i got this error any one can resolve this problem.

 

Error loading into target [OpportunityHistory] : Error received from salesforce.com. Fields []. Status code [CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY]. Message [entity type cannot be inserted: Opportunity History].

 

 

thanks,

krish

forecast_is_cloudyforecast_is_cloudy

The OpportunityHistory object is a read-only 'table' that represents the history of a change to the Amount, Probability, Stage, or Close Date fields of an Opportunity record. Salesforce automatically generates a new record whenever a user or client application changes the value of any of the above fields (and if field tracking is enabled for the Opportunity object).

You cannot insert or update records in OpportunityHistory - you can only query them. What's the use case for you to insert data into OpportunityHistory via Data Loader?
Paul WeedenPaul Weeden

Hello,

 

We are having the same issue with importing historical Opportunity information from Excel.  The use case is that you need to be able to import historical pipeline data into Salesforce.com.

 

What we have found:

We are able manually set the 'Created Date' of an Opportunity to reflect when the Opportunity entered the pipeline (Create Audit Permissions).  When an Opportunity is created through the UI the created date of the 1st entry in the Opportunity History object reflects the instant the 'Save' button was pressed.  When you add an Opportunity via the data loader and manually set the 'Created Date' (1st of November 2009), the Created Date of the 1st enty in the Opportunity History object is set to the moment the Opportunity was inserted (14th of March 2011) as opposed to the specified created date of (1st of November 2009).

 

This is an issue as if you query the HistoryObject to establish the stage an opportunity was in as of the 2nd of November 2009 you will get no results as the created date of the OpportunityHistory record is 14th of March 2011.

 

What this means is that we are unable to use Salesforce to report on pipeline history.

 

Can you help?