You are viewing limited content. For full access, please sign in.

Question

Question

LF Cloud: Insert time using a data query type rule

asked on August 15 Show version history

Hi,


I've set up a local on-prem table. I am trying to insert a time value from a form submission using the query data rule I created.


I've refreshed the connection and set up all the input values in the Insert rule. I've tied them correctly in the Rules Service Task inside the Business Process.
I keep getting the error: 
 

The Rules service task encountered an issue. Invalid DateTime value:  [LFF6109-RuntimeRuleFailure]

In the on-prem table, I have the Start_Time column set like this:


When testing, it shows it as a date:


Any insight on this?

0 0

Replies

replied 17 hours ago

For anyone that runs into this issue, I figured it out.

Even though you may have the options set as allow null values on the on-prem table's columns, the rule in LF Cloud requires a value for ALL date type datetime or INT columns. It may require for more but those were the two I ran into an issue with.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.