I had a similar issue with saving 6 different models in JavaScript callbacks. If the user would get it right the first time everything worked great. However if there were any errors and the user tried to rectify the error, we ended up with some models saved and some unsaved and the Invalid Reference ID error. I realized that it was much easier to do a callout to an apex method. The added benefit of an apex callout is the ability to rollback transactions if anything goes wrong. You will need an external snippet with this: “/soap/ajax/29.0/apex.js”. And then in your code you can use:

sforce.apex.execute(“YOURCLASSNAME”, “YOURMETHODNAME”,                
{
     YOURFIRSTPARAMETER : value1,
     YOURSECONDPARAMETER : value2

 });.

Hope this helps.

Barry,

We are aware of this limitation in Skuid and are working to resolve it for our Summer 14 release — it’s a very significant issue, and we don’t want this to be a reason for users to have to write custom Apex.

There are two parts to our plan to resolve this:

(a) Allow for a “Rollback all saves if any errors occur” option to be specified anywhere that multi-Model Saves can be initiated, e.g. in Page Title Save and Save/Cancel Buttons, or via JavaScript’s skuid.model.save(modelsArray) method. This would basically set a Savepoint at the beginning of the Save transaction, and if there is an error in any DML operation Skuid performs as part of the save, then a Database.rollback() will be called to restore the state of the database as of the Savepoint.

(b) Fix the “bad reference” problem with temporary Ids, so that whether or not you use the “Rollback on error” option, your Models will not be come dysfunctional if there is an error somewhere along the multi-Model save chain.

Regards,

Zach

On a lighter note, I was very pleasantly amused when I first read the title of this post: “transnational integrity” made me think there was a problem with our Internationalization framework

Zach - Glad I could provide a little levity! I realize that I had multiple spelling errors in the original post - if one of the mods is able to feel free to correct my mistakes. Regarding the transactional capability and “bad reference” very encouraged to hear that there might be a resolution in Summer '14. Is there anything that you can suggest as workarounds in the meantime? Moshe - Appreciate your insight. Would you be willing to share some more details on the approach you took? Did you pass all the data needed down to the apex method and save in there? In your case with 6 models, that seems like a fairly heavy call. Did all of your “save” buttons become “call custom snippet” and then that snippet invoked the apex method? Thanks guys!

Actually I had one save button at the end of a long Create Opportunity page which saves the Opportunity along with a potential Campaign, Account, Management Company and Contact (with an Account). The approach that I took was to use one custom save button for everything, to make our users have less clicks. Then I passed all the information from the page into the apex method. And the apex method went through the parameters and decided what to save and in what order.This is an initial draft that I have here:

// save opportunity
// get the models
var opportunityModel = skuid.model.getModel(‘Opportunity’);
var accountModel = skuid.model.getModel(‘Account’);
var contactModel = skuid.model.getModel(‘Contact’);
var campaignModel = skuid.model.getModel(‘Campaign’);
var managementCompanyModel = skuid.model.getModel(‘ManagementCompany’);
var Electricity = skuid.$M(‘Electricity’);
var Gas = skuid.$M(‘Gas’);
// get the pricing rec type
var recType = skuid.$M(‘PricingRecordType’);
var pricingRecType = recType.getFieldValue(recType.getFirstRow(),‘Id’);
// get the plymouth house account which will be the agent for every opportunity
var houseAccountModel = skuid.$M(‘PlymouthHouse’);
var houseAccount = houseAccountModel.getFieldValue(houseAccountModel.getFirstRow(),‘Id’);
// get the model fields
var opportunityRow = opportunityModel.getFirstRow();
var opportunityModelAccount = opportunityModel.getFieldValue(opportunityRow, ‘AccountId’);
var opportunityModelContact = opportunityModel.getFieldValue(opportunityRow, ‘Contact__c’);
var opportunityModelCampaign = opportunityModel.getFieldValue(opportunityRow, ‘CampaignId’);
var opportunityModelManagementCompany = opportunityModel.getFieldValue(opportunityRow, ‘Management_Company__c’);

opportunityModelAccount = (opportunityModelAccount == null || opportunityModelAccount.length <= 0) ? null : opportunityModelAccount;
opportunityModelCampaign = (opportunityModelCampaign == null || opportunityModelCampaign.length <= 0) ? null : opportunityModelCampaign;
opportunityModelManagementCompany = (opportunityModelManagementCompany == null || opportunityModelManagementCompany.length <= 0) ? null : opportunityModelManagementCompany;

