I used the Extended User Defined Table to add fields to the Customer table. This required that we stop the app servers and run the update UD Schema. Now anything involving the customer table doesn't work! I am receiving the following error:

Did you verify that your UD table actually built on your database? When I first did this (we're on 9.05.701 on SQL Server) I ran the UD Schema update on the app server, it appeared that it worked, but the new table in SQL wasn't there (our db server is different than our app server). When I ran the UD Schema update on the db server, the table created and I was able to use the table in the form.

Rob

Help the community by fixing grammatical or spelling errors, summarizing or clarifying the solution, and adding supporting information or resources. Always respect the original author.

Popular White Paper On This Topic

Did you verify that your UD table actually built on your database? When I first did this (we're on 9.05.701 on SQL Server) I ran the UD Schema update on the app server, it appeared that it worked, but the new table in SQL wasn't there (our db server is different than our app server). When I ran the UD Schema update on the db server, the table created and I was able to use the table in the form.

Thanks. That sounds like exactly the problem (ours are on different servers as well). One question though. How did you get the UD Schema Update to run on the DB server? There are no options when running it to select a particular server.