Hi Aby,
Once again, thank you for getting back to me. I still seem to have a problem. It
seems
as though the datasource changes fine but it never updates the owner prefix on the
table
names in the data objects and since the owner
name is different in production than in our
development area, the tables are not found.
(ex CAMP.CMPGN_HDR as opposed to
INV.CMPGN_HDR). My guess is that if we change
the owner name of our development schema to
CAMP and then go into each .sdo file and
change the INV to CAMP, we should be ok for
future changes. What do you think, am I totally off base or just out of my mind?
Thanks again,
Ralph
Aby Mathew <[EMAIL PROTECTED]> wrote:
>Hi Ralph,
>
>Personally I feel ND4's way of attaching the object-owner prefix to the
>database objects is messy. May be, somebody thought it might be better than
>what ND3 used to do - no prefix attached-, and may be it is so in some
>situations, but in general I find it has made life a little more difficult.
>
>The good news is that ND4 does a dynamic replacement of the owner-prefix at
>run-time. So if you set the Studio user as INV and Runtime user as CAMP -
>both properties for the DataSource - it takes care of most situations. There
>might be situations where this is not enough, and the best solution may be
>to use public synonyms.
>
>Regards,
>Aby
>
>> -----Original Message-----
>> From: Cavallaro, Ralph [mailto:[EMAIL PROTECTED]]
>> Sent: Friday, January 28, 2000 2:06 PM
>> To: 'Aby Mathew'
>> Subject: RE: [ND] Fw: [ND] Conversion from 3.11->4.1:data objects lose
>> tab le names.
>>
>>
>> Hi Aby,
>>
>> Thanks for getting back to me. That worked out fine,
>> however when I
>> go and change the Datasource to point to the production
>> database, a similiar
>> problem arises. Our production database owner is "CAMP" while our test
>> database owner is "INV". When the datasource is changed to point to
>> production. The table names still contain the "INV." prefix.
>> I can keep
>> editing the .sdo file but it seems like this should not have
>> to be done like
>> this. Is there a reason for this occurring?
>>
>> In any case, Thanks again for
>> getting back
>> to me.
>>
>>
>> Ralph Cavallaro
>> Toys R Us
>> MIS Inventory Applications
>> (201) 802-5459
>>
>> > -----Original Message-----
>> > From: Aby Mathew [SMTP:[EMAIL PROTECTED]]
>> > Sent: Thursday, January 27, 2000 6:09 PM
>> > To: 'Ralph Cavallaro'; [EMAIL PROTECTED];
>> > [EMAIL PROTECTED]
>> > Subject: RE: [ND] Fw: [ND] Conversion from 3.11->4.1:data objects
>> > lose tab le names.
>> >
>> > Not to worry at all.
>> >
>> > 1. Close the ND Studio.
>> >
>> > 2. Open the .sdo file for the data object in some editor (I
>> can't help
>> > commenting how good Emacs editor is), do a globale search
>> and replace from
>> > 'fin.' to 'FIN.'.
>> >
>> > 3. Open the Studio and edit the DataObject.
>> >
>> > That's it. It seems while Oralce is case-insensitive, the ND-Oracle
>> > interface doesn't think so.
>> >
>> > Aby
>> > TeamND
>> >
>> >
>> > > -----Original Message-----
>> > > From: Ralph Cavallaro [mailto:[EMAIL PROTECTED]]
>> > > Sent: Thursday, January 27, 2000 2:01 PM
>> > > To: [EMAIL PROTECTED]
>> > > Subject: Re: [ND] Fw: [ND] Conversion from 3.11->4.1:data
>> objects lose
>> > > table names.
>> > >
>> > >
>> > >
>> > > Has anyone ever solved this problem? I am
>> > > having the same thing happen. Any help is
>> > > deeply appreciated.
>> > >
>> > > >
>> > > >>New Problem.
>> > > >>I convert a project, but when I try to see the
>> properties of a data
>> > > >>object, I get this error:
>> > > >>==============================
>> > > >>A table referenced by this data object
>> (fin.EMPLOYEE_INTERNET_VIEW)
>> > > >>cannot be found in the data source. It has been removed
>> > > from the data
>> > > >>object..
>> > > >>==============================
>> > > >>followed by messages for all the other tables that data
>> source uses.
>> > > >>Then the properties dialog comes up, and the tables are
>> > > cleared out of
>> > > >>the table tab. If I reselect the tables, and then go look
>> > > at the columns
>> > > >>tab, all the right columns are there, even some of the
>> > > computed fields.
>> > > >>Unfortunately the where clauses and joins are still wiped
>> > > out and need
>> > > >>to be rebuilt.
>> > > >>
>> > > >>Has anyone else seen this? Is their a cure?
>> > > >>
>> > > >>
>> > > >>
>> > > >>John Hoskins
>> > > >>TDS Computing Services
>> > > >>Internet Technology Team
>> > > >>[EMAIL PROTECTED]
>> > > >>608.664.8263
>> > > >>608.664.8288 (fax)
>> > > >>
>> > > >>
>> > > >>
>> > > >>____________________________________________________________
>> > > _____________
>> > > >>
>> > > >>Helpful addresses for the forums...
>> http://forums.netdynamics.com
>> > >
>> >>[EMAIL PROTECTED]
>> > > >>[EMAIL PROTECTED]
>> > > namics.com
>> > > >>
>> > > >
>> > >
>> > > ______________________________________________________________
>> > > ___________
>> > >
>> > > For help in using, subscribing, and unsubscribing to the
>> discussion
>> > > forums, please go to:
>> > > http://www.netdynamics.com/support/visitdevfor.> html
>> > >
>> > > For dire
>> > > need help, email: [EMAIL PROTECTED]
>> > >
>>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
