1. Home
  2. Point-Of-Sale Software
  3. Error -2147217900 Creating matrix items

Error -2147217900 Creating matrix items

I am getting an error upon trying to create matrix items. After i've entered in all the matrix item attributes and styles they show up on the list, but when i go to click ok to create the matrix it gives me this message. "Error 2147217900, Ambiguous column name "DepartmentID" and then it closes the matrix window and i lose everything that was added.

Unsure why this is happeneing, any enlightenment would be great help! Thanks much, Matt Adams

##-----------------------------------------------# Newsgroup Access Courtesy

formatting link
Tax and Accounting Software Forum Web and RSS access to your favorite newsgroup - microsoft.public.pos - 36461 messages and counting ##-----------------------------------------------##

Reply to
marlaman
Loading thread data ...

Reply to
convoluted

marlaman had written this in response to

formatting link
: we're using HQ manager to create the matrix. the build is 2.0.0105. I have tried backing up and then reindexing but it seems as that has no effect whatsoever. This does happen on multiple machines. I am leaning toward the theory that one of our old unused plugins (DRS powerops and buyXgetY may have something to do with this, but can't say for certain. I know the error is SQL related but have no idea how to remedy this!

Thanks guys! Matt ~~Newbie > Haven't seen this error mssg before, but, what is your environment? > HQ or store ops?

##-----------------------------------------------## Newsgroup Access Courtesy

formatting link
Tax and Accounting Software ForumsWeb and RSS access to your favorite newsgroup - microsoft.public.pos - 36492 messages and counting!##-----------------------------------------------##

Reply to
marlaman

We run XP SP3 on all our machines and never have a problem. and I am sure that we are not the only ones.

Reply to
maurice

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.