Appreciations accepted

Vladlen Litvinov, the author: If you have some job offer for me, I'm ready to discuss it. View Vladlen Litvinov's profile on LinkedIn

Password

Thursday, April 3, 2014

DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506 during bootstrapProcesServerData in IBM IBM 8.5

During an installation of IBM BPM 8.5 on the step of bootstrapProcesServerData you can get roughly the message:

INFO:File: C:\IBM\BPM85\BPM\Lombardi\imports\process-portal.twx
INFO:Type: Teamworks V7
INFO:File C:\IBM\BPM85\BPM\Lombardi\imports\process-portal.twx failed.....
INFO:PreparedStatementCallback; SQL [insert into LSW_RESOURCE_BUNDLE_KEY (RESOURCE_BUNDLE_KEY_ID,VERSION_ID,AKEY,VALUE,GUID,LAST_MODIFIED,RESOURCE_BUNDLE_ID,LAST_MODIFIED_BY_USER_ID) values (?,?,?,?,?,?,?,?)]; Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=4.11.69; nested exception is com.ibm.db2.jcc.am.SqlTransactionRollbackException: Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=4.11.69
SEVERE:
SEVERE:Import failed: C:\IBM\BPM85/BPM/Lombardi\imports\process-portal.twx

Just increase some logging parameters in your DB2 BPMDB.
You can do it through db2cc or using this commands:

db2 update db cfg for <db> using LOGSECOND 40
db2 update db cfg for <db> using LOGFILSIZ 2048

where db - the name of your BPMDB.

These parameters helped me to solve the problem.  

1 comment:

  1. Hi Vladlen, thanks for this post. I just hit the same problem, and your solution did the trick. I've blogged my experience on my personal blog here - http://portal2portal.blogspot.co.uk/2014/04/cwmcb0046e-seen-during-bootstrap-of-ibm.html - but wanted to give you full credit for the solution. Again, thanks, Dave

    ReplyDelete