Salesforce Developer Community

allen.zhangyilun
NEWBIE
25 Points
Member since 2010

Chatter

Feed
1

Best Answers
0

Likes Received
0

Likes Given
4

Questions
11

Replies

If this button is an s-control and recommended by Salesforce?

Attached is a button in contact with to change the status of contact, if this solution is recommended by Salesforce, since dml direct from the button.
{!REQUIRESCRIPT("/soap/ajax/39.0/connection.js")}
{!REQUIRESCRIPT("/soap/ajax/39.0/apex.js")}

var con = new sforce.SObject("Contact");
con.Id = '{!Contact.Id}';
con.Contact_Status__c = 'Deactivated';

var result = sforce.connection.update([con]);
if('{!Contact.Contact_Status__c}' == 'Deactivated') {
alert('Contact has been already deactivated');
} else {
if(result[0].getBoolean("success"))
{
alert('Contact is deactivated');
window.location.reload();
}
else{
alert('Error : '+result);
}
}

allen.zhangyilun
July 20, 2017
Like
0

6 replies

System.QueryException: Non-selective query against large object type for Pricebook2

10:20:24.169 (169594000)|SOQL_EXECUTE_BEGIN|[26]|Aggregations:0|select Id, Name, isStandard from Pricebook2 where ((Name != null and Name = :tmpVar1) or isStandard = true)
10:20:24.174 (174329000)|EXCEPTION_THROWN|[26]|System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing.
Even if a field is indexed a filter might still not be selective when:
1. The filter value includes null (for instance binding with a list that contains null)
2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times)
10:20:24.174 (174692000)|FATAL_ERROR|System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing.
Even if a field is indexed a filter might still not be selective when:
1. The filter value includes null (for instance binding with a list that contains null)
2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times)

How can I set a external ID on pricebook2?

allen.zhangyilun
August 26, 2013
Like
0

SOLVED

3 replies

System.CalloutException: handshake alert: unrecognized_name

"https://cs15.salesforce.com" call out to "https://cloud2-na1.castiron.com/env/Development/rest?object=DMU" occurred "System.CalloutException: handshake alert: unrecognized_name", this service was worked fine yesterday, but today got this callout exception.

Please refer to Anonymous execution result attached, the same code can run on cs17, so we can sure the CastIron service is fine.
problem should be cs15 cannot identify CastIron, please help us to resolve this problem.

