Results 1 to 8 of 8

Thread: Spec column XYZ is not in DB META Data

  1. #1
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    535

    Spec column XYZ is not in DB META Data

    I recently changed a custom table(added columns)

    The logic in my program checks if the record exists - then if it doesn't exist, it tries to insert.

    My FetchKeyed is failing - so in code, i have it trying to insert - but in this case the insert is also failing with duplicate key

    Can Spec column XYZ is not in DB META Data make my fetch fail?

    Thanks

    log snippet attached
    Attached Files Attached Files
    Analyst/Developer
    E1: 9.2 | TR: 9.2.1.4 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2010

  2. #2
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    970
    Is this a UBE? If so delete the SQL package for it. Could possibly be global tables.

    Craig
    Last edited by craig_welton; 12-07-2018 at 10:23 AM.
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  3. #3
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    535
    Quote Originally Posted by craig_welton View Post
    Is this a UBE? If so delete the SQL package for it. Could possibly be global tables.

    Craig
    No ube. We've cleared the global tables as well. SQL packages are the next thought - those will be cleared this weekend.

    Can that spec error make the fetch fail?
    Analyst/Developer
    E1: 9.2 | TR: 9.2.1.4 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2010

  4. #4
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    970
    Definitely. Seen plenty of issues with SQL packages over the years.
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  5. #5
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,523
    Is this a problem locally or after deploying? If I remember correctly don't you have to bounce the JAS server after changing a table?
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

  6. #6
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    535
    locally it's not a problem. It's also not a problem in our non production E1 server. We've bounced the jas server, cleared the global tables. We deployed the update Monday night and have had sporadic errors. It's doesn't always fail to fetch either. I finally got it to error while having the jdedbug logs on and attached the section of logs I believe to be causing it. SQL packages is my last hope per E1: OS: Overview, Maintenance and Known Issues for AS400 SQLPkgs (Doc ID 1525639.1)
    Analyst/Developer
    E1: 9.2 | TR: 9.2.1.4 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2010

  7. #7
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    970
    Since you said it wasn't a UBE, and the logs are definitely from an iSeries, I'm inferring the process is in a BSFN. So JAS is not involved. The intermittence is an interesting twist. It points to the SQL packages being used by a COK, and that there are multiple packages (some with the "old" table metadata). Let us know how it works after the cleanup.

    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  8. #8
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    535
    So far so good. note to self - don't mess with tables without clearing sql packages.
    Analyst/Developer
    E1: 9.2 | TR: 9.2.1.4 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2010

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.