This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I know this thread goes back a little bit, but I wanted to add an update for anyone who may use this going forward. When running the first query to get the list of the objects and attributes, use this one instead:
select objectname,attributename from maxattribute where (attributename = 'siteid' or sameasattribute = 'siteid') and persistent=1
Checking for the persistent state will save time in culling the list when you run the update query.
--- In MAXIMO@yahoogroups.com, "jason.verly" <jason.verly@...> wrote:
>
> Thx! The queries you added will be very useful.
>
> --- In MAXIMO@yahoogroups.com, "matthewgholland" <matthewgholland@> wrote:
> >
> > I haven't had any problem when I have had to do this. You basically want to update everywhere that SiteID is being mentioned though. You can find where you will find references to the SiteID by running the following query in ORACLE or MSSQL:
> >
> > select objectname,attributename from maxattribute where attributename = 'siteid' or sameasattribute = 'siteid'
> >
> > Then you would run an update query similiar to the following for each of the siteid fields.
> >
> > update objectname set attributename = 'New-SiteID' where attributename = 'Old-SiteID'.
> >
> > As long as you make the update in every location thats used for SiteID and then restart your MXServer Maximo should never know the difference.
> >
> > I'd also be sure to check out Default Queries, Relationships, and Validation Where Clauses used by domains to see if the old SiteID was mentioned.
> >
> > --- In MAXIMO@yahoogroups.com, "jason.verly" <jason.verly@> wrote:
> > >
> > > I'm curious what success rate people have had with changing/updating a SiteID after the Site has been in use for several years. I know I've heard stories of people making the change, but I'm curious of the success rate you had and any gotcha's you found during the update.
> > >
> >
>