Results 1 to 4 of 4

Thread: Table Conversion Properties - "Clear Output Tables" not working

  1. #1

    Table Conversion Properties - "Clear Output Tables" not working

    Hello All,

    My employer just upgraded from JDE 7.3.3.3 to JDE 9.2 two weeks ago.

    One of the Table Conversion objects that has the Table Conversion Property "Clear Output Tables" checkbox checked is functioning as expected in the lower environments, but for some reason it is not clearing out all records from the output table in the production environment.

    I've confirmed the table Conversion Properties in production match the equivalent properties in the lower environments, and I had the CNC do logging on the production job which didn't even list the output table, so the log really didn't reveal where the issue(s) is occurring. The only other thought I had is that something became corrupted in the code with the production build/deployment.

    Any help would be greatly appreciated.

    Thanks.

    Patrick

  2. #2
    Senior Member peterbruce's Avatar
    Join Date
    Jan 2004
    Location
    NSW Australia
    Posts
    2,144
    Patrick,

    Does JDE have delete access to the table?
    Thanks, Peter

    "Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

    E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
    Create!form 7

  3. #3
    Peter,

    That was the issue.

    My company went live with JDE 9.2 two weeks ago, and my brain is on overload especially since over two hundred issues have been logged to the helpdesk since then.

    Thanks a heap...Hmmm...Or is it a stack? Just a little Monday morning humor to start out the work week.

    Patrick

  4. #4
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,229
    Peter's question is most likely the issue since prior to 9.2 JDE had no default DB security. Now by default it does.
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

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.