• State Not Answered
  • Replies 3 replies
  • Subscribers 5 subscribers
  • Views 1194 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Process

Hi All, I am facing a issue with Nested CDT. I have cdt fo

sunnya527
A Score Level 2
Hi All,

I am facing a issue with Nested CDT.

I have cdt for eg: cdt_A as a Parent CDT and cdt_a1,cdt_a2 as a nested cdt to CDT_A I need to update cdt_a2 after complete of each form and store it into DB for that I am passing only cdt_a2 into the DB. but at the end of the process when I try to push cdt_A into the DB I get Following Error.

Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-01407: cannot update ("RTWEB"."RTW_USER_REQ_COMNT"."USER_REQ_ID") to NULL Data: TypedValue[it=40762,v={{771,{{771,{{126,<null>,771,Test ,2014-10-17,ssaga2,2014-10-17,ssaga2}},<null>,{{2546,1,Global Access,91,RTW_GLOBAL_ACCESS,RiskTech Web Global Access Role,N,Grant,NA,2014-10-17,2014-10-17,ssaga2,2014-10-17,ssaga2},{2547,1,Medical Bill Access,149,RTW_MEDBILL_ACCESS,Access to MedicalBills,N,Grant,NA,2014-10-17,2014-10-17,ssaga2,2014-10-17,ssaga2},{2548,1,Reporting Access,159,RTW_REPORT_ALL_ACCESS,Access to reports menu item,N,Grant,NA,2014-10-1...

OriginalPostID-126146

OriginalPostID-126146

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 2
    ...7,2014-10-17,ssaga2,2014-10-17,ssaga2},{2549,1,All Attachment Access,163,RTW_ATTACHMENT_ACCESS_ALL,Legal Approved bypass consent form/confidentiality indicator,N,Grant,NA,2014-10-17,2014-10-17,ssaga2,2014-10-17,ssaga2},{2550,1,Privacy Claim Access,223,RTW_PRIVACY_ACCESS_ALL,Access to view private claim data in e26,N,Grant,NA,2014-10-17,2014-10-17,ssaga2,2014-10-17,ssaga2}},<null>,<null>,<null>,<null>,1172,Add,Internal User,,Manager Rejected,2014-10-17,ssaga2,New,2014-10-17,ssaga2,2014-10-17,<null>,,BroadSpire,Sunny,Agarwal,,123-456-7890,ssaga2@us.crawco.com,ssaga2,hfh,,,,,,,0,0,2014-10-17,ssaga2,2014-10-17,ssaga2}},<null>,1172,2014-10-17,In Progress,<null>,ssaga2,Agarwal,Sunny,123-456-7890,ssaga2@us.crawco.com,,2014-10-17,ssaga2,2014-10-17,ssaga2}}]

    but when I keep cdt_a2 as empty or with onyl 1 record and try to push cdt_A into the DB its getting pushed in DB but when multiple records are pushed I ma getting the above error
Reply
  • 0
    A Score Level 2
    ...7,2014-10-17,ssaga2,2014-10-17,ssaga2},{2549,1,All Attachment Access,163,RTW_ATTACHMENT_ACCESS_ALL,Legal Approved bypass consent form/confidentiality indicator,N,Grant,NA,2014-10-17,2014-10-17,ssaga2,2014-10-17,ssaga2},{2550,1,Privacy Claim Access,223,RTW_PRIVACY_ACCESS_ALL,Access to view private claim data in e26,N,Grant,NA,2014-10-17,2014-10-17,ssaga2,2014-10-17,ssaga2}},<null>,<null>,<null>,<null>,1172,Add,Internal User,,Manager Rejected,2014-10-17,ssaga2,New,2014-10-17,ssaga2,2014-10-17,<null>,,BroadSpire,Sunny,Agarwal,,123-456-7890,ssaga2@us.crawco.com,ssaga2,hfh,,,,,,,0,0,2014-10-17,ssaga2,2014-10-17,ssaga2}},<null>,1172,2014-10-17,In Progress,<null>,ssaga2,Agarwal,Sunny,123-456-7890,ssaga2@us.crawco.com,,2014-10-17,ssaga2,2014-10-17,ssaga2}}]

    but when I keep cdt_a2 as empty or with onyl 1 record and try to push cdt_A into the DB its getting pushed in DB but when multiple records are pushed I ma getting the above error
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.