ORA-01756 when uploading to collection manager
edited Sep 9, 2020 2:08PM in AHF - Autonomous Health Framework (TFA - ORACHK) (MOSC) 2 commentsAnswered
When uploading to collection manager, some INSERT statements are malformed.
insert into AUDITCHECK_RESULT(collection_date,check_name,param_name,status,status_message,actual_value,recommended_value,comparison_operator,hostname,instance_name,check_type,db_platform,os_distro,os_kernel,os_version,db_version,cluster_name,db_name,check_id,needs_running,modules,database_role,clusterware_version,global_name,upload_collection_name,auditcheck_result_id,target_type,target_value) values(to_date('14-Apr-2015 13:04:40','DD-MON-YYYY HH24:MI:SS'),'Verify if Agent's Registry file exists' .....
It seems that the value 'Verify if Agent's Registry file exists' is being inserted as CHECK_NAME. Note the bare single quote in the word "Agent's"
0