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

judym598

Certified Senior Developer

over 8 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 8 years ago

What did you set as the default values for these new columns in the database? Query Rules can fail like this when you try to query a database table with date fields that have *no* value. That is, "No Value" has been selected as the default value for the new date columns. This is different from a default value of NULL, which Appian can handle. Try inserting NULL as the value for these new columns in each existing row.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 patrickh over 8 years ago

What did you set as the default values for these new columns in the database? Query Rules can fail like this when you try to query a database table with date fields that have *no* value. That is, "No Value" has been selected as the default value for the new date columns. This is different from a default value of NULL, which Appian can handle. Try inserting NULL as the value for these new columns in each existing row.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data