Repository questions

security Supervisor (4.x - 6.x)
1

We are in the process of migrating from Sybase System 10 servers/databases to Sybase System 11. Our repository resides on a Sybase System 10 server. We did the following:
Created the same-named database on a System 11 server Made a copy of the repository database
Loaded that copy into the System 11 database Ran a Safe Recovery to create a new BOMAIN.key (security domain only) to access the new server
Logged into SUPERVISOR, selected TOOLS/REPOSITORY and modified the connections for the UNIVERSE and DOCUMENT domains with the new connection information.

This seemed to work ok. However, a major problem occurred when users tried to import reports from the new repository. The following error message was received:
UNABLE TO WRITE report-name. IMPORT CANCELLED. report-name CANNOT BE IMPORTED.
I was able to get around this by importing all reports from the “old” repository and then exporting them to the “new” repository. Once I did this, users could import reports. Since all repository tables were copied over to the new server, I thought that the re-export would not have to be done (since we did not re-create the Universe and Document domains but rather, copied them.)
Can anyone explain why I had to import and re-export all of the reports to the new repository?

2nd question: If another copy is made of the “old” repository (which is still in prodcution, the “new” repository is in test) and this copy is loaded onto the new server again, would I need to re-create the BOMAIN.key again or should the other one I created still work?

Thanks for any input.

Listserv Archives (BOB member since 2002-06-25)

2

boundary=“MS_Mac_OE_2980438658_615130_MIME_Part”

THIS MESSAGE IS IN MIME FORMAT. Since your mail reader does not understand
this format, some or all of this message may not be legible.

–MS_Mac_OE_2980438658_615130_MIME_Part

Judith,

When you recreate the BOMAIN.KEY, the only connection that gets rebuilt is the Security Domain connection. The location of the Universe and Document domain don’t get moved and/or updated (even if they reside in the same account). This is from all of the secured connections being stored in the repository.

You have three choices:
a) Edit the connections and change them to point to the new database. b) Change your aliases to point to the new database. c) Create a new Document and Universe domain and import the information into them. Once that is accomplished you should be able to delete the old domains (though I would verify that they all work).

Since you created a 'same-named database on a different server, it may have been easier or more productive to change the way the servers were defined/named. This would make the change to the new server fairly transparent.

Created the same-named database on a System 11 server. Made a copy of the
repository database
Loaded that copy into the System 11 database. Ran a Safe Recovery to create
a new BOMAIN.key (security domain only) to access the new server…

–MS_Mac_OE_2980438658_615130_MIME_Part

Re: Repository questions Judith,

When you recreate the BOMAIN.KEY, the only connection that gets rebuilt is<= BR> the Security Domain connection. The location of the Universe and Document domain don't get moved and/or updated (even if they reside in the same
account). This is from all of the secured connections being stored in the repository.

You have three choices:
a) Edit the connections and change them to point to the new database.
b) Change your aliases to point to the new database.
c) Create a new Document and Universe domain and import the information
into them. Once that is accomplished you should be able to delete the old domains (though I would verify that they all work).

Since you created a 'same-named database on a different server, it may have=
been easier or more productive to change the way the servers were
defined/named. This would make the change to the new server fairly
transparent.


&Created the same-named database on a System 11 server. Made a copy of t= he
repository database
&Loaded that copy into the System 11 database. Ran a Safe Recovery to cr= eate
a new BOMAIN.key (security domain only) to access the new server...

–MS_Mac_OE_2980438658_615130_MIME_Part–

Listserv Archives (BOB member since 2002-06-25)

3

Question #1 - Don’t really know why that happened since you copied the entire repository “as is”? However, by importing and exporting, you were able to reestablish all of the connections. Might have been a security issue.

Question #2 - I wouldn’t think you would need a new BOMAIN.KEY so you are okay.

Judith wrote:

We are in the process of migrating from Sybase System 10 servers/databases to Sybase System 11. Our repository resides on a Sybase System 10 server. We did the following:
Created the same-named database on a System 11 server Made a copy of the repository database
Loaded that copy into the System 11 database Ran a Safe Recovery to create a new BOMAIN.key (security domain only) to access the new server
Logged into SUPERVISOR, selected TOOLS/REPOSITORY and modified the connections for the UNIVERSE and DOCUMENT domains with the new connection information.

This seemed to work ok. However, a major problem occurred when users tried
to import reports from the new repository. The following error message was
received:
UNABLE TO WRITE report-name. IMPORT CANCELLED. report-name CANNOT BE IMPORTED.
I was able to get around this by importing all reports from the “old” repository and then exporting them to the “new” repository. Once I did this, users could import reports. Since all repository tables were copied
over to the new server, I thought that the re-export would not have to be done (since we did not re-create the Universe and Document domains but rather, copied them.)
Can anyone explain why I had to import and re-export all of the reports to the new repository?

2nd question: If another copy is made of the “old” repository (which is still in prodcution, the “new” repository is in test) and this copy is loaded onto the new server again, would I need to re-create the BOMAIN.key again or should the other one I created still work?

Thanks for any input.

Listserv Archives (BOB member since 2002-06-25)