Process flow works in GUI but not in Universal.

Hi Rucha,

Can you add a bit more of the error message? It is now only containing the stacktrace, but we also need the error message. It will give us more insight what might be the issue.

Hi Dick,

Attaching the complete error log.

Let me know if this error can be seen somewhere else too.

Compliments on the Universal GUI look, really nice 👌🏼

I do see an error regarding "Failed to convert parameter value from a String to a Byte.”. We have received a ticket before with the same error. It occurred due to a domain (datatype Tinyint) with elements with negative values. Could it be that you also use a Tinyint datatype with negative values?

Thanks Mark! :)
I am using Tinyint datatype , but the values are positive :
 

However these values needs to be sent to IAM as user roles, so I tried below code in the control procedure to set the variables the correct values,

    set @email_id = (select email_id from employee_detail where employee_detail_id = @employee_id)
    set @first_name = (select first_name from employee_detail where employee_detail_id = @employee_id)
    set @last_name = (select last_name from employee_detail where employee_detail_id = @employee_id)
    set @tenant_id = '1'
    set @patch_HTTP_code         = null
    set @patch_status_code       = null
    set @pwd_HTTP_code           = null
    set @pwd_status_code         = null
    set @user_group_http_code    = null
    set @user_group_status_code  = null
    set @create_user_HTTP_code   = null
    set @create_user_status_code = null
    
    set @user_group = case
        when (select employee_role from employee_detail where employee_detail_id = @employee_id) = 0 then 'employee'
        when (select employee_role from employee_detail where employee_detail_id = @employee_id) = 1 then 'employee_manager' 
        when (select employee_role from employee_detail where employee_detail_id = @employee_id) = 2 then 'hr_employee'
        when (select employee_role from employee_detail where employee_detail_id = @employee_id) = 3 then 'hr_manager'
        when (select employee_role from employee_detail where employee_detail_id = @employee_id) = 4 then 'admin'
        when (select employee_role from employee_detail where employee_detail_id = @employee_id) = 5 then 'it_manager'
    end
    set @employee_name = (select ed.first_name+' '+isnull(ed.middle_name,' ')+' '+ed.last_name 
    from employee_detail ed where ed.employee_detail_id = @employee_id)

Okay, looks good to me. Little SQL tip, you can place the query next to Case instead of repeating it in the When lines like this:
 

set @user_group = case (select employee_role from employee_detail where employee_detail_id = @employee_id)
                      when 0 then 'employee'
                      when 1 then 'employee_manager' 
                      when 2 then 'hr_employee'
                      when 3 then 'hr_manager'
                      when 4 then 'admin'
                      when 5 then 'it_manager'
                  end

The other error was regarding Indicium not being able to access the path

"System.UnauthorizedAccessException: Access to the path '/opt/Indicium/Employee_Report' is denied.
 System.IO.IOException: Permission denied”

Not sure if that is correct or not, but this could cause some trouble I think.

Thanks for the tip Mark, will make the changes. :)

This path is for the report process, which is not working yet.

This process worked before I connected SMTP connector to send the email to the user with his userid.

We have other process working fine with SMTP connectors.

Hi Mark,

Do you think it will work if I remove the report generation?

Hi Rucha,

I wouldn't know for sure until tried out, so you could temporarily disable it by either removing the process action or by allowing the process flow to go different path (following different steps than usual)

After disabling the report process and IAM sync got stuck.

I tried to abort the job as well. But its not reflecting. Can you please guide how to get past it?

You can try writing the synchronization scripts to storage and execute them manually on the desired IAM database. If the Synchronization to IAM cannot run successfully, it can have multiple reasons which are not relevant at the moment

Thanks for the quick reply Mark!!

Can you please tell how below will be done: You can try writing the synchronization scripts to storage and execute them manually on the desired IAM database. 

I tried doing through synchronization , however its giving error too.
 

Can you open the Jobs screen in the Software Factory? Most likely a job is waiting/active there, you can safely cancel it and if the job is not actively doing anything (by double checking the Activity monitor within SQL Server Management Studio), you can abort if (if the job is active)

When all jobs are cleared, you should be able to start a new Synchronization.

Thanks Mark, I had already aborted the job from Jobs screen in Software Factory. However it did not get aborted.

I checked in the Activity monitor within SQL Server Management Studio as well, however there are no jobs there as well.

Thank you so much for all your help Mark!! Its working now!