I just updated a data type (added fields to it) and all related objects were upd

judym598

Certified Senior Developer

over 9 years ago

I just updated a data type (added fields to it) and all related objects were updated successfully (or so it said). The Data Store looks fine, process model is fine and the interface rules that use this data type work just fine but I have 2 query rules that are not longer working. I think they are trying to use the old data type. I've reselected it for the query but it still doesn't work. I even deleted the query and recreated it but it's still not working. Any suggestions on why that would happen? This is the error I'm getting. The data type is IPS_Board.
Expression evaluation error in rule 'ips_getallboardschedules' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [IPSBoardDT2578], query: [ips_getAllBoardSchedules], order by: [[Sort[id asc]]], filters:[null])

Discussion posts and replies are publicly visible

Parents

0 patrickh over 9 years ago

Updating the default value is one thing, but did you actually insert NULL as the value for these columns for all existing rows? Updating the default won't do this to the best of my knowledge. What RDBMS are you working with?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 patrickh over 9 years ago

Updating the default value is one thing, but did you actually insert NULL as the value for these columns for all existing rows? Updating the default won't do this to the best of my knowledge. What RDBMS are you working with?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data