[keyangl]

Hi there,

When i click on Supervisors, the Available users List will not show anything and it will keep spinning.
When i open up the console it shows Bad Request.
Any help?

CapturePM2.PNG (50.87 KiB) Viewed 4477 times

CapturePM1.PNG (20.95 KiB) Viewed 4477 times

[amosbatto]

I don't see that problem in my installation (PM 3.2.1 Community in Debian 8.4).

What version of PM are you using? Bitnami or manual install? What operating system?

[amosbatto]

You might see that kind of error if your login session has expired after 24 minutes of inactivity. Do you see the same error right after logging in?

[keyangl]

Sorry forgot to post the version
It is 3.0.1.7-community, CentOS 7, manual install and yes i've already tried relogging.
Any ideas to the Bad Request error? Other stuff are working fine

[amosbatto]

Try deleting the compiled cache for your workspace (which by default is named "workflow").
For example, in Linux:

Code: Select all

rm -rf /opt/processmaker/compiled/* 
rm -rf /opt/processmaker/shared/sites/{workspace}/cachefiles/* 
rm -rf /opt/processmaker/shared/sites/{workspace}/cache/*

If the compiled cache isn't the problem, then edit your workflow/engine/config/env.ini file and add the lines:

Code: Select all

debug = 1
debug_sql = 1

Try the same action to generate the same error and then post the contents of your workflow/public_html/php_errors.log, shared/log/propel.log and shared/log/queriesWithErrors.log files.

[keyangl]

Try deleting the compiled cache for your workspace (which by default is named "workflow").
For example, in Linux:

Code: Select all

rm -rf /opt/processmaker/compiled/* 
rm -rf /opt/processmaker/shared/sites/{workspace}/cachefiles/* 
rm -rf /opt/processmaker/shared/sites/{workspace}/cache/*

If the compiled cache isn't the problem, then edit your workflow/engine/config/env.ini file and add the lines:

Code: Select all

debug = 1
debug_sql = 1

Try the same action to generate the same error and then post the contents of your workflow/public_html/php_errors.log, shared/log/propel.log and shared/log/queriesWithErrors.log files.

my compiled is in processmaker/shared so i deleted that instead
deleted the {workspace} cache and cachefiles, cachefiles were empty

still not able to load list
added the debug lines, tried loading the list but i do not see any php_errors.log or queriesWithErrors.log only propel.log:

Code: Select all

09:26:44.1101|workflow|172.16.114.145|375898|executeQuery|0.00057291984558105|SELECT RBAC_SYSTEMS.SYS_UID, RBAC_SYSTEMS.SYS_CODE, RBAC_SYSTEMS.SYS_CREATE_DATE, RBAC_SYSTEMS.SYS_UPDATE_DATE, RBAC_SYSTEMS.SYS_STATUS FROM RBAC_SYSTEMS WHERE RBAC_SYSTEMS.SYS_CODE='PROCESSMAKER'|app.php:61:include()->sysGeneric.php:1781:loadUserRolePermission()->class.rbac.php:409:LoadByCode()->Systems.php:77:doSelect()->BaseSystemsPeer.php:256:doSelectRS()->BaseSystemsPeer.php:288:doSelect()->BasePeer.php:467:executeQuery()->PreparedStatementCommon.php:334:executeQuery()->|GET|/sysworkflow/en/neoclassic/processes/main|
09:26:44.1110|workflow|172.16.114.145|375898|executeQuery|0.0005030632019043|SELECT RBAC_ROLES.ROL_UID, RBAC_ROLES.ROL_CODE FROM RBAC_ROLES, RBAC_USERS_ROLES WHERE RBAC_USERS_ROLES.USR_UID='00000000000000000000000000000001' AND RBAC_ROLES.ROL_SYSTEM='00000000000000000000000000000002' AND RBAC_USERS_ROLES.ROL_UID=RBAC_ROLES.ROL_UID|app.php:61:include()->sysGeneric.php:1781:loadUserRolePermission()->class.rbac.php:411:getRolesBySystem()->UsersRoles.php:60:doSelectRS()->BaseUsersRolesPeer.php:273:doSelect()->BasePeer.php:467:executeQuery()->PreparedStatementCommon.php:334:executeQuery()->|GET|/sysworkflow/en/neoclassic/processes/main|
09:26:44.1118|workflow|172.16.114.145|375898|executeQuery|0.00051307678222656|SELECT RBAC_ROLES_PERMISSIONS.PER_UID, RBAC_PERMISSIONS.PER_CODE FROM RBAC_ROLES_PERMISSIONS, RBAC_PERMISSIONS WHERE RBAC_ROLES_PERMISSIONS.ROL_UID='00000000000000000000000000000002' AND RBAC_ROLES_PERMISSIONS.PER_UID=RBAC_PERMISSIONS.PER_UID|app.php:61:include()->sysGeneric.php:1781:loadUserRolePermission()->class.rbac.php:413:getAllPermissions()->UsersRoles.php:88:doSelectRS()->BaseRolesPermissionsPeer.php:273:doSelect()->BasePeer.php:467:executeQuery()->PreparedStatementCommon.php:334:executeQuery()->|GET|/sysworkflow/en/neoclassic/processes/main|
09:26:44.1125|workflow|172.16.114.145|375898|executeQuery|0.00040102005004883|SELECT RBAC_USERS.USR_UID, RBAC_USERS.USR_USERNAME, RBAC_USERS.USR_PASSWORD, RBAC_USERS.USR_FIRSTNAME, RBAC_USERS.USR_LASTNAME, RBAC_USERS.USR_EMAIL, RBAC_USERS.USR_DUE_DATE, RBAC_USERS.USR_CREATE_DATE, RBAC_USERS.USR_UPDATE_DATE, RBAC_USERS.USR_STATUS, RBAC_USERS.USR_AUTH_TYPE, RBAC_USERS.UID_AUTH_SOURCE, RBAC_USERS.USR_AUTH_USER_DN, RBAC_USERS.USR_AUTH_SUPERVISOR_DN FROM RBAC_USERS WHERE RBAC_USERS.USR_UID='00000000000000000000000000000001'|app.php:61:include()->sysGeneric.php:1781:loadUserRolePermission()->class.rbac.php:415:load()->RbacUsers.php:189:doSelect()->BaseRbacUsersPeer.php:301:doSelectRS()->BaseRbacUsersPeer.php:333:doSelect()->BasePeer.php:467:executeQuery()->PreparedStatementCommon.php:334:executeQuery()->|GET|/sysworkflow/en/neoclassic/processes/main|

[amosbatto]

I wonder if it is one of these problems:
http://wiki.processmaker.com/3.0/Additi ... ullGroupBy
http://wiki.processmaker.com/3.0/Window ... trict_mode
(don't delete your database, just change the setting in MySQL.)

[keyangl]

Neither are set on my database

[amosbatto]

File a bug report about it at bugs.processmaker.com. Maybe the devs have a suggestion.