Hi Ralph, I was out sick for a couple of days. If we were in the same building I would have walked across to your table and taken a look. I have seen ND doing dynamic replacement of *studio userId* with *runtime userId* (both properties of the DataSource) wherever the same *studio userId* is prefixed to a table/database-object name in the DataObject. All these things are CASE-SENSITIVE, so make sure all the things in question are UPPERCASE. If it still doesn't work you can do a global replacement, nothing wrong with it except that you can't have a peaceful flow of objects from Dev to Prod and back. Cheers, Aby > -----Original Message----- > From: Ralph Cavallaro [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 04, 2000 4:00 AM > To: [EMAIL PROTECTED] > Subject: RE: [ND] Fw: [ND] Conversion from 3.11->4.1:data objects lose > tab > > > > 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] > _________________________________________________________________________ To unsubscribe from this mailing list please send an email to: [EMAIL PROTECTED] Please remember to use the same email address you subscribed with. 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]
