Error after adding a column to a dataview - Stored Procedure driven

9.01.12 on prem. I've been asked to add a field to an existing dataview. I was able to modify the SP that drives the dataview & if I run it directly I get the output I expect. I added the field to the IDO as an Unbound field then included it in the dataview. If I run the dataview I get an error message:

System.ArgumentException: Column 'TaskType' does not belong to table QVI_MachineLeadTime

I've made sure to check the IDO in and to clear the server cache but this error still comes up. Also, the IDO is just a skeleton. There's no table behind it even with the fields claiming to be bound.

What am I missing?

Find more posts tagged with

General Discussions

Accepted answers

Ryan Pukanski

right, so in IDO methods you added the output mapping there?

All comments

Thomas Kneidl

Hi Stephen,

TaskType is not related to a property class? If yes, is this class checked-in?

Best regards

Thomas

Stephen Cena

Nope. TaskType is the name of the column I added. It's an unbound field at the IDO level and returned as a column from my SQL SP.

Stephen Cena

SP output, column present IDO configuration, column present Column added to dataview IDO set up Error I get from dataview

Here are screen captures to help show what I'm talking about. I've tried clearing the cache on the Utility Server as well as the client's cache but I still get the error. It's got to be something simple, I just can't see it.

"Thank you for helping us help you help us all." - GLaDOS

Ryan Pukanski

I assume you mapped the method output column to that new IDO column as well?

Ryan Pukanski

right, so in IDO methods you added the output mapping there?

Stephen Cena

Based on what I can see with all the other fields, I believe I did. There's no actual IDO or table behind any of it. It's all the fields returned from the SP. We've done dataviews this way over and over with no issue just now it's decided I've done something wrong.

"First things first, but not necessarily in that order." - Dr. Who

Copyright © 2025 Infor. All rights reserved.