Re: Character field data base name is showing as Database ID
Are there any non ASCII-7 characters in the field name? That could cause the import to use the ID instead of the name (If I remember way back the 5.1 Admin tool had some quirks like that) Fred. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Friday, October 09, 2015 7:59 AM To: arslist@ARSLIST.ORG Subject: Re: Character field data base name is showing as Database ID ** I think Joe's suggestion is the most likely thing that I can think ofbeyond that...I'm not sure what you would be dealing with. On Thu, Oct 8, 2015 at 11:32 PM, Vidyasagar Kommu <kommuvidyasa...@gmail.com<mailto:kommuvidyasa...@gmail.com>> wrote: ** Hi long , Yes iam using admin tool importing to another sever and server admin tool version is mathing. Plz guide me ... On 9 Oct 2015 04:23, "Joe D'Souza" <jdso...@shyle.net<mailto:jdso...@shyle.net>> wrote: ** Sagar, My first thoughts would be to query the meta-data to see if that same database name does exist as a record for that schema ID as a result of some legacy work done on the server you are importing the .def to. I’m assuming there must be some sort of logic in the AR System that if a duplicate record exist with the same database name as you describe, to handle that duplicate by using its database ID as the name to prevent an absolute error resulting in an import error. Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of LJ LongWing Sent: Thursday, October 08, 2015 10:16 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Character field data base name is showing as Database ID ** I assume you are just exporting the def from one server using Admin tool and importing to the other server? Are your Server and Admin tools matching versions? On Thu, Oct 8, 2015 at 1:01 AM, Vidyasagar Kommu <kommuvidyasa...@gmail.com<mailto:kommuvidyasa...@gmail.com>> wrote: Hi All, We have created a new regular form in this form we have the character fields are present when we are moving the form .def file to one server to another server one of the character field data base name is coming as data base id automatically . Please find the below environment details : Server Version: 5.01.02 Patch 1494 Operating System : HP-UX B.11.31 Data Base:Oracle 9.2.0.8.0-64bit Can you please guide me why it is taking as data baseid instead of data base name -- Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Character field data base name is showing as Database ID
I think Joe's suggestion is the most likely thing that I can think ofbeyond that...I'm not sure what you would be dealing with. On Thu, Oct 8, 2015 at 11:32 PM, Vidyasagar Kommu <kommuvidyasa...@gmail.com > wrote: > ** > > Hi long , > Yes iam using admin tool importing to another sever and server admin tool > version is mathing. > Plz guide me ... > On 9 Oct 2015 04:23, "Joe D'Souza" <jdso...@shyle.net> wrote: > >> ** >> >> Sagar, >> >> >> >> My first thoughts would be to query the meta-data to see if that same >> database name does exist as a record for that schema ID as a result of some >> legacy work done on the server you are importing the .def to. I’m assuming >> there must be some sort of logic in the AR System that if a duplicate >> record exist with the same database name as you describe, to handle that >> duplicate by using its database ID as the name to prevent an absolute error >> resulting in an import error. >> >> >> >> Joe >> >> >> -- >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing >> *Sent:* Thursday, October 08, 2015 10:16 AM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Character field data base name is showing as Database ID >> >> >> >> ** >> >> I assume you are just exporting the def from one server using Admin tool >> and importing to the other server? Are your Server and Admin tools >> matching versions? >> >> >> >> On Thu, Oct 8, 2015 at 1:01 AM, Vidyasagar Kommu < >> kommuvidyasa...@gmail.com> wrote: >> >> Hi All, >> >> We have created a new regular form in this form we have the character >> fields are present when we are moving the form .def file to one server >> to another server one of the character field data base name is coming >> as data base id automatically . >> Please find the below environment details : >> Server Version: 5.01.02 Patch 1494 >> Operating System : HP-UX B.11.31 >> Data Base:Oracle 9.2.0.8.0-64bit >> >> Can you please guide me why it is taking as data baseid instead of >> data base name >> >> >> -- >> Sagar >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Character field data base name is showing as Database ID
Hi All, We have created a new regular form in this form we have the character fields are present when we are moving the form .def file to one server to another server one of the character field data base name is coming as data base id automatically . Please find the below environment details : Server Version: 5.01.02 Patch 1494 Operating System : HP-UX B.11.31 Data Base:Oracle 9.2.0.8.0-64bit Can you please guide me why it is taking as data baseid instead of data base name -- Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Character field data base name is showing as Database ID
I assume you are just exporting the def from one server using Admin tool and importing to the other server? Are your Server and Admin tools matching versions? On Thu, Oct 8, 2015 at 1:01 AM, Vidyasagar Kommuwrote: > Hi All, > > We have created a new regular form in this form we have the character > fields are present when we are moving the form .def file to one server > to another server one of the character field data base name is coming > as data base id automatically . > Please find the below environment details : > Server Version: 5.01.02 Patch 1494 > Operating System : HP-UX B.11.31 > Data Base:Oracle 9.2.0.8.0-64bit > > Can you please guide me why it is taking as data baseid instead of > data base name > > > -- > Sagar > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Character field data base name is showing as Database ID
Sagar, My first thoughts would be to query the meta-data to see if that same database name does exist as a record for that schema ID as a result of some legacy work done on the server you are importing the .def to. I'm assuming there must be some sort of logic in the AR System that if a duplicate record exist with the same database name as you describe, to handle that duplicate by using its database ID as the name to prevent an absolute error resulting in an import error. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Thursday, October 08, 2015 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: Character field data base name is showing as Database ID ** I assume you are just exporting the def from one server using Admin tool and importing to the other server? Are your Server and Admin tools matching versions? On Thu, Oct 8, 2015 at 1:01 AM, Vidyasagar Kommu <kommuvidyasa...@gmail.com> wrote: Hi All, We have created a new regular form in this form we have the character fields are present when we are moving the form .def file to one server to another server one of the character field data base name is coming as data base id automatically . Please find the below environment details : Server Version: 5.01.02 Patch 1494 Operating System : HP-UX B.11.31 Data Base:Oracle 9.2.0.8.0-64bit Can you please guide me why it is taking as data baseid instead of data base name -- Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Character field data base name is showing as Database ID
Hi long , Yes iam using admin tool importing to another sever and server admin tool version is mathing. Plz guide me ... On 9 Oct 2015 04:23, "Joe D'Souza" <jdso...@shyle.net> wrote: > ** > > Sagar, > > > > My first thoughts would be to query the meta-data to see if that same > database name does exist as a record for that schema ID as a result of some > legacy work done on the server you are importing the .def to. I’m assuming > there must be some sort of logic in the AR System that if a duplicate > record exist with the same database name as you describe, to handle that > duplicate by using its database ID as the name to prevent an absolute error > resulting in an import error. > > > > Joe > > > -- > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing > *Sent:* Thursday, October 08, 2015 10:16 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Character field data base name is showing as Database ID > > > > ** > > I assume you are just exporting the def from one server using Admin tool > and importing to the other server? Are your Server and Admin tools > matching versions? > > > > On Thu, Oct 8, 2015 at 1:01 AM, Vidyasagar Kommu < > kommuvidyasa...@gmail.com> wrote: > > Hi All, > > We have created a new regular form in this form we have the character > fields are present when we are moving the form .def file to one server > to another server one of the character field data base name is coming > as data base id automatically . > Please find the below environment details : > Server Version: 5.01.02 Patch 1494 > Operating System : HP-UX B.11.31 > Data Base:Oracle 9.2.0.8.0-64bit > > Can you please guide me why it is taking as data baseid instead of > data base name > > > -- > Sagar > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"