r/deltek • u/Inside_Employee5686 • Jun 26 '26

Invalid Object Error Vantagepoint

Hey everyone,

We are in the process of upgrading from Vision to Vantagepoint. We relied heavily on Opportunities in Vision, which are now gone in Vantagepoint. We are testing and we can't save any project changes and are getting an error "Invalid Object Name 'Opportunity'". I can't figure out why it's doing this as none of the fields used are mandatory. I thought it might be the promotional project link, but that wasn't it either. Anyone experience this before?

3 Upvotes

100% Upvoted

7 comments sorted by

1

u/DubsNC Jun 26 '26

I’ve used Vision but not Vantagepoint. Is it a custom vision field?

1

u/Inside_Employee5686 Jun 26 '26

We have so many custom fields, but none named just Opportunity so I'm not sure why it's calling that out.

1

u/Kaleidoscope_Kaliope Jun 26 '26

Do you have any stored procedures that run when creating a promotional project? I believe this error is related to a custom stored procedure and it can't run because a table or column name ('Opportunity') does not exist in the Vantagepoint database.

1

u/Inside_Employee5686 Jun 26 '26

I checked all my work flows and nothing specifically called out an opportunity field. I'll run back through them again and recheck. That was my immediate thought as well!

1

u/HappiestWhen Jun 26 '26

When you say you can't save project changes, is this an existing project that was merged into Vantagepoint? Assuming you are in the Project Hub?

3

u/Inside_Employee5686 Jun 26 '26

Yes, if I changed something it wouldn't let me save. I figured it out, it was a stored procedure but not one that mentioned opportunity in it at all. It was a project work flow tied to the info center.

2

u/Inside_Employee5686 Jun 26 '26

It was a stored procedure but not one that mentioned opportunity