As a follow up on this issue:
I later found that changing anything in the GUI would give the error before doing the below command line change so it really had nothing
to do with the storage unit.
Also today I realized the SQL 2000 backups were not running properly although they were exiting with status 0. Investigation into
that revealed that running the below command line also caused the policy type to change from MS-Sql-Server to Standard. Since the backup specification was for Windows bch files what it was doing was just backing up those bch files rather than running the
bch files to backup the database. On changing type back to MS-Sql-Server they began running properly.
I believe this was all a holdover for an earlier issue last year. At that time my co-worker had attempted to manually edit the policies
en masse in /usr/openv/netbackup/db/class. When he did that it caused us various issues including converting policy types to Standard. We had fixed most of that at the time. I think these SQL backups didn’t get converted then for some unknown reason
but did get put in an odd state where one couldn’t change via the GUI as we discovered this week. When I ran the command line below I think it fixed the policy and set it to use the desired storage unit but then triggered the same policy type change we’d
seen last year..
Moral of the story:
Do NOT manually edit /usr/openv/netbackup/db/class stuff in NBU 6.5.4 or greater (probably NBU 6.0 or greater) because it stores a checksum.
Use the GUI or NBU command line tools.
P.S. One thing you CAN do with stuff in class is copy an entire policy subdirectory from one master to another – the checksum is still
valid. We did that when moving most of our policies from NBU 6.5.4 to NBU 7.1 on another host and saw no issues doing it.
From: Lightner, Jeff
Sent: Wednesday, July 13, 2011 11:20 AM
To: 'nbuser'
Cc: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: RE: [Veritas-bu] Uncofigured server group (Any) when trying to change storage unit for policy
Thanks - The command line worked: “bpplinfo Sql-WaterCom-New -set -residence atubks01_atldd03“
On checking the policy after running that it has the master’s storage unit at intended. I’m still wondering why the GUI complained
though.
On your other questions:
I’m not sure what a “refresh” would do - I pulled up the console and attempted to make the change so it should already have been “fresh”
at the time I attempted it.
Doing through the Java GUI prior to trying the above command line resulted in the following: Since I put the exact text of the error
message in my original email I’m not sure what the screen shot will tell you.
From: nbuser [mailto:nbuser AT live DOT com]
Sent: Wednesday, July 13, 2011 11:05 AM
To: Lightner, Jeff
Cc: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: Re: [Veritas-bu] Uncofigured server group (Any) when trying to change storage unit for policy
did you refresh the policies in the console and tried. You can also change the storage unit from command line by "bpplinfo policyname -set
-residence stuname" also if you can please paste the screenshot of the error that would be really helpful
On Wed, Jul 13, 2011 at 7:39 AM, Lightner, Jeff <JLightner AT water DOT com> wrote:
NBU 6.5.4 HP-UX Unix master, Windows 2000 client with SQL 2000 DB
Currently we are running a backup for the above environment using a separate Windows media server so
have defined the storage unit as the one on that media server. This is the only backup on that media server (and master) and we want to free up the media server and have the backup handled by the master (which is also a media server).
On trying to modify the policy to change the storage unit from the one appropriate for the Windows media
server to the one appropriate to the master (which are both the same physical dedupe appliance) we get the following error window popup:
An error occurred while changing policy ‘’Sql-WaterCom’, status:144
Unconfigured server group (Any) for –sg options specified
I found nothing at all on this error when searching for it. Status 144 is a generic invalid options
error so there is no detail on it. The “Any” it is showing above so far as I can tell is the reference to the greyed out “Media Owner” area of the Policy attributes. I also get the same errors on other Windows non-sql backups on trying to move them. However,
if I move one of my HP-UX jobs to the windows storage unit that works and it then lets me move it back without the error. If I create a new policy with the same parameters as the original Windows 2000 SQL 2000 policy it lets me select the HP-UX storage unit.
Has anyone seen this and have any ideas as to how to resolve other than recreating the policies from
scratch? (Copying doesn’t work – the copy has the same issue as the original.)
__________________________________________________________________________________________
Jeff Lightner
|
UNIX/Linux Administrator
|
DS Waters of America, Inc
|
5660 New Northside Drive, Ste 250 |
Atlanta,
GA 30328
(:
(Direct Dial)
678-486-3516
|(:
(Cell)
678-772-0018
|
*:jlightner AT water DOT com
Proud partner. Susan G. Komen for the Cure.
Please consider our environment
before printing this e-mail or attachments.
----------------------------------
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information
is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.
----------------------------------
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
