Skip to Content
0
Feb 10, 2011 at 07:32 PM

11g upgrade question - is BW system but is reported as NOT one.

55 Views

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