Full username is not displayed after logging in

Question

Full username is not displayed after logging in

Julia Kurakula 46

We are using DotNet WCF. This is DEV Code. When we pointed Dev database to TEST, it shows full username. So, I think there is issue with the WCF or the the stored procedure's out parameter is not completely taken in by the WCF code. Also, I think there's no issue with the WEB app since, I pointed endpoint address of test in DEV web.config and it shows full username.

WcfServiceSVC.cs logic:

public string GetEmpName(int employeeID)
{
var credLogic = new Logic.Credentials.CredentialsLogic();

            var empName = credLogic.GetEmpName(employeeID);  
  
            return empName;  
  
        }

Credentials Logic:

public string GetEmpName(int employeeId)
{
string empName = string.Empty;

        Database abcDatabase;  
        DbCommand abcCommand = null;  

        try  
        {                 
            abcDatabase = DatabaseFactory.CreateDatabase(abcConnectString);  

            abcCommand = abcDatabase.GetStoredProcCommand("abc.ws_get_web_empname");  
            abcCommand.CommandType = CommandType.StoredProcedure;  

            // in  
            abcDatabase.AddInParameter(abcCommand, "p_emp_id", DbType.VarNumeric, employeeId);  

            // out  
            abcDatabase.AddOutParameter(abcCommand, "p_emp_name", DbType.String, 65);  

            // run  
            abcDatabase.ExecuteNonQuery(abcCommand);  
            empName = abcDatabase.GetParameterValue(abcCommand, "p_emp_name").ToString();  

            //Added:  
            //empName = abcCommand.Parameters[0].Value.ToString();  
            //Log("EmpId=" + employeeId.ToString() + ", EmpName: " + empName);  
        }

Stored Procedure:

create or replace procedure ws_get_web_empname
(
p_emp_id in number,
p_emp_name out varchar2
)
as
begin

   select name_formatted_pcl  
 into p_emp_name  
     from people  
     where people_id = p_emp_id;  
   exception  
     when NO_DATA_FOUND then  
       p_emp_name := '';

end;
Output is showing only First name + Initial of surname that is it shows "Julia K" and not the full name "Julia Kurakula". Let me know if you need further info to help me solve the issue.

AgaveJoe 30,126 Reputation points

2022-11-03T10:40:49.203+00:00
The stored procedure clearly returns the p_emp_name from the people table where where people_id = p_emp_id. Query the people table using management studio where XX is the Id you're looking up. Does it contain only the first name?

SELECT p_emp_name from people where where people_id = XX

If p_emp_name contains only the first name then either there is a problem populating p_emp_name which is elsewhere in the code base or you do not understand the people table. A table column containing the first and last name breaks the first normalized form in database design. Perhaps DEV has a data bug? Do all the name_formatted_pcl fields contain a first and last name?
Julia Kurakula 46 Reputation points

2022-11-03T11:10:52.133+00:00

Hi @AgaveJoe , yes in people table under name_formatted_pcl column contains Full name.
Viorel 122.5K Reputation points

2022-11-03T12:23:18.867+00:00

Where did you check the results? For example, is empName wrong in the GetEmpName functions?
AgaveJoe 30,126 Reputation points

2022-11-03T12:42:23.517+00:00

Are you sure 111545 is the ID passed to GetEmpName() and not zero which is the default value of an int? Keep in mind, the table design is normalized to the first form which can cause error like this because any updates to the first, last, and maybe the preferred name forces an update to the 3 other fields.

Have you tried testing the procedure in management studio? Does the procedure return the expected column value in the test environment?
Julia Kurakula 46 Reputation points

2022-11-03T13:25:08.88+00:00

@AgaveJoe Yes 111545 is the ID passed to GetEmpName() when I hovered on the EmployeeID in the C# code, it shows the user ID as 111545.

And yes I used the same procedure in the test and prod environment and it gives expected result that is , Full Name of the user.
Julia Kurakula 46 Reputation points

2022-11-03T13:28:01.75+00:00

Actually the Name displayed is Julia K (First Name + Initial of Sur Name). Not the preferred Name(Julia) as shown in the image above.
We even thought it might be due the length of the name that its causing the issue, and passed the First name of length 10. It displays the First Name which is of length 10 characters but not the Sur Name after it.
Julia Kurakula 46 Reputation points

2022-11-03T13:32:29.537+00:00

@Viorel , empName is supposed to get the Employee Name from the Database stored Procedure on validating with the Employee ID passed in the C# code to the Database. The employee ID 111545 is mapped to only 1 user in the database. But it is not getting the Full Name. Only First Name with Initial of Surname like : "Julia K" is displayed Instead of Full NAme: "Julia Kurakula".
Viorel 122.5K Reputation points

2022-11-03T14:20:38.777+00:00

It is not clear if you checked the intermediate variables or just the displayed Web page. Perhaps the problem is not in the shown code.

Maybe you should specify some size for your SQL variables and parameters, for example: p_emp_name out varchar2(100).

1 answer

Your answer

AgaveJoe 30,126 Reputation points

2022-11-03T10:40:49.203+00:00

The stored procedure clearly returns the p_emp_name from the people table where where people_id = p_emp_id. Query the people table using management studio where XX is the Id you're looking up. Does it contain only the first name?

SELECT p_emp_name from people where where people_id = XX

If p_emp_name contains only the first name then either there is a problem populating p_emp_name which is elsewhere in the code base or you do not understand the people table. A table column containing the first and last name breaks the first normalized form in database design. Perhaps DEV has a data bug? Do all the name_formatted_pcl fields contain a first and last name?
Julia Kurakula 46 Reputation points

2022-11-03T11:10:52.133+00:00

Hi @AgaveJoe , yes in people table under name_formatted_pcl column contains Full name.
Viorel 122.5K Reputation points

2022-11-03T12:23:18.867+00:00

Where did you check the results? For example, is empName wrong in the GetEmpName functions?
AgaveJoe 30,126 Reputation points

2022-11-03T12:42:23.517+00:00

Are you sure 111545 is the ID passed to GetEmpName() and not zero which is the default value of an int? Keep in mind, the table design is normalized to the first form which can cause error like this because any updates to the first, last, and maybe the preferred name forces an update to the 3 other fields.

Have you tried testing the procedure in management studio? Does the procedure return the expected column value in the test environment?
Julia Kurakula 46 Reputation points

2022-11-03T13:25:08.88+00:00

@AgaveJoe Yes 111545 is the ID passed to GetEmpName() when I hovered on the EmployeeID in the C# code, it shows the user ID as 111545.

And yes I used the same procedure in the test and prod environment and it gives expected result that is , Full Name of the user.
Julia Kurakula 46 Reputation points

2022-11-03T13:28:01.75+00:00

Actually the Name displayed is Julia K (First Name + Initial of Sur Name). Not the preferred Name(Julia) as shown in the image above.
We even thought it might be due the length of the name that its causing the issue, and passed the First name of length 10. It displays the First Name which is of length 10 characters but not the Sur Name after it.
Julia Kurakula 46 Reputation points

2022-11-03T13:32:29.537+00:00

@Viorel , empName is supposed to get the Employee Name from the Database stored Procedure on validating with the Employee ID passed in the C# code to the Database. The employee ID 111545 is mapped to only 1 user in the database. But it is not getting the Full Name. Only First Name with Initial of Surname like : "Julia K" is displayed Instead of Full NAme: "Julia Kurakula".
Viorel 122.5K Reputation points

2022-11-03T14:20:38.777+00:00

It is not clear if you checked the intermediate variables or just the displayed Web page. Perhaps the problem is not in the shown code.

Maybe you should specify some size for your SQL variables and parameters, for example: p_emp_name out varchar2(100).

Answer 1

Maybe you should specify some size for your SQL variables and parameters, for example: p_emp_name out varchar2(100).

In SQL Server varchar is the same thing as varchar(1). But Julia appears to be using Oracle (despite that she tagged her post with sql-server-general?), and I don't know what applies on Oracle.

In any case, according to her screenshot, the expected value is Kurukula, Julia, so if she gets back Julia K, it is not a matter of mere truncation.

I can think of two things:

You are not connecting to the server/database you think you are connect to.
There is something "interesting" with the table. Did you try running the stored procedure on its own to see what it returns?

Share via

Full username is not displayed after logging in

1 answer

Your answer