Cognos10.2, DB2 in same AIX7.1, datasource validation fails when run report

[ricky_ru]

Hi All,

I got a very strange customer issue. They installed Cognos10.2 and DB2 V9.7 on the same AIX 7.1 64 bit. Installed and Configured sample, created/tested datasource successfully.

But when customers run the sample report,  they are prompted to input datasource username/password(But when creating datasource, the signons box is checked and credential is provided)  As a result, the first run is ok but the second run of a different report is failed. I thought cognos is trying to validate the datasource when running the report but the validation failed then it goes into a loop, and finally the maximum attempts reaches and user is prompted to input username/password.

No this issue in Linux/Windows. The login page does not appears and reports run ok.

Does anyone meet this problem before or do you have any clue on that. I am going to set up the same env to recreate this issue.

Thanks,
Ricky Ru

[MFGF]

Is it possible the permissions defined for the signon within the data source connection are not allowing your users access to the signon? That would be the first things to check, I think.

Cheers!

MF.