Unexpected error: 23000021: ERRORCODE: accessexception

Hi
we recently updated our system to the following configuration
Joomla 3.6.5
Moodle 3.1.3+ (Build: 20161208)
Joomdle 1.0.8
We use https: for Joomla and Moodle
We followed the installation instructions but we get an error in system check (the latest step is KO)
Could you please help to discover what we made wrong or miss?
Thank you for your help
Claudio

Solved....
The token i was using had missing capabilities
I simply added a new one and noticed that there were no warnings associated with it.
I changed Joomdle configuration in Joomla to use this new token and now the system check is all OK
Thanks.

Great to know that you got it working. Thank you for taking the time to explain how you solved the problem, so others can benefit.

Hello I have the same problem.

I installed Moodle and Joomdle in Joomla. To connect I've made a connection, but on the users I got an XML-RPC Error (23000021) The users I create in Joomdle will not automaticly come into Moodle. I watched en followed the course on youtube Joomla CMS and Moodle Integration from Sam Suresh. Unfortunately I got this error. Everything in the checks for installation were ok! Can you help me also with this problem?

The moodle website is: testsite.joomla-designers.nl/lms/
The Joomla website is: testsite.joomla-designers.nl

Hope to solve this soon! Thanks in advance

Enable debugging in Moodle to get more info about the XMLRPC error.

The error tells me: XML-RPC Error (23000021): Uitzondering toegangscontrole | DEBUG INFO: Access to the function joomdle_get_moodle_users_number() is not allowed. There could be multiple reasons for this: 1. The service linked to the user token does not contain the function. 2. The service is user-restricted and the user is not listed. 3. The service is IP-restricted and the user IP is not listed. 4. The service is time-restricted and the time has expired. 5. The token is time-restricted and the time has expired. 6. The service requires a specific capability which the user does not have. 7. The function is called with username/password (no user token is sent) and none of the services has the function to allow the user. These settings can be found in Administration > Site administration > Plugins > Web services > External services and Manage tokens. | ERRORCODE: accessexception

Problem seems to be similar to Claudio: try creating a new token in Moodle and not se any required capabilites for it.

Yes thats why I post my problem here. I already made a new token but the error still there

If you want I can make an testaccount for you so you can look in the website ?

Try re-creating the service from scratch, not setting any restrictions on it. As the message says, something is not allowing access to the function, and it lists the possible causes.