I have a DOS app that reads data from a fixed length text files that are xcopied from a Netware server, updates them, prints the output to a line matrix printer, reformats and copies them to a unix server via a named pipe.  Is there any similar functionality is Salesforce?   We have many users using this so I would like to retain the feel of the DOS app, but get it into a more modern platform.  It has been requested that we leverage our existing Salesforce instance to do so.

I maintain a custom app and in the past week, I have been getting a lot of errors that look like this:

Error: java.sql.SQLException: ORA-00001: unique constraint (CORE.AKAPEX_CLASS) violated ORA-06512: at “DOPEY.CAPEX”, line 505 ORA-06512: at line 1 : {call cApex.update_class(?,?,?,?,?,?,?,?,?,?,?,?)})}

Sometimes, they are from SLEEPY.CAPEX or SNEEZY.CAPEX. 

Other times they are from SLEEPY.SACCESS or BASHFUL.ASSERT.   What could be happening?

Everything was working fine for the past several months and nothing has changed.  Why would this suddenly start happening

My development lead wants to return an large number of rows of data (no more than 1 million)  from a Salesforce based custom object and then use jquery to present them to users in a single page.  What is the best way to accomplish this?   My development lead is not willing to accept any other options.

I am new to salesforce but have lots of experience in java programming.  I have a need to dereference a null object in an apex class, but I am unable to do so.  Please advise me on the proper way to dereference a null object in apex.

Hi,

We have a package that needs to query numerous contacts by email address. It could be as many as 50 email addresses. Typically, we use a bulk query like:

Set<String> EmailSet = new Set<String>();
//EmailSet is populated
[Select Id From Contact Where Email in :EmailSet];

 This works fine in orgs with fewer than 100k contacts, but we get non-selective query errors when there are more than 100k contacts. According to Salesforce, Contact Email is indexed, so the error is likely due to the IN operator. A (poor) alternative is to query a single email address at a time, which does successfully avoid the non-selective error, but then we quickly exhaust the 100 SOQL query governor limit since there is a lot of other processing going on aside from the contact retrieval. So we're stuck here - we can't use an efficient bulk query since it throws an error, and we can't use multiple selective queries since we hit the governor limit. Does anybody have advice on how to approach selecting a set of records from a 100k+ count object?

Thanks,
Earl

I am trying to create a user using Apex class for which I have written the following code.

<Previous Code>
User user = new User();

Hi,

I am having this error.

First error: Insert failed. First exception on row 0; first error: STORAGE_LIMIT_EXCEEDED, storage limit exceeded: []

Tried deleting the records by using data loader but no success, also tried it by deleting the record by selecting all and deleting but the error comes

Cannot delete last list view. You can't delete the last list view that's Visible to all users or Visible to certain groups of users.

Please help. Trigger I am getting only of 36%. Please help.