27.0 APEX_CODE,FINER;APEX_PROFILING,FINE;CALLOUT,INFO;DB,INFO;SYSTEM,FINEST
Execute Anonymous: // "CastIron" custom setting
Execute Anonymous: String userName = '*****;
Execute Anonymous: String password = '*****';
Execute Anonymous:
Execute Anonymous: HttpRequest req = new HttpRequest();
Execute Anonymous:
Execute Anonymous: req.setEndpoint('https://provide.castiron.com/env/Development/tube?object=Opportunity');
Execute Anonymous:
Execute Anonymous: req.setMethod('POST');
Execute Anonymous:
Execute Anonymous: // Sets HTTP time out 2 minutes, unit is millisecond.
Execute Anonymous: req.setTimeout(120000);
Execute Anonymous:
Execute Anonymous: Blob headerValue = Blob.valueOf(userName + ':' + password);
Execute Anonymous: String authorizationHeader = 'Basic ' + EncodingUtil.base64Encode(headerValue);
Execute Anonymous: req.setHeader('Authorization', authorizationHeader);
Execute Anonymous: HttpResponse res = new HttpResponse();
Execute Anonymous: Http http = new Http();
Execute Anonymous:
Execute Anonymous: try {
Execute Anonymous:
Execute Anonymous: System.debug(LoggingLevel.INFO, '***HTTP Request Body: ' + req.getBody());
Execute Anonymous:
Execute Anonymous: res = http.send(req);
Execute Anonymous:
Execute Anonymous: } catch (System.Calloutexception e) {
Execute Anonymous:
Execute Anonymous: System.debug(LoggingLevel.Error, '***Call out erro: ' + e);
Execute Anonymous: System.debug(LoggingLevel.INFO, '***Response String: ' + res.toString());
Execute Anonymous:
Execute Anonymous: }
15:59:50.038 (38917000)|EXECUTION_STARTED
15:59:50.038 (38930000)|CODE_UNIT_STARTED|[EXTERNAL]|execute_anonymous_apex
15:59:50.039 (39349000)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:49
15:59:50.039 (39573000)|STATEMENT_EXECUTE|[1]
15:59:50.039 (39579000)|STATEMENT_EXECUTE|[2]
15:59:50.039 (39590000)|HEAP_ALLOCATE|[2]|Bytes:16
15:59:50.039 (39601000)|STATEMENT_EXECUTE|[3]
15:59:50.039 (39606000)|HEAP_ALLOCATE|[2]|Bytes:8
15:59:50.039 (39612000)|STATEMENT_EXECUTE|[5]
15:59:50.039 (39642000)|STATEMENT_EXECUTE|[10]
15:59:50.039 (39650000)|HEAP_ALLOCATE|[5]|Bytes:68
15:59:50.039 (39678000)|SYSTEM_METHOD_ENTRY|[10]|System.HttpRequest.setEndpoint(String)
15:59:50.039 (39722000)|SYSTEM_METHOD_EXIT|[10]|System.HttpRequest.setEndpoint(String)
15:59:50.039 (39730000)|STATEMENT_EXECUTE|[12]
15:59:50.039 (39737000)|HEAP_ALLOCATE|[10]|Bytes:4
15:59:50.039 (39752000)|SYSTEM_METHOD_ENTRY|[12]|System.HttpRequest.setMethod(String)
15:59:50.039 (39773000)|SYSTEM_METHOD_EXIT|[12]|System.HttpRequest.setMethod(String)
15:59:50.039 (39779000)|STATEMENT_EXECUTE|[15]
15:59:50.039 (39803000)|SYSTEM_METHOD_ENTRY|[15]|System.HttpRequest.setTimeout(Integer)
15:59:50.039 (39824000)|SYSTEM_METHOD_EXIT|[15]|System.HttpRequest.setTimeout(Integer)
15:59:50.039 (39830000)|STATEMENT_EXECUTE|[17]
15:59:50.039 (39837000)|HEAP_ALLOCATE|[15]|Bytes:1
15:59:50.039 (39844000)|HEAP_ALLOCATE|[15]|Bytes:17
15:59:50.039 (39849000)|HEAP_ALLOCATE|[15]|Bytes:25
15:59:50.039 (39879000)|STATEMENT_EXECUTE|[18]
15:59:50.039 (39885000)|HEAP_ALLOCATE|[17]|Bytes:7
15:59:50.040 (40002000)|SYSTEM_MODE_ENTER|false
15:59:50.040 (40100000)|SYSTEM_METHOD_ENTRY|[18]|system.EncodingUtil.base64Encode(Blob)
15:59:50.040 (40174000)|SYSTEM_METHOD_EXIT|[18]|system.EncodingUtil.base64Encode(Blob)
15:59:50.040 (40184000)|SYSTEM_MODE_EXIT|false
15:59:50.040 (40190000)|HEAP_ALLOCATE|[18]|Bytes:43
15:59:50.040 (40201000)|STATEMENT_EXECUTE|[19]
15:59:50.040 (40207000)|HEAP_ALLOCATE|[18]|Bytes:13
15:59:50.040 (40226000)|SYSTEM_METHOD_ENTRY|[19]|System.HttpRequest.setHeader(String, String)
15:59:50.040 (40253000)|SYSTEM_METHOD_EXIT|[19]|System.HttpRequest.setHeader(String, String)
15:59:50.040 (40259000)|STATEMENT_EXECUTE|[20]
15:59:50.040 (40282000)|STATEMENT_EXECUTE|[21]
15:59:50.040 (40297000)|STATEMENT_EXECUTE|[23]
15:59:50.040 (40301000)|STATEMENT_EXECUTE|[23]
15:59:50.040 (40304000)|STATEMENT_EXECUTE|[25]
15:59:50.040 (40414000)|HEAP_ALLOCATE|[21]|Bytes:22
15:59:50.040 (40432000)|SYSTEM_METHOD_ENTRY|[25]|System.HttpRequest.getBody()
15:59:50.040 (40458000)|SYSTEM_METHOD_EXIT|[25]|System.HttpRequest.getBody()
15:59:50.040 (40463000)|HEAP_ALLOCATE|[25]|Bytes:22
15:59:50.040 (40488000)|SYSTEM_METHOD_ENTRY|[25]|System.debug(APEX_OBJECT, ANY)
15:59:50.040 (40507000)|USER_DEBUG|[25]|INFO|***HTTP Request Body:
15:59:50.040 (40516000)|SYSTEM_METHOD_EXIT|[25]|System.debug(APEX_OBJECT, ANY)
15:59:50.040 (40523000)|STATEMENT_EXECUTE|[27]
15:59:50.040 (40541000)|SYSTEM_METHOD_ENTRY|[27]|System.Http.send(ANY)
15:59:50.040 (40623000)|CALLOUT_REQUEST|[27]|System.HttpRequest[Endpoint=https://provide.castiron.com/env/Development/tube?object=Opportunity, Method=POST]
15:59:50.135 (135202000)|EXCEPTION_THROWN|[27]|System.CalloutException: handshake alert: unrecognized_name
15:59:50.135 (135280000)|HEAP_ALLOCATE|[27]|Bytes:39
15:59:50.135 (135300000)|SYSTEM_METHOD_EXIT|[27]|System.Http.send(ANY)
15:59:50.135 (135341000)|STATEMENT_EXECUTE|[29]
15:59:50.135 (135345000)|STATEMENT_EXECUTE|[31]
15:59:50.135 (135361000)|HEAP_ALLOCATE|[27]|Bytes:18
15:59:50.135 (135385000)|SYSTEM_METHOD_ENTRY|[31]|String.valueOf(Object)
15:59:50.135 (135417000)|HEAP_ALLOCATE|[31]|Bytes:60
15:59:50.135 (135425000)|SYSTEM_METHOD_EXIT|[31]|String.valueOf(Object)
15:59:50.135 (135430000)|HEAP_ALLOCATE|[31]|Bytes:78
15:59:50.135 (135443000)|SYSTEM_METHOD_ENTRY|[31]|System.debug(APEX_OBJECT, ANY)
15:59:50.135 (135460000)|USER_DEBUG|[31]|ERROR|***Call out erro: System.CalloutException: handshake alert: unrecognized_name
15:59:50.135 (135467000)|SYSTEM_METHOD_EXIT|[31]|System.debug(APEX_OBJECT, ANY)
15:59:50.135 (135474000)|STATEMENT_EXECUTE|[32]
15:59:50.135 (135482000)|HEAP_ALLOCATE|[31]|Bytes:20
15:59:50.135 (135505000)|SYSTEM_METHOD_ENTRY|[32]|System.HttpResponse.toString()
15:59:50.135 (135554000)|HEAP_ALLOCATE|[32]|Bytes:46
15:59:50.135 (135563000)|SYSTEM_METHOD_EXIT|[32]|System.HttpResponse.toString()
15:59:50.135 (135568000)|HEAP_ALLOCATE|[32]|Bytes:66
15:59:50.135 (135581000)|SYSTEM_METHOD_ENTRY|[32]|System.debug(APEX_OBJECT, ANY)
15:59:50.135 (135592000)|USER_DEBUG|[32]|INFO|***Response String: System.HttpResponse[Status=null, StatusCode=0]
15:59:50.135 (135598000)|SYSTEM_METHOD_EXIT|[32]|System.debug(APEX_OBJECT, ANY)
15:59:50.373 (137838000)|CUMULATIVE_LIMIT_USAGE
15:59:50.373|LIMIT_USAGE_FOR_NS|(default)|
Number of SOQL queries: 0 out of 100
Number of query rows: 0 out of 50000
Number of SOSL queries: 0 out of 20
Number of DML statements: 0 out of 150
Number of DML rows: 0 out of 10000
Number of code statements: 15 out of 200000
Maximum heap size: 0 out of 6000000
Number of callouts: 1 out of 10
Number of Email Invocations: 0 out of 10
Number of fields describes: 0 out of 100
Number of record type describes: 0 out of 100
Number of child relationships describes: 0 out of 100
Number of picklist describes: 0 out of 100
Number of future calls: 0 out of 10

15:59:50.373|TOTAL_EMAIL_RECIPIENTS_QUEUED|0
15:59:50.373|STATIC_VARIABLE_LIST|
String:_static_password:0
Boolean:TRUE:0
long:serialVersionUID:0
double:MIN_NORMAL:0
double:POSITIVE_INFINITY:0
Blob:_static_headerValue:0
double:MIN_VALUE:0
int:SIZE:0
int[]:sizeTable:0
char[]:DigitOnes:0
char[]:DigitTens:0
double:NaN:0
String:_static_authorizationHeader:0
double:NEGATIVE_INFINITY:0
int:MIN_VALUE:0
int:SIZE:0
boolean:$assertionsDisabled:0
double:MAX_VALUE:0
String:_sfdcSuppressedCodeLocations:0
long:serialVersionUID:0
int:MAX_EXPONENT:0
String:_sfdcSuppressedCodeLocations:0
String:_static_userName:0
int:MIN_EXPONENT:0
Boolean:FALSE:0
int:MAX_VALUE:0
char[]:digits:0
long:serialVersionUID:0
String:_sfdcAdditionalCodeLocations:0

15:59:50.373|CUMULATIVE_LIMIT_USAGE_END

15:59:50.138 (138110000)|CODE_UNIT_FINISHED|execute_anonymous_apex
15:59:50.138 (138119000)|EXECUTION_FINISHED
15:59:50.376|CUMULATIVE_PROFILING_BEGIN
15:59:50.376|CUMULATIVE_PROFILING|No profiling information for SOQL operations
15:59:50.376|CUMULATIVE_PROFILING|No profiling information for SOSL operations
15:59:50.376|CUMULATIVE_PROFILING|No profiling information for DML operations
15:59:50.376|CUMULATIVE_PROFILING|method invocations|
External entry point: public static void execute(): executed 1 time in 97 ms
AnonymousBlock: line 27, column 1: global System.HttpResponse send(ANY): executed 1 time in 95 ms
AnonymousBlock: line 32, column 1: global String toString(): executed 2 times in 0 ms
AnonymousBlock: line 19, column 1: global void setHeader(String, String): executed 1 time in 0 ms
AnonymousBlock: line 18, column 1: global static String base64Encode(Blob): executed 1 time in 0 ms
AnonymousBlock: line 25, column 1: global String getBody(): executed 2 times in 0 ms
AnonymousBlock: line 10, column 1: global void setEndpoint(String): executed 1 time in 0 ms
AnonymousBlock: line 12, column 1: global void setMethod(String): executed 1 time in 0 ms
AnonymousBlock: line 31, column 1: global public static String valueOf(Object): executed 2 times in 0 ms
AnonymousBlock: line 15, column 1: global void setTimeout(Integer): executed 1 time in 0 ms

15:59:50.376|CUMULATIVE_PROFILING_END

allen.zhangyilun
August 14, 2013
Like
0

1 replies

Still have 1000 record limitation in collection in the Spring release

We know the "Severity Definitions", but if not a Critical case none will deal with our case but we are waiting for the response. 18.0 but still got “System.Exception: Too many query rows: 501”, it’s says after Sprint release wouldn’t have 1000 record limitation, but seams not.

[select Id, Product__r.Name, Extract_Product_Name__c, Product_name_Chinese__c,Product_Id__c, Delivery_Date__c, Delivery_Normal__c, Delivery_Rag__c, Delivery_Rewash__c, Delivery_Sum__c, Billing_Amount_by_DN__c from Case_Product__c where Service_Maintenance_Contract_Id__c = :ServiceContractId and Billing_Start_Date__c = 'true' and Billing_End_Date__c = 'true' and Delivery_Sum__c > 0 ORDER BY Extract_Product_Name__c ASC limit 1000];

allen.zhangyilun
May 21, 2010
Like
0

2 replies

If this button is an s-control and recommended by Salesforce?

allen.zhangyilun
July 20, 2017
Like
0

6 replies

System.QueryException: Non-selective query against large object type for Pricebook2

10:20:24.169 (169594000)|SOQL_EXECUTE_BEGIN|[26]|Aggregations:0|select Id, Name, isStandard from Pricebook2 where ((Name != null and Name = :tmpVar1) or isStandard = true)
10:20:24.174 (174329000)|EXCEPTION_THROWN|[26]|System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing.
Even if a field is indexed a filter might still not be selective when:
1. The filter value includes null (for instance binding with a list that contains null)
2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times)
10:20:24.174 (174692000)|FATAL_ERROR|System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contact salesforce.com about custom indexing.
Even if a field is indexed a filter might still not be selective when:
1. The filter value includes null (for instance binding with a list that contains null)
2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times)