console.log('opportunityModelAccount ’ + opportunityModelAccount);
console.log('opportunityModelCampaign ’ + opportunityModelCampaign);
console.log('opportunityModelManagementCompany ’ + opportunityModelManagementCompany);


var accountRow = accountModel.getFirstRow();
var accountName = accountModel.getFieldValue(accountRow, ‘Name’, true);
var accountBillingStreet = accountModel.getFieldValue(accountRow, ‘BillingStreet’, true);
var accountBillingCity = accountModel.getFieldValue(accountRow, ‘BillingCity’, true);
var accountState = accountModel.getFieldValue(accountRow, ‘BillingState’, true);
var accountPostal = accountModel.getFieldValue(accountRow, ‘BillingPostalCode’, true);
var accountPhone = accountModel.getFieldValue(accountRow, ‘Phone’, true);
var accountTaxNumber = accountModel.getFieldValue(accountRow, ‘c2g__CODATaxpayerIdentificationNumber__c’, true);

var managementCompanyRow = managementCompanyModel.getFirstRow();
var manCoName = managementCompanyModel.getFieldValue(managementCompanyRow, ‘Name’, true);
var manCoBillingStreet = accountModel.getFieldValue(managementCompanyRow, ‘BillingStreet’, true);
var manCoBillingCity = accountModel.getFieldValue(managementCompanyRow, ‘BillingCity’, true);
var manCoState = accountModel.getFieldValue(managementCompanyRow, ‘BillingState’, true);
var manCoPostal = accountModel.getFieldValue(managementCompanyRow, ‘BillingPostalCode’, true);
var manCoPhone = accountModel.getFieldValue(managementCompanyRow, ‘Phone’, true);

var campaignRow = campaignModel .getFirstRow();
var campaignName = campaignModel.getFieldValue(campaignRow, ‘Name’, true);
var campaignParent = campaignModel.getFieldValue(campaignRow, ‘ParentId’, true);
var campaignDescr = campaignModel.getFieldValue(campaignRow, ‘Description’, true);
var campaignContactId = campaignModel.getFieldValue(campaignRow, ‘Contact__c’, true);

var contactRow = contactModel.getFirstRow();
var contFirstName = campaignModel.getFieldValue(contactRow, ‘FirstName’, true);
var contLastName = campaignModel.getFieldValue(contactRow, ‘LastName’, true);
var contAgentId = campaignModel.getFieldValue(contactRow, ‘AccountId’, true);
var contactEmail = campaignModel.getFieldValue(contactRow, ‘Email’, true);
var contactPhone = campaignModel.getFieldValue(contactRow, ‘Phone’, true);

var gasCommiss = Gas.getFieldValue(Gas.getFirstRow(),‘Default_Commission_Rate__c’,true);
var elecCommiss = Electricity.getFieldValue(Electricity.getFirstRow(),‘Default_Commission_Rate__c’,true);
var commodityName = opportunityModel.getFieldValue(opportunityRow,‘Commodity__r.Name’, true);
var currentName = opportunityModel.getFieldValue(opportunityRow, ‘Name’, true);      
var commodityId = opportunityModel.getFieldValue(opportunityRow,‘Commodity__c’, true);
var salesSupport = opportunityModel.getFieldValue(opportunityRow, ‘Sales_Support_Representative__c’, true);

if(currentName != null && currentName != ‘’ && salesSupport != null && salesSupport != ‘’ && 
    ((opportunityModelCampaign != ‘’ && opportunityModelCampaign != null) || (campaignName != null && campaignName != ‘’ && 
            ((campaignContactId != null && campaignContactId != ‘’) || (contLastName != null && contLastName != ‘’))))){
    var returnValue;
    var success = true;
    try{
        returnValue = sforce.apex.execute(“CreateOpportunityWebservice”, “createOpportunity”, 
                {oppModelAccountId : opportunityModelAccount,
                    accName : accountName,
                    accBillingStreet : accountBillingStreet,
                    accBillingCity : accountBillingCity,
                    accBillingState : accountState,
                    accZip : accountPostal,
                    accPhone : accountPhone,
                    accTaxNum : accountTaxNumber,
                    oppModelManCoId : opportunityModelManagementCompany,
                    manName : manCoName,
                    manBillingStreet : manCoBillingStreet,
                    manBillingCity : manCoBillingCity,
                    manBillingState : manCoState,
                    manZip : manCoPostal,
                    manPhone : manCoPhone,
                    oppModelCampaign : opportunityModelCampaign,
                    campName : campaignName,
                    campParentCamp : campaignParent,
                    campDescr : campaignDescr,
                    contactId : campaignContactId,
                    agentId : contAgentId,
                    contactFirstName : contFirstName,
                    contactLastName : contLastName,
                    conEmail : contactEmail,
                    conPhone : contactPhone,
                    gasCommission : gasCommiss,
                    electricCommission : elecCommiss,
                    commodName : commodityName,
                    oppName : currentName,
                    houseAccountId : houseAccount,
                    commodId : commodityId,
                    salesSupportId : salesSupport
           });
        } catch (err) {
        alert('An error has occurred. Please try again or contact support with the following message included: ’ + err + '; ’ + returnValue + ‘;’);
            success = false;
        }
        console.log(returnValue);
        if(success == true)
            window.location = returnValue;
}
else{
    if(currentName == null || currentName == ‘’)
        alert(‘Opportunity needs a name.’);
    else if(salesSupport == null || salesSupport == ‘’)
        alert(‘Opportunity needs a Sales Support Representative.’);
    else if(opportunityModelCampaign == null || opportunityModelCampaign == ‘’){
        if(campaignName == null || campaignName == ‘’)
            alert(‘Opportunity needs an existing Campaign or a created Campaign with a Name’);
        else if((campaignContactId == null || campaignContactId == ‘’) && (contLastName == null || contLastName == ‘’))
            alert(‘Campaign that was attempted to be created needs a Contact or a created Contact with a Last Name’);
    }
}

Moshe - Thank you again, extremely helpful to see how you approached this! Very much appreciate you taking the time to reply and provide your insight. Seems as though both of us have rather complex data management scenarios we are using Skuid to help solve for

I believe this issue has been resolved as of the Summer 14 release.