Community

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

    Entering Agreement Info in Maintenance Items Error

    Development
    2
    3
    2594
    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
      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
        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
        • ds
          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