function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Administrator 359Administrator 359 

ora - 00904

Hi All,
I am trying to deploy a changeset but I am getting the below error from a test class although it is working on the sandbox and it was not giving this error before for previous deployments
 
ClinicTriggerUnDelete_Test  System.DmlException: Undelete failed. First exception on row 0 with id a040Y00000NDcrIQAT; first error: UNKNOWN_EXCEPTION, common.exception.SfdcSqlException: ORA-00904: "C"."CONVERSION_RATE": invalid identifier select /*SummaryFieldUtil summary query*/ /*+ ordered use_nl(v cf) */ nvl(sum(1),0) rsf1,nvl(sum(TO_NUMBER(cf.val41)),0) rsf2,nvl(sum(TO_NUMBER(cf.val44)/ c.conversion_rate),0) rsf3, v.foreign_key_id "parent_id" from (select * from table(cast(? AS ID_ARRAY))) t, core.custom_foreign_key_value v, core.custom_entity_data cf where v.organization_id = ? and v.foreign_key_id = t.column_value and v.key_prefix = ? and v.index_num = ? and v.deleted = '0' and cf.organization_id = v.organization_id and v.entity_id = cf.custom_entity_data_id a
Stack Trace: Class.ClinicTrigger_Test.ClinicTriggerUnDelete_Test: line 142, column 1
and here is the test method that is causing the error
@isTest 
    static void ClinicTriggerUnDelete_Test() {
        List<Clinic__c> clinicList = new List<Clinic__c>([SELECT Id, Name FROM Clinic__c]);
        List<User_Clinic__c> userClinicList = new List<User_Clinic__c>([SELECT Id, Name FROM User_Clinic__c]);
        List<User_Examination_Room__c> userRoomList = new List<User_Examination_Room__c>([SELECT Id, Name FROM User_Examination_Room__c]);
        
        delete userRoomList;
        delete userClinicList;
        delete clinicList;
        
        Test.startTest();
        
        undelete clinicList;
        
        Test.stopTest();
    }


 
Shamsi 110Shamsi 110
check your line number 142