UET Removal worked, but errors saving data now. Syteline V10 Cloud

Right when we thought we had UET's figured out, we ran into a new problem. We wanted to remove a UET so just followed the procedure backwards, removing from the form, removing the Class/Field relationship and then removing the UET field. Then running UET Impact Shema. All seemed fine and the field has been removed from the SQL Table.

The UET was on customers

Now any form that accesses customers is failing with: "Invalid Column Name: 'Uf_SupplierID'. Which is the field we removed.

We tried View Management, Trigger management, Unload farm metadata and everything else we could come up with.

Are we missing something?

Thank You

Find more posts tagged with

General Discussions

Accepted answers

acl

definitely sql error caused by a trigger/view/repl proc which wasn't properly re-generated by the impact schema to remove the UET column...saving co lines can update customer's accumulated data, which would explain why co lines errors.

i see you tried view/trigger management...maybe regen repl triggers (at master site if you have one)? otherwise support to engage coup ops to trace sql .

All comments

kazuyuki-mochizuki

Just thinking out loud. Regenerate replication triggers?

Mark Woodbury

We are not doing any replication (That I know of!)

wat

I suggest scripting the form out to XML and then look for vestiges of the UET - either that you hadn't realized were there, or perhaps that should not be there. That could either solve the problem, or at least rule out a lot of potential causes.

Mark Woodbury

Wow that is pretty cool how you can script out the form from "Form Sync" Very cool, but did not find anything. I see all my current UET's though. The strange thing is the form I am saving is customer order lines, which never had the new field on it. It was only on the customers form. Anything that accesses customers is seeing this issue now.

acl

i think out-of-the-box DATALAKE replication rule is enabled which would contain customer table and create repl triggers/procedures

Mark Woodbury

I do see replication on for DataLake and InforBus. So maybe the REPL TRIGGERS may be the answer. We have engaged the consultants working on this project with us and I will report back when an answer is found. Thanks for all the suggestions.

Andersen Windows LN Cloud Experience - LN User Webinar 06-18-2020.pdf

Copyright © 2025 Infor. All rights reserved.