Wierd problem with custom work item types
I'm working on a project where I'm building some custom work item types, for the purposes of integrating our corporate processes into TFS.
I've been using an existing team project to test the work item type definitions, and I've hit a bit of a snag. So far, I have two custom types defined, and when I made some changes to one of them, I've suddenly started getting a wierd error.
I can import the updated type into the team project no problem, but when I edit a work itemof any type since, I get an error from TFS stating "Cannot complete the operation. An unexpected error occurred"
If I check the event log on the server, I find an SQLException that says "Too many table names in the query. The maximum allowable is 256".
The changes I made involved adding 5 new states to the work item, and by gradually reducing the number of states, and field rules defined, it looks like I've hit some kind of limit as to the number of rules or fields that can be defined.
Is there some information that anyone can provide to shed some light on what limit exactly I've hit? I've seen somewhere else that TFS can supposedly support 1024 fields, but I've checked and we have less than 250 fields in total. Is there some limit to the number of fields per work item type/state/transition/team project/anything? Or, what about field rules per work item type/state/etc...etc
Thanks
