Tuesday, 13 August 2013

Problem generating IBM BPM Standard 7.5.1.1 Deployment Environment - Copy and Paste is NOT my friend

Whilst trying to generate a new IBM BPM Standard 7.5.1.1 environment, I kept hitting an exception whilst generating the Deployment Environment: -

[13/08/13 11:51:02:535 BST]     FFDC Exception:com.ibm.db2.jcc.am.SqlException SourceId:com.ibm.bpm.db.jdbc.tasks.JdbcDriverTask ProbeId:188 Reporter:com.ibm.bpm.db.jdbc.tasks.JdbcDriverTask@73487348
com.ibm.db2.jcc.am.SqlException: [jcc][10402][11146][4.11.69] Cannot convert Unicode string to Ebcdic string. ERRORCODE=-4220, SQLSTATE=null


( Source: /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/logs/ffdc/dmgr_14301430_13.08.13_11.51.02.534523267370760647421.txt )

This was the screen that I was completing that related to DB2: -


The solution was oh-so-simple.

I had typed the password into the first dialogue box, which is fine.

However, I then selected the password and hit [Cmd][C] to copy it.

Guess what ? I didn't copy the password e.g. Passw0rd01 as I'd hoped. Instead, I copied a series of asterisks i.e. *********** instead.

For some reason, DB2 doesn't think that ******* is a very good password, hence the slightly obscure error message -  Cannot convert Unicode string to Ebcdic string.

As an ex-AS/400 guru, Extended Binary Coded Decimal Interchange Code is definitely a blast from the past :-)

No comments: