You need to sign in to do that
Don't have an account?
Administrator 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
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 1and 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 110
check your line number 142