topic QLIK REPLICATE - USER LEVEL ENDPOINTS in Qlik Replicate

QLIK REPLICATE - USER LEVEL ENDPOINTS

edward221096 — Tue, 05 Apr 2022 08:50:25 GMT

Hi Support,

We encountered this error while running a task

Not authorized to object BSPJRN in AFFJRNLIB.
RetCode: SQL_ERROR SqlState: 58004 NativeError: -443 Message: [IBM][System i Access ODBC Driver]SQL0443 - Not authorized to object BSPJRN in AFFJRNLIB.
Failed(retcode-1) to execute statement: 'SELECT sequence_number FROM TABLE (QSYS2.Display_Journal('AFFJRNLIB','BSPJRN')) as J LIMIT 1

We are wondering what could be the cause and resolution of this error, additionaly we would also like to know the correct user level access in DB2 for Task options apply changes, and store changes.

Thanks

Re: QLIK REPLICATE - USER LEVEL ENDPOINTS

Steve_Nguyen — Tue, 05 Apr 2022 12:10:44 GMT

@edward221096

Below is from user guide in term of permissions

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/IBM%20DB2%20for%20iSeries/required_permissions_iseries.htm

if you still having issue, best to open support ticket for faster isolation of issue.

Re: QLIK REPLICATE - USER LEVEL ENDPOINTS

lyka — Tue, 05 Apr 2022 20:18:33 GMT

Hello,

One way to verify if to run the failed query manually on the source database using the same Replicate user.

SELECT sequence_number FROM TABLE (QSYS2.Display_Journal('AFFJRNLIB','BSPJRN')) as J LIMIT 1

If the query fails, please check if all permissions were granted to the user. Please refer to the link that Steve shared.

Thanks

Lyka

Re: QLIK REPLICATE - USER LEVEL ENDPOINTS

Bill_Steinagle — Wed, 13 Jul 2022 19:03:29 GMT

Hello,

Thank you for the post to the Replicate Forums. From the display of the error this is the DISPLAY_JOURNAL query that gets sent to the iSeries Source and from the permissions failure you want to check with the DBA to ensure the Replicate User has the access to the Journal Name and Journal Library defined to the iSeries Source as shown below:

See link below for require permissions for the Journal and Journal Library you define to the iSeries Source:

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/IBM%20DB2%20for%20iSeries/required_permissions_iseries.htm

Regards,

Bill Steinagle