Creating Windows OS Distribution Fails Due to Upgrade Problem (6405983)

If you upgrade from N1SM version 1.2 to 1.3, the create os command will fail for Windows with the following error message:

Error 1:
Description: INFO   : Info: 2003SE : windows : x86
INFO   : Info 2:
DBD::Pg::db do failed: ERROR:  Relation "as_distro" has no column
"ris_id" at /opt/sun/scs/lib/perl5/SCSDB.pm line 241.
INFO   : ERROR creating distro win2k3se32sp1
INFO   : Creating windows distrobution failed

Workaround: You must perform the following procedure on the management server and try the create os command again:

1. Become root on the management server.

2. Start the N1SM database program:

   • For Linux management server:

     # /opt/sun/scs/sbin/db_tool.pl psql

   • For Solaris management server:

     # /opt/SUNWscs/sbin/db_tool psql

3. Add a missing column to the as_distro table:

   Welcome to psql 7.3.9-RH, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit mgmt=> alter table as_distro add column ris_id integer; ALTER TABLE mgmt-> \q

4. Create a new directory:

   # mkdir /var/opt/sun/scs/share/allstart/config/subnet