Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Entering Agreement Info in Maintenance Items Error

    Scheduled Pinned Locked Moved Development
    3 Posts 2 Posters 2.7k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • H Offline
      heplers
      last edited by

      I just down loaded and installed the latest version and am getting this when trying to enter the contract info for Maint Items. It fails because the SQL generated for the update statement has a column that does not exist in the table isys_cats_maintenance_list. It tried to update a column called "isys_cats_maintenance_list__customer_number". I took out that column from the SQL generated and ran it by hand against the DB and it worked fine and now my contract info shows up in the UI. Thought you all should know this since you cannot add this info at all with editing the SQL and running by hand.

      1 Reply Last reply Reply Quote 0
      • H Offline
        heplers
        last edited by

        Never mind…..all I needed was the update.....this problem exists by default with the 9.2 package. Once I updated to the latest patch it added the column to DB and to the UI

        1 Reply Last reply Reply Quote 0
        • dsD Offline
          ds
          last edited by

          Yes, it was a known and already fixed bug.

          But thanks for your attention !

          1 Reply Last reply Reply Quote 0
          • First post
            Last post