Eclipse confused having more than one db connected - Forum - OpenEdge General - Progress Community

Eclipse confused having more than one db connected

 Forum

Eclipse confused having more than one db connected

This question is answered

11.7.2

I wonder if I am having wrong setings in my OpenEdge 11.7 eclipse. If I start writing a dbname, it will give me hit on more than the one db that has the table. If I have tree db's, A, B and C. I have one table called invoice in db B, I will get A.Invoice, B.Invoice and C.Invoice. This is kind of messy for me. What could be wrong?

Verified Answer
  • , I went to the Data Administration Tool, and for each database, I went to:

    Admin -> Database Identification -> Database Identification Maintenance.

    All databases I created from empty8 had the same identifier, so I clicked on the "New DB Passkey/Identifier" button. That brings up a dialogue where I just clicked OK and the identifier changed. I had to close all but one of the projects connected to the db though, otherwise it gave a message that the DB is in use.

    After that, I had to select the following the Eclipse menu before everything worked correctly:

    OpenEdge-->Refresh Cache (Ctrl+R)

    Hope this helps

    Simon

    Simon L Prinsloo

    www.vidisolve.com

All Replies
  • Yes, it's a mess. I have two databases connected, only tables of the first database are shown... twice. With the first database name as prefix and with the second database name as prefix.

  • In this case, underlying problem is with the process of creating Database. We see this issue when we actually create database as a copy.

    Example:

    prodb test empty

    prodb test1 empty

    In the above example, even though test and test1 are two different databases, they both share same instance id. Because of the same reason, PDS OE confuses among the databases with same instance id.

    If we create database either by using -newInstance or from Data Administrator, above issue will not be seen.

    Example:

    prodb test empty -newInstance

    From Data Administrator

    Hope this helps,

    DivyaTheja

  • So how do we fix this for the existing databases? or do I have to live with this problem?

  • Interesting, but...

    documentation.progress.com/.../index.html

    Databases supplied in the install directory for this release, contain the field for a database GUID, but the field contains the Unknown value (?) rather than a valid GUID. When PRODB is used to copy one of these databases, the GUID field of the target database is automatically set.


  • Your emails should have a quick unsubscribe

    not force me to log in again.

    Please stop all emails to me you are spamming with over 20 emails a day


    On Tue, 2018-02-13 at 03:43 -0600, goo wrote:
    >
    > Update from Progress Community
    >
    > goo
    >
    > So how do we fix this for the existing databases? or do I have to live
    > with this problem?
    >
    >
    > View online
    >
    >
    >
    > You received this notification because you subscribed to the forum.
    > To unsubscribe from only this thread, go here.
    >
    > Flag this post as spam/abuse.
    >
    >




    Paul van Zyl
    Implementation Team
    T: 087-233-8758  |  C:   082-562-3591  |  F:   012-567-6437
    E: paul@qsource.co.za  |  W:   www.qbis.co.za  |  Download:   vcard

    Disclaimer: 1) Confidentiality: This email is confidential and may contain privileged or copyright information. You may not present this message to another party without consent from the sender, If you are not please notify sender and delete this email, and you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. 2) Liability: This email is not a binding agreement and does not conclude an agreement without the express confirmation by the sender's superior or a director of the Company. 3) Viruses: The Company does not certify that this email is free of viruses or defects. 4) Requested: The Company does not consent to its employees sending un-asked for emails which contravene the law. In the event that you feel this email is such, please notify the Company in order for the appropriate corrective action to be taken. 5) Advice: Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Any actions taken on the basis of this email are at the reader's own risk. 6) Other: The sender of this email is expressly required not to make any defamatory statements. Any such communication is contrary to company policy and outside the scope of the employment of the individual concerned. The company will not accept any liability in respect of such communication, and the employee responsible will be personally liable for any damages or other liability arising.
  • , I went to the Data Administration Tool, and for each database, I went to:

    Admin -> Database Identification -> Database Identification Maintenance.

    All databases I created from empty8 had the same identifier, so I clicked on the "New DB Passkey/Identifier" button. That brings up a dialogue where I just clicked OK and the identifier changed. I had to close all but one of the projects connected to the db though, otherwise it gave a message that the DB is in use.

    After that, I had to select the following the Eclipse menu before everything worked correctly:

    OpenEdge-->Refresh Cache (Ctrl+R)

    Hope this helps

    Simon

    Simon L Prinsloo

    www.vidisolve.com

  • Thanks Simon, I will try that :-)