I am running the pre-upgrade script and there is a section that looks like this:
check_info('Check for SAP BW system');
BEGIN
sap_bw := FALSE;
FOR obj IN (SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'RSADMINA' and owner like 'SAP%' and length(owner) = 6) LOOP
display_trace('RSADMINA-owner: ' || obj.owner);
BEGIN
BEGIN
EXECUTE IMMEDIATE 'SELECT bwmandt from ' || obj.owner || '.RSADMINA ' INTO sap_bwmandt;
EXCEPTION
WHEN OTHERS THEN NULL;
END;
display_trace('BW Mandt: ' || sap_bwmandt);
display_trace('Length(BW Mandt): ' || nvl(length(ltrim(sap_bwmandt, ' ')),0));
--if length(sap_bwmandt) > 0 then
if nvl(length(ltrim(sap_bwmandt, ' ')),0) > 0 then
sap_bw := TRUE;
sap_bw_status := 'YES';
else
sap_bw := FALSE;
sap_bw_status := 'NO';
end if;
END;
END LOOP;
EXCEPTION
WHEN NO_DATA_FOUND THEN
sap_bw_status := 'UNKNOWN';
END;
I AM upgrading a BW system. Why did this return a FALSE? is this something I need to be concerned about?
Currently running 10.2.0.4 on HP-UX 11.31