Transformer Signon issue

[nalinikumar]

I am trying to create a Cube from Cognos Package. In Transformer, I was able to add the datasource and in the final step of power cube build, its prompting for signon. In the Signon window, its showing the Data Source and Connection name . When I enter the userid and password it kept on promting for the same details. I added a Transformer signon as well but still its prompting me for the details again and again. Can anyone please help me in understanding this?

[bdbits]

Are you certain you have the right credentials (username/password) for the data source? Does the same thing happen if you do Run > Generate Categories? Are you able to sign on to this data source from anywhere else, for example Framework Manager?

[nalinikumar]

Hi bdbits,

Yes. I am certain that the username and password are correct as we have used the same datasource in FM and it worked. I am facing the same issue while generating the categories. The login credentials are provided in the signon in content store. I even created a signon in transformer and an odbc of the same data source is present in my system. I dont understand what am I missing here :(

[bdbits]

Hmmm, well if it works in FM on the same computer, it ought work in Transformer. I guess if there is no error message, you could check the Cognos and the database logs to see if there are any entries related to that logon. Beyond that, I think I would contact IBM support to see if they have any insight or suggestions for troubleshooting.