These update statements at database level really worked. Thanks a lot.. :)

Thad Esser wrote:
> 
> These are Oracle select statements, but they will show you the
> fields/forms
> for AIE that have server references.  I have done multiple database
> refreshes back to our dev environments, and used SQL "UPDATE" versions of
> these to set the server references.  In doing so, I've never had a problem
> with passwords for AIE.
> 
> //From data Exchange:
>           SELECT ZTMPINSTANCEALIAS, AR_SERVER, INSTANCE_NAME FROM
> EIE_DATAEXCHANGE;
> //Application Path
>           SELECT APPLICATION_PATH FROM EIE_APPLICATIONSETTINGS;
> //BackupLoadFlag
>           SELECT HOST, INTERNAL_INSTANCE_NAME, INSTANCENAME FROM
> EIE_BACKUPLOADFLAG;
> 
> 
> Hopefully that helps some.
> Thad
> P.S.  I just noticed that you are on a later version ARS and CMDB than we
> are, so the above might not be comprehensive.
> On Wed, Mar 30, 2011 at 7:05 AM, rmduser
> <priyanka_sar...@hotmail.com>wrote:
> 
>> Thanks for response.
>>
>> I checked the form names involved are EIE:ApplicationSettings,
>> EIE:BackuploadFlag
>>
>> Out of these,ApplicationSettings form has some 'encrypted password' field
>> also, if I only change the instance name/internal instance name kinds of
>> fields, will that suffice?
>>
>>
>>
>> Roger Justice wrote:
>> >
>> > There is a read only form holding this information. I did an export of
>> > this data when I had the same problem modified the server name after
>> the
>> > export, deleted the records I exported and did an import.
>> >
>> >
>> >
>> >
>> >
>> > -----Original Message-----
>> > From: rmduser <priyanka_sar...@hotmail.com>
>> > To: arslist <arslist@ARSLIST.ORG>
>> > Sent: Wed, Mar 30, 2011 4:34 am
>> > Subject: AIE instance name mismatch after DB sync up activity
>> >
>> >
>> > Hi,
>> > Version specs: ARS 7.5 patch4, CMDB Atrium 7.6patch1, ITSM 7.0.3 patch9
>> >
>> >  had performed a DB sync activity on Remedy Server by taking a dump of
>> > roduction env. database & pointing it on to test env.
>> >
>> > he test & prod env are on separate servers (with different hostnames).
>> >
>> > fter DB sync, the AIE instance name of the 'production env' shows ,
>> when
>> I
>> > ccess AIE console of test environment.
>> >
>> > lthough, the AIE service name is still the same of test env.
>> > (services.msc)
>> >
>> > ow can I change it back to the previous instance name (test env
>> hostname).
>> >
>> > ny help.
>> >
>> > hanks in advance.
>> > --
>> > iew this message in context:
>> >
>> http://old.nabble.com/AIE-instance-name-mismatch-after-DB-sync-up-activity-tp31274972p31274972.html
>> > ent from the ARS (Action Request System) mailing list archive at
>> > Nabble.com.
>> >
>> _______________________________________________________________________________
>> > NSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> > ttend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>> >
>> >
>> >
>> _______________________________________________________________________________
>> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>> >
>> >
>>
>> --
>> View this message in context:
>> http://old.nabble.com/AIE-instance-name-mismatch-after-DB-sync-up-activity-tp31274972p31277615.html
>>  Sent from the ARS (Action Request System) mailing list archive at
>> Nabble.com.
>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>
> 
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
> 
> 

-- 
View this message in context: 
http://old.nabble.com/AIE-instance-name-mismatch-after-DB-sync-up-activity-tp31274972p31395743.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Reply via email to