Error BIRT encodage character

hello, i have a error :
 
"the converters of characters required is not available" in execution data set or generate preview.I dont find the cause of error.
 
BIRT version 3.7.1.
 
Need your help, thanks.

Find more posts tagged with

Comments

micajblock

Can you provide more details? Where is the data coming from? What language is the data in? Can you provide some sample data?

mikaru

Error : " Cannot get the string value from column: 1. 
 org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get string value in the result set. 
SQL error #1:[jcc][t4][10199][10462][3.50.152] Le convertisseur de caractÃ¨res requis n'est pas disponible. inERRORCODE=-4220, SQLSTATE"
In english "Le convertisseur de caractÃ¨res requis n'est pas disponible." is the converters of characters required is not available.
 
Data coming database db2 in remote server. 
 
 
Erro log :
org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the string value from column: 1. 
 org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get string value in the result set. 
SQL error #1:[jcc][t4][10199][10462][3.50.152] Le convertisseur de caractÃ¨res requis n'est pas disponible. ERRORCODE=-4220, SQLSTATE=null 
; 
 com.ibm.db2.jcc.b.SqlException: [jcc][t4][10199][10462][3.50.152] Le convertisseur de caractÃ¨res requis n'est pas disponible. ERRORCODE=-4220, SQLSTATE=null 
 at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:55) 
 at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108) 
 at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:96) 
 at org.eclipse.birt.data.engine.odaconsumer.ResultSet.getString(ResultSet.java:270) 
 at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(ResultSet.java:179) 
 at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:214) 
 at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:113) 
 at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:91) 
 at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.initialize(SimpleResultSet.java:177) 
 at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.<init>(SimpleResultSet.java:117) 
 at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:1009) 
 at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:441) 
 at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1124) 
 at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232) 
 at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:173) 
 at org.eclipse.birt.report.engine.api.impl.ExtractionResults.nextResultIterator(ExtractionResults.java:74) 
 at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:70) 
 at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:337) 
 at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) 
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get string value in the result set. 
SQL error #1:[jcc][t4][10199][10462][3.50.152] Le convertisseur de caractÃ¨res requis n'est pas disponible. ERRORCODE=-4220, SQLSTATE=null 
; 
 com.ibm.db2.jcc.b.SqlException: [jcc][t4][10199][10462][3.50.152] Le convertisseur de caractÃ¨res requis n'est pas disponible. ERRORCODE=-4220, SQLSTATE=null 
 at org.eclipse.birt.report.data.oda.jdbc.ResultSet.getString(ResultSet.java:229) 
 at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSet.getString(OdaResultSet.java:246) 
 at org.eclipse.birt.data.engine.odaconsumer.ResultSet.getString(ResultSet.java:266) 
 ... 15 more 
Caused by: com.ibm.db2.jcc.b.SqlException: [jcc][t4][10199][10462][3.50.152] Le convertisseur de caractÃ¨res requis n'est pas disponible. ERRORCODE=-4220, SQLSTATE=null 
 at com.ibm.db2.jcc.b.wc.a(wc.java:55) 
 at com.ibm.db2.jcc.b.wc.a(wc.java:119) 
 at com.ibm.db2.jcc.b.bc.a(bc.java:1758) 
 at com.ibm.db2.jcc.b.bc.n(bc.java:496) 
 at com.ibm.db2.jcc.b.bc.F(bc.java:1263) 
 at com.ibm.db2.jcc.b.jk.d(jk.java:939) 
 at com.ibm.db2.jcc.b.jk.getString(jk.java:917) 
 at org.eclipse.birt.report.data.oda.jdbc.ResultSet.getString(ResultSet.java:224) 
 ... 17 more

micajblock

It looks like an error from DB2. Search on the error code on Google and you will find some answers. It has something to do with adding a POLICY file to the client USERID. JAVA requires some authority to run JCC packages.

mikaru

This query return a result set in Data Studio 2.0, sofware for query db2.

micajblock

Yes, but that does not use JDBC. I edited the answer above. Please re-read.

mikaru

Thanks but there is one problem that i dont understand. The last time , i use BIRT 3.7.1 , all report working properly.... Why now it not work.+

micajblock

No idea. Ask your DB2 Administrators. This is an IBM error. I just found the Information via Google.

mikaru

But via google , it not speak for BIRT but for other soft or tools

micajblock

Yes, but they are Java related and BIRT uses Java.