How can I set a external ID on pricebook2?

allen.zhangyilun
August 26, 2013
Like
0

SOLVED

3 replies

System.CalloutException: handshake alert: unrecognized_name

15:59:50.373|CUMULATIVE_LIMIT_USAGE_END

15:59:50.376|CUMULATIVE_PROFILING_END

allen.zhangyilun
August 14, 2013
Like
0

6 replies

Chatter Feed Item and Attachment + insufficient privileges error

I am having trouble inserting a list of chatter feed items of type 'ContentPost'. These feed items are being dynamically created for a list of contacts/campaign members (post.ParentId = 'contact id goes here') associated to a campaign; as well as the campaign itself. While I am iterating over the list of contacts I am also creating an attachment for each of them then
associating this attachment to the feed item. Both Attachments and Feed Items are added to separate lists then post for loop are inserted into the database.

I am able to successfully insert the chatter feed items (as text post posts, not content) if I don't associated the attachments, however when I associate the attachment body to the content data field of the feed item I get the following error:

Insert failed. First exception on row 0; first error: INVALID_ID_FIELD, You do not have the level of access necessary to perform the operation you requested. Please contact the owner of the record or your administrator if access is necessary.: []

I am running this as a system administrator on our dev sandbox, so I'm not sure what is causing this insufficient privileges error. I would appreciate any help on this, and if needed I can provide a more technical description with code snippets of the logic.

alex51atlas
November 23, 2011
Like
0

1 replies

Still have 1000 record limitation in collection in the Spring release

allen.zhangyilun
May 21, 2010
Like
0

3 replies

Upserting data into PriceBookEntry table

We need to do a daily upsert of Pricing data from our quoting tool into the PriceBookEntry table in SFDC. Problem is that we cannot create a custom field in PriceBookEntry in SFDC, that can store the unique Pricing ID from the quoting tool, which can be used for the daily upsert process using Cast Iron. Also, we cannot get the PriceBookEntry IDs to be stored in a custom object, as you cannot write triggers on PriceBookEntry!

Has anyone encountered a similar scenario wherein there is a requirement for synchronizing the PriceBookEntry table between an external system and SFDC??

anuparora
March 16, 2010
Like
0

SOLVED

3 replies

I can't see my visualforce tabs in 'Add Tabs to Your Default Display'

I synchronies my visualforce tab (put it from eclipse to salesforce.com). I can see it in AppSetup->Create->Tabs->VisualForce tab. I can see it when I wan to choose it in AppSetup->Create->Apps-CustomAppEdit->Choose the tabs. I add it (that's work), but I can't see in the top of the page (neither when I want to use it in 'customize My tabs'.

Is anybody know, what's the problem?

AvLav
January 20, 2010
Like
0

SOLVED

6 replies

UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record

In my afterinsert trigger on Lead , I want to update one of the fields in the current Lead records being inserted .I cannot do this in before insert since Iam dependent on the ID's of the newly inserted leads .

Getting the below error-

LeadTrigger: execution of AfterInsert caused by: System.DmlException: Update failed. First exception on row 0 with id 00QT0000005JQ05MAG;

first error: UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record: []

any one encountered this issue?

msreekm
November 10, 2009
Like
0