Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
indrasaptaalldata
Partner - Contributor III
Partner - Contributor III

Incident Access Denied to Source from Qlik

Dear Support,

 

We get issue access denied because any hit user pass to source that cause task stop.

For detail, please check the log

 

Thanks

Sapta

Labels (1)
16 Replies
indrasaptaalldata
Partner - Contributor III
Partner - Contributor III
Author

Dear Team,

 

Pleas find repsrv.log

 

Thanks,

SushilKumar
Support
Support

Hello @indrasaptaalldata 

 

Thanks for reaching out to Qlik via Qlik Community Support page. A support case is required where log analysis is required 

And request you to not to upload any logs to the Community posts as its Available to all . 

 

Please refer to Replicate https://community.qlik.com/t5/Knowledge/How-to-collect-Diagnostics-Package-from-Qlik-Replicate/ta-p/...

 

Regards,

Sushil Kumar

SushilKumar
Support
Support

Hello Team,

Thanks for reaching out to Qlik via Qlik Community Support page. Such issue requires through analysis of Settings and logs, hence request you to reach out to technical Support via a case and provide Diagnostics package.

And request you to not to upload any Log here as it can be access by larger Community member then the intended Support personal. 

Please refer to Replicate https://community.qlik.com/t5/Knowledge/How-to-collect-Diagnostics-Package-from-Qlik-Replicate/ta-p/...

Regards,
Sushil Kumar

SachinB
Support
Support

Hello @indrasaptaalldata ,

The root cause for this issue could be there is no routing in the subsystem on the iSeries source, please check below link for the same.

https://www.ibm.com/support/pages/routing-entries-everything-you-always-wanted-know

Regards,

Sachin B

DesmondWOO
Support
Support

Hi @indrasaptaalldata ,

Replicate uses your account BRICDC to connect DB2 iSeries, retrieves data from tables and capture changes from journal. If your account is disabled due to many sign-on attempts, perhaps wrong password is provided or somebody has changed it. Please also check if you have other source endpoints using the same account also.

For details on why the account is disabled, I recommend checking with your system administrator.

Regards,
Desmond

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
indrasaptaalldata
Partner - Contributor III
Partner - Contributor III
Author

 
john_wang
Support
Support

Hello @indrasaptaalldata ,

Server log file repsrv.log line # 1064 shows:

2024-06-04T08:48:24 [SERVER ]E: RetCode: SQL_ERROR SqlState: 28000 NativeError: 8011 Message: [IBM][System i Access ODBC Driver]Communication link failure. comm rc=8011 - CWBSY0011 - User BRICDC on system 192.168.21.6 has been disabled, Password length = 10, Prompt Mode = Never, System IP Address = 192.168.21.6 [1022502]

However in your JSON file your configuration is:

"server": "192.168.21.5",

Seems something mismatched. 

BTW, please do not upload Diag Packages to article as it may contain sensitive information. If you need upload Diag Packages or sensitive information, please open support ticket and attach the files to the case.

Regards,

John.

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!