Problems with View data

skathaitrooney · Post by **skathaitrooney** » 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?

priyadarshikunal · Post by **priyadarshikunal** » Fri Apr 17, 2015 12:02 pm

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

skathaitrooney · Post by **skathaitrooney** » 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.

SURA · Post by **SURA** » 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?

skathaitrooney · Post by **skathaitrooney** » 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.

chanaka · Post by **chanaka** » Mon Apr 20, 2015 2:59 pm

Hi Somye,

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

Cheers!

Chanaka

skathaitrooney · Post by **skathaitrooney** » Wed Apr 22, 2015 7:41 am

Yes i did.