DSXchange

Posted: **Fri Apr 17, 2015 4:43 am**

Hello Experts,

I have DB2 connector stage. Earlier i was running into an issue while running the job.
Error:

SQL30082N Security processing failed with reason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001

I checked this error and changed the db2 cataloging, AUTHENTICATION from SERVER to SERVER_ENCRYPT as server side it was SERVER_ENCRYPT.

After this change the job is running fine but when i click on VIEW DATA the same error is popping up.
I think the old cataloging is getting picked while VIEW DATA.

Any thoughts on this?

Posted: **Fri Apr 17, 2015 12:02 pm**

did you verify the parameters being passed during runtime and during view data?

Posted: **Sat Apr 18, 2015 12:30 am**

Yes project level parameters are getting passed to both... For view data, i even hardcoded the DBNAME, username and pass in the connector stage. Still the same issue.

Posted: **Sun Apr 19, 2015 5:46 pm**

skathaitrooney wrote:i even hardcoded the DBNAME, username and pass in the connector stage. Still the same issue.

Just a clarification.

Is it the same user is being used when you view job vs run the job?

Posted: **Mon Apr 20, 2015 1:19 am**

Yes user remains the same. Now i am able to view data too. I dont know the reason why i wasnt able to earlier, the old cataloging was picked up when i was trying to view data.

Posted: **Mon Apr 20, 2015 2:59 pm**

Hi Somye,

Did you alter the DB2 cataloging details in your client machine DB2 configuration?

Cheers!

Chanaka

Posted: **Wed Apr 22, 2015 7:41 am**

Yes i did.

DSXchange

Problems with View data

Problems with View data