I got this error due to:

1) I have one Data Source named SOURCE_A pointing to a DB2 database (DBase_A).

2) Under this DBase_A I have several users/schema (e.g One, Two)

3) I wrote a CR 10 Report connecting the SOURCE_A using s Stored Proc under user/schema One. It works fine.

4) Within the same SOURCE_A, I connected the report to a different table under user/schema Two. Thing is still OK.

5) When a drag/drop a field from the table from user/schema Two on the report then I get this error.

 

"Query Engine Error: 'HY010:[IBM][CLI Driver]CLI0125E Function sequence error. SQLSTATE=HY010"

 

Note: I used just one userid/pw to logon to the SOURCE_A. In fact, I saved the ID/PW during setting up the data soure.

 

Help!