Skip to main content
shukurs0001
shukurs0001
August 17, 2022
Question

Error in write to multiple data store entities.

  • August 17, 2022
  • 6 replies
  • 0 views

Can anyone please check this error?

    6 replies

    csteward
    csteward
    August 17, 2022

    You may need to check your tomcat-stdOut.log file here for additional details.

      shukurs0001
      shukurs0001Author
      August 17, 2022

      I'm new bee to Appian,
      Not understanding this logs,

      	... 66 more
Caused by: java.sql.SQLException: Field 'loanid' doesn't have a default value
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:318)
	... 67 more
      csteward
      csteward
      August 17, 2022

      Yes the Caused By section is what we are looking for.  In this case, it is indicating the "loanid" field does not have a value, but it is expecting one.  If this is an ID field, it may not be set to auto-generate the value.  Otherwise, if this is a normal not-null field, you will need to provide a value when writing to the DS or adjust the CDT/DB to allow nulls.

        Terms & ConditionsAccessibility statement