Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
13 replies
Subscribers
6 subscribers
Views
9609 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Can't Insert Null into DB
zrizvi
over 8 years ago
I'm getting the following error when using the "Write to Data Store Entity" smart service. All my variables have nillable = true. Any suggestions?
There is a problem with task “Add Budget Details to DB” in the process “TVP_App_Budget”. An error occurred while trying to write to the entity “TVP_App_Budget” [id=3edb9a28-551e-442b-85f2-1274ed8dc3f8@8017, type=TVP_App_Budget (id=1880)] (data store: TVP_App_Budget). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("BPM_BUS_DB"."tvpappbudget"."A_ID") Data: TypedValue[it=1880,v={1.0,5.0,2.0,6.0,3.0,7.0,4.0,<null>,8.0,<null>,<null>,,,<null>,206504472,<null>,<null>,<null>,,<null>,<null>,,<null>,test4,<null>,9.0,china,2016-10-17,2016-10-13,2016-10-17,testtest,3444mm,8424,<null>,22,206508903,<null>,<null>}]
OriginalPostID-244278
Discussion posts and replies are publicly visible
Parents
0
pavanik
Certified Senior Developer
over 8 years ago
@rizviz...
The problem might be, one of the columns in your DB is not null constraint.You are trying to insert null into that column.Just check your DB and uncheck that not null constraint.I hope it will work fine.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
pavanik
Certified Senior Developer
over 8 years ago
@rizviz...
The problem might be, one of the columns in your DB is not null constraint.You are trying to insert null into that column.Just check your DB and uncheck that not null constraint.I hope it will work fine.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data