Unable to write to DB - time allocated was insufficient

baghavathis

Certified Senior Developer

over 7 years ago

The process throws an exception while writing to DB and the node remains unattended, the alert looks like "The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete. ".

Discussion posts and replies are publicly visible

Parents

0 mohammedz
A Score Level 2
over 7 years ago

Just try firing the same insert query manually in your SQL Database and check how fast it gets inserted over there ?
Incase it delays in inserting the data into your table check indexing is properly done with respect to the primary key of your table. Sometimes when large amount of data is there in any table and without indexing there might be a chance of taking some time to execute the query and from appian it like there few seconds of internal timings for WTD SS.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mohammedz
A Score Level 2
over 7 years ago

Just try firing the same insert query manually in your SQL Database and check how fast it gets inserted over there ?
Incase it delays in inserting the data into your table check indexing is properly done with respect to the primary key of your table. Sometimes when large amount of data is there in any table and without indexing there might be a chance of taking some time to execute the query and from appian it like there few seconds of internal timings for WTD SS.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data