• ECCLisa
  • NEWBIE
  • 0 Points
  • Member since 2005

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 9
    Replies
Is it possible to activate an inactive picklist value? This is specifically regarding the Opportunity object and the Stage picklist field. We have a Stage in the inactive list that needs to be changed to active, but that list only allows you to View or Delete. If I can't activate it, it looks like my only option would be to delete it from the inactive list and add it back as an active stage. I'm concerned that I might lose any history of that stage when I delete it.

Any suggestions would be greatly appreciated.

Thanks -
Lisa
I referred to the following post regarding clearing a date field and changed it for VB but I cannot seem to get the date field to clear.

http://forums.sforce.com/sforce/board/message?board.id=NET_development&message.id=2627&query.id=5521#M2627

Here is a subset of my test code:

'-- Create Opportunity Record
Dim objOpp As New Opportunity
objOpp.Id = sMyID
objOpp.Name = "Testing"

'-- Specify fields to null
'-- NEW CODE START
Dim aNull(1) As String
aNull(0) = "CloseDate"
aNull(1) = "Credit_Report_Date__c"

objOpp.fieldsToNull = aNull
'-- NEW CODE END

'-- Add this Opportunity to the array to send to SF
Dim aobjOpps() as sObject
aobjOpps(0) = objOpp

'-- Call Update
Dim aobjSaveResult() As SaveResult = Nothing
aobjSaveResult = myBinding.update(aobjOpps)

This is a trimmed down version of the acutal code. Everything is working just fine for updates and has been for months. I've simply attempted to add the logic to null out certain fields. Here's what happens/doesn't happen:

- The code runs without error
- The update occurs
- Save result reflects success
- The fields are not nulled

I'm sure I'm just missing something simple but I can't figure out what!

Thank you for any insight -
Lisa
(Copied from the Perl/PHP board, since it's not language-specific.)

I have some code that has been running successfully against v2.5 of the SOAP API that suddenly stopped working today and instead throws a CURL/SSL error. I also get an error, which I assume I shouldn't, when I simply try to use CURL to access the API server.

Has it moved from na1-api.salesforce.com:443?

$ curl -v https://na1-api.salesforce.com
* About to connect() to na1-api.salesforce.com port 443
* Trying 204.14.234.40... * connected
* Connected to na1-api.salesforce.com (204.14.234.40) port 443
* successfully set certificate verify locations:
* CAfile: /usr/share/curl/curl-ca-bundle.crt
CApath: none
* Unknown SSL protocol error in connection to na1-api.salesforce.com:443
* Closing connection #0
curl: (35) Unknown SSL protocol error in connection to na1-api.salesforce.com:443
Thanks,
Charlie
  • January 30, 2006
  • Like
  • 0
This code has been working for some time.

Dim mySFDataAdapter As New SforceDataAdapter(getSFUser, SFConnectString)
Dim mySFDataSet As New DataSet
Dim myRecordCount As Integer = mySFDataAdapter.Fill(mySFDataSet)

Today the Fill method is throwing this exception and failing...

An unhandled exception of type 'System.Net.WebException' occurred in system.data.dll

Additional information: The underlying connection was closed: Could not establish secure channel for SSL/TLS.

I have verified with our network team port 443 is not blocked. What is causing this exception?

Steven
  • January 30, 2006
  • Like
  • 0

Hello,

We have code that was running successfully on Friday 6 January but began failing over the weekend with the error: "Insufficient access rights on cross-reference id" whilst trying to create CASEs.

(Our code has not been changed. Java SOAP API version 2.0, (Code was written in 2003))

Am I right to suspect the Winter '06 release for breaking things?

Can anyone provide a detailed explanation for the error message that might give me a hint of what is going on?

Thanks,

Tony

Is it possible to activate an inactive picklist value? This is specifically regarding the Opportunity object and the Stage picklist field. We have a Stage in the inactive list that needs to be changed to active, but that list only allows you to View or Delete. If I can't activate it, it looks like my only option would be to delete it from the inactive list and add it back as an active stage. I'm concerned that I might lose any history of that stage when I delete it.

Any suggestions would be greatly appreciated.

Thanks -
Lisa
I referred to the following post regarding clearing a date field and changed it for VB but I cannot seem to get the date field to clear.

http://forums.sforce.com/sforce/board/message?board.id=NET_development&message.id=2627&query.id=5521#M2627

Here is a subset of my test code:

'-- Create Opportunity Record
Dim objOpp As New Opportunity
objOpp.Id = sMyID
objOpp.Name = "Testing"

'-- Specify fields to null
'-- NEW CODE START
Dim aNull(1) As String
aNull(0) = "CloseDate"
aNull(1) = "Credit_Report_Date__c"

objOpp.fieldsToNull = aNull
'-- NEW CODE END

'-- Add this Opportunity to the array to send to SF
Dim aobjOpps() as sObject
aobjOpps(0) = objOpp

'-- Call Update
Dim aobjSaveResult() As SaveResult = Nothing
aobjSaveResult = myBinding.update(aobjOpps)

This is a trimmed down version of the acutal code. Everything is working just fine for updates and has been for months. I've simply attempted to add the logic to null out certain fields. Here's what happens/doesn't happen:

- The code runs without error
- The update occurs
- Save result reflects success
- The fields are not nulled

I'm sure I'm just missing something simple but I can't figure out what!

Thank you for any insight -
Lisa
This problem has started in the last few days, with a long established program. On several objects the retrieve api call fails with "there is an error in XML document"

This is happening on account, case, contact, lead, opportunity and task objects (others appear OK). Also the error sometimes "goes away", the following is a partial trace:
TaskgetRecordDetail(1): Error: There is an error in XML document (1259, 22).
TaskgetRecordDetail(2): Error: There is an error in XML document (528, 45).
TaskgetRecordDetail(3): Error: There is an error in XML document (13050, 21).
TaskgetRecordDetail(4): Error: There is an error in XML document (3048, 6).
TaskgetRecordDetail(5): Error: There is an error in XML document (11611, 6).
TaskgetRecordDetail(6): Error: There is an error in XML document (14958, 6).
TaskgetRecordDetail(1): Error: There is an error in XML document (1337, 6).
TaskgetRecordDetail(2): Error: There is an error in XML document (14857, 5).
TaskgetRecordDetail(3): Error: There is an error in XML document (9781, 6).

My routine retries up to 10 times, primarily to compensate for network errors. But here the retry gives the same error but at a different points in the xml, finally getting a sucessful response.