trigger BusinessSegment on Opportunity (before insert) {

    for(Opportunity op: Trigger.new){

        if(op.Solution_Offering__c=='Audit/Compliance'&& (op.Business_Application__c=='Audit Management' ||op.Business_Application__c=='Financial Audit Management'||op.Business_Application__c=='Regulato​ry Audit Management') ){

            op.Use_Type_Class__c='Audit/Compliance' ;

            op.Use_Type__c='Financial Audit';

            op.Solution__c='IL Exchange' ;             

        }

    }

{

for(Opportunity opp: Trigger.new){

        if(opp.Solution_Offering__c=='Audit/Compliance'&& opp.Business_Application__c=='Compliance Management' ){

            opp.Use_Type_Class__c='Audit/Compliance' ;

            opp.Use_Type__c='Other Audit/Compliance';

            opp.Solution__c='Compliance Link';

        }  

}

}

{

for(Opportunity opp1: Trigger.new){

        if(opp1.Solution_Offering__c=='Fund Management'&&

        (opp1.Business_Application__c=='Investor Reporting'

         || opp1.Business_Application__c=='Portfolio Company Reporting'

           || opp1.Business_Application__c=='AI Fundraising'  )){

            opp1.Use_Type_Class__c='Financing/Capital Financing' ;

            opp1.Use_Type__c='AI Fundraising';

            opp1.Solution__c='IL Exchange';

        }  

}

}

{

for(Opportunity opp2: Trigger.new){

        if(opp2.Business_Application__c=='None' ){

            opp2.Use_Type_Class__c='General' ;

            opp2.Use_Type__c='Other (Specify in Description box)';

            opp2.Solution__c='IL Exchange';

        }  

}

}

{

for(Opportunity opp3: Trigger.new){

        if(opp3.Solution_Offering__c=='Corporate Services'&&

        (opp3.Business_Application__c=='Contract Management'

        || opp3.Business_Application__c=='Vendor Management'

         || opp3.Business_Application__c=='Investor Reporting'

          || opp3.Business_Application__c=='Regulatory Reporting') ){

            opp3.Use_Type_Class__c='General' ;

            opp3.Use_Type__c='Contract Management';

            opp3.Solution__c='IL Exchange';

        }  

}

}

{

for(Opportunity opp4: Trigger.new){

        if(opp4.Solution_Offering__c=='Strategic Transactions'&&

        (opp4.Business_Application__c=='Financing/Capital Raising'

        || opp4.Business_Application__c=='IPO'

         || opp4.Business_Application__c=='JV/Alliance Management'

          || opp4.Business_Application__c=='Acquisition Mgmt (Buy-side)'

           || opp4.Business_Application__c=='Bankruptcy/Restruct​uring'  ) ){

            opp4.Use_Type_Class__c='Financing/Capital Financing' ;

            opp4.Use_Type__c='IPO';

            opp4.Solution__c='IL Exchange';

        }  

}

}

{

for(Opportunity opp5: Trigger.new){

        if(opp5.Solution_Offering__c=='Strategic Transactions'&& opp5.Business_Application__c=='Licensing' ){

            opp5.Use_Type_Class__c='Licensing & Strategic Alliances' ;

            opp5.Use_Type__c='Licensing';

            opp5.Solution__c='Compliance Link';

        }  

}

}

}

Apex Class:

@isTest

private class testMyBusinessSegment {

Public static testMethod void testTBusinessSegment ()

{

Opportunity opp = new Opportunity();

opp.name = 'Test - New Mapping';

opp.Type = 'Transaction - New';

opp.Region__c = 'Americas';

opp.Template__c='Blocks';

opp.StageName = 'Propose';

opp.dlDealType__c = 'Micro Deal';

opp.Solution_Offering__c= 'Audit/Compliance';

opp.Business_Application__c= 'Audit Management';

insert opp;

}

{

Opportunity oppp = new Opportunity();

oppp.name = 'Test - Trigger 1';

oppp.Type = 'Transaction - New';

oppp.Region__c = 'Americas';

oppp.Template__c='Blocks';

oppp.StageName = 'Propose';

oppp.dlDealType__c = 'Small Deal';

oppp.Solution_Offering__c= 'Audit/Compliance';

oppp.Business_Application__c= 'Compliance Management';

insert oppp;

}

{

Opportunity oppp1 = new Opportunity();

oppp1.name = 'Test - Trigger 21';

oppp1.Type = 'Transaction - New';

oppp1.Region__c = 'Americas';

oppp1.Template__c='Blocks';

oppp1.StageName = 'Propose';

oppp1.dlDealType__c = 'Small Deal';

oppp1.Solution_Offering__c= 'Fund Management';

oppp1.Business_Application__c= 'AI Fundraising';

insert oppp1;

}

}

Since this weekend we've been getting "Query of LOB fields caused heap usage to exceed limit" from various organizations that have our AppExchange packages installed. Presumably this is due to a change to memory usage enforcement in the Winter 12 release, but I can't find any information about it in the release notes or elsewhere. Obviously, this is caused by queries returning too much data, but what specifically has changed to cause this error when it has never occurred before?

I am new to salesforce but have lots of experience in java programming.  I have a need to dereference a null object in an apex class, but I am unable to do so.  Please advise me on the proper way to dereference a null object in apex.