Skip to Main Content

Application Development Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

check-in issue

2806992Jun 11 2015 — edited Jun 11 2015

Hi,

I am not able to check in new documents using "New check-in". Below are the steps to reproduce the error:-

1.) Click on "New check-in

2.) Enter the mandatory fields

3.) Click on "check in".

Post this, I get the below error: -

cslcsuatNode01: Event generated by user 'ACCSIT' at host 'uat.content.qbe.com'. Unable to execute service CHECKIN_NEW and function docRefinery.

(System Error: Unable to execute query 'IwebDocument(INSERT INTO Documents (dDocID, dID, dIsPrimary, dIsWebFormat, dLocation, dOriginalName, dFormat, dExtension, dFileSize)

values(288070, 42401, 0, 1, N'', N'UAT040531~1.txt', N'text/plain', N'txt', 0))'. DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;OCSUIQCS.DOCUMENTS, DRIVER=3.52.95) Unable to execute query 'IwebDocument(INSERT INTO Documents (dDocID, dID, dIsPrimary, dIsWebFormat, dLocation, dOriginalName, dFormat, dExtension, dFileSize)

values(288070, 42401, 0, 1, N'', N'UAT040531~1.txt', N'text/plain', N'txt', 0))'. DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;OCSUIQCS.DOCUMENTS, DRIVER=3.52.95 com.ibm.db2.jcc.a.kn: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;OCSUIQCS.DOCUMENTS, DRIVER=3.52.95

Comments

Winter Zhang-Oracle

Hi,

Can you tell us how you access the database, and if there is anything unusual happening when you are accessing the database ?

This issue can be caused by the following cases(not a complete list):

* Concurrent acessses via multi-threads/multi-processes without opening the environment with DB_INIT_LOCK and DB_INIT_TXN, causing the data corrupted.

* Application quits abnormallly, which means the application quits without a call to DB_ENV->close

* The environment is a private environment, so the db_verify and your application use different caches.

Regards,

Winter, Oracle Berkeley DB

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 9 2015
Added on Jun 11 2015
1 comment
157 views