Results 1 to 3 of 3

Thread: JDB Select Keyed Failed error in Crystal

  1. #1
    New Member
    Join Date
    Mar 2009
    Posts
    21

    JDB Select Keyed Failed error in Crystal

    I have one custom table in JDE F55XXXX and one report in crystal is based on the same table F55XXXX.

    I have added one new column in F55XXXX in JDE. that new column is not reflecting in field explorer of the Crystal.

    I did "refresh databse", "logon and Off server" & "Verify Databse" in crystal but not worth.

    also that report is giving me the error JDB SelectKeyed Failed.

    How to resolve this error...

    Please Help....

    I am using CRYSTAL Report RI X2 and JDE 811...

    Regards,
    Parag


  2. #2
    Member
    Join Date
    Apr 2004
    Location
    Georgia, USA
    Posts
    121

    Re: JDB Select Keyed Failed error in Crystal

    Did you regenerate your table, and index(s) after adding the new column? Check your database table to make sure the new field exists.
    Currently working on 9.0, Windows platform, Oracle DB

  3. #3
    Member
    Join Date
    May 2001
    Location
    Florence, AL
    Posts
    63

    Re: JDB Select Keyed Failed error in Crystal

    I'm assuming your using the E1 supplied ODBC connection. Your post doesn't specify how your connecting to the data. If so, this is likely to be a problem with local specs on the machine. Crystal uses those local specs to provide the descriptions you see in the field explorer. You'll need to log into the fat client on that machine and go into OMW. Add the table to your default project and do an advanced get from the path your querying. Once you've gotten the specs you can remove the table from your default project.

    After that, open the report in Crystal verify the database. It should update and fix your problem.

    An alternative is to identify the package the table change was deployed in for the environment your getting the error on and install this package on your machine. This will update your local specs as well and bring any other table changes that might have been delivered in that package.
    8.11 SP1 Tools 8.98.3.2
    I5 - 550 V6R1

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.