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
Ram-SFRam-SF 

Internal System Error:

While i am trying this code i got Internal Salesforce error

 

List<sObject> verList = [SELECT Id,KnowledgeArticleId,PublishStatus FROM KnowledgeArticleVersion
WHERE PublishStatus='Online' AND  KnowledgeArticleId in (SELECT ParentId
FROM KnowledgeArticleViewStat )];
System.debug(':::'+verList);

 

Is there any reason?..

super developersuper developer

This Query is right check other code in your trigger/controller..
Ram-SFRam-SF

i tried this code only in System log.

 

(it comes under controller only)
super developersuper developer

I have tried same in system log.

 

I am getting results. So there is no problem with Query.
Ram-SFRam-SF

this was my debug log show

 

 

21.0APEX_CODE,DEBUG;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO
Execute Anonymous: List<sObject> verList = [SELECT Id,KnowledgeArticleId,PublishStatus FROM KnowledgeArticleVersion
Execute Anonymous: WHERE PublishStatus='Online' AND KnowledgeArticleId in (SELECT ParentId
Execute Anonymous: FROM KnowledgeArticleViewStat )];
Execute Anonymous: System.debug(':::'+verList);
07:21:02.026|EXECUTION_STARTED
07:21:02.026|CODE_UNIT_STARTED|[EXTERNAL]|execute_anonymous_apex
07:21:02.027|SOQL_EXECUTE_BEGIN|[1]|Aggregations:0|SELECT Id,KnowledgeArticleId,PublishStatus FROM KnowledgeArticleVersion
WHERE PublishStatus='Online' AND KnowledgeArticleId in (SELECT ParentId
FROM KnowledgeArticleViewStat )
07:21:02.042|FATAL_ERROR|Internal Salesforce.com Error
07:21:02.626|CUMULATIVE_LIMIT_USAGE
07:21:02.626|LIMIT_USAGE_FOR_NS|(default)|

 

 

 
bob_buzzardbob_buzzard

Internal server errors usually require Salesforce assistance to solve.  It means that an error has occured that was not handled by the platform.  

 

One thing to check though - do you have any dynamic SOQL later on in the transaction?  I've found that if I generate illegal SOQL syntax this will cause an internal server error.
Ram-SFRam-SF

I need to query the Article type(FAQ__kav) with top 10 Normalised score....

Bob, Super_developer says he get some results using my query...If possilbe guide me to write the right query to my above need

 

 

Thanks
Ram-SFRam-SF

Thanks Friends.

Answer found here(to my need) FAQ__viewstat is the trick....:smileyhappy:

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_knowledgearticleviewstat.htm#sforce_api_objects_knowledgearticleviewstat