[resolved] Creating Data Preparation Roles Selection missing

[Anonymous]

Hi,
when i try to create a user for data preparation under TAC, selection of Role is empty. when i select to dropdown there is no roles to be selected.
attached screenshot.
Regards,
Arun

[Anonymous]

Hi,
We have to same problem. Do you have a upgraded installation or fresh install? We have an installation upgraded from 6.1.1 to 6.2.1. (Manual installation)
Thx in advance

Hi Lereve,
please find the solution as below.
could you please check in your TAC database, to see if you have any data in table "datapreprole", if no data, you can try to add it manually by following and restart TAC:

id dtype E_VERSION name localizedlabel fixed
1 DataPrepRole 0 Administrator empty FALSE
2 DataPrepRole 0 Dataset Manager empty FALSE
3 DataPrepRole 0 Data Preparator empty FALSE 


 manually inserted the record to my database(mysql). please check your database whether the table is with records or not.
i got this solution from talend customer care.
cheers
Regards,
Arun

[Anonymous]

Hi,
Have you checked your selected roles and assigned an action to selected Roles for selected Resources.
TalendHelpCenter:Viewing+Roles+and+Users
TalendHelpCenter:Managing+assignments
Best regards
Sabrina

Hi Sabrina,
below is the solution i got from talend customer care.
could you please check in your TAC database, to see if you have any data in table "datapreprole", if no data, you can try to add it manually by following and restart TAC:
id dtype E_VERSION name localizedlabel fixed 
1 DataPrepRole 0 Administrator empty FALSE 
2 DataPrepRole 0 Dataset Manager empty FALSE 
3 DataPrepRole 0 Data Preparator empty FALSE 
Solution : manually inserted the record to my database(mysql).
Regards,
Arun

[Anonymous]

Hi Arun,
Thanks for sharing your solution with us,
Best regards
Sabrina

[Anonymous]

Thx for the solution, it works!

INSERT INTO datapreprole (id, dtype, e_version, name, localizedlabel, fixed)
VALUES
                (1, 'DataPrepRole', 0, 'Administrator', '', b'0'),
                (2, 'DataPrepRole', 0, 'Dataset Manager', '', b'0'),
                (3, 'DataPrepRole', 0, 'Data Preparator', '', b'0');

[Anonymous]

Hi,
Could you please click the "Set this topic as resolved" link which is right underneath your initial post? This way, other users will be informed that this thread has been resolved.
Many thanks.
Best regards
Sabrina