How can I increase the column length of Localtimezonecode column in person table

Bharath Kumar shared this question 10 months ago
Answered

Hi Team,

We have a automated way of user creation in YF with a utility, but the localtimezone value is greater than the column length, So user creation is failing with the below error:

ERROR (PersonManager:insertPerson) - SQL Stmt:

INSERT INTO Person (

IpPerson, SalutationCode, FirstName, MiddleInitial,

LastName, FullName, PreferredName, Soundex, Gender,

DateOfBirth, ExposureLevelCode, PrivacyLevelCode,

PreferredContactMethodCode, PrivateKeyId, PrivateURL,

PreferredLanguageCode, ResumeLastUpdate, LocalTimeZoneCode,

ResumeLastCrunch, ResumeWorkStartDate, ProfileLastUpdate, Status)

VALUES (113175,null,N'Allen',null,N'Rondolo',N'Allen Rondolo',N'Allen',N'RNTL ALN',null,null,N'PRIVATE',N'4',N'EMAIL',null,null,N'en',null,N'(GMT+1:00) BRATISLAVA, BUDAPEST, LJUBLJANA, PRAGUE, WARSAW',null,null,null,N'ACTIVE')

BMC:SR:2019-01-23 07:53:26:ERROR (MIAdminProcess:createUser) - Error: java.lang.Exception: DBAction.doInsert() exception: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.

Failing while trying to insert the timezone value: (GMT+1:00) BRATISLAVA, BUDAPEST, LJUBLJANA, PRAGUE, WARSAW', I have tried to increase the length, but it is not allowing me to save " Saving is not permitted". This might also impact the during the upgrade.

Could you please suggest a way to increase the column width.

-Bharath

Comments (3)

photo
1

Hi Bharath,

I would like to know why you want to put those 5 different cities for the one timezone, the important thing is to have GMT+1:00 and then you can have any 1 city to go with that, for example:

N'(GMT+1:00) WARSAW'

For example, I am in Melbourne which is GMT+11:00, but in Yellowfin my timezone is Sydney GMT+11:00, but it doesn't matter just so long as my time is 11 hours ahead of GMT.

regards,

David

photo
1

Hi Dave,

Yes, the problem is the timezone is coming from our remedy application and it is trying to insert into the person table. So for the users with time zone'(GMT+1:00) BRATISLAVA, BUDAPEST, LJUBLJANA, PRAGUE, WARSAW is having an issue.


Dropping and recreating the table would delete the sys admin user, so I dont want to go with that option.

Regards,

Bharath

photo
1

Hi Bharath,

Unfortunately what you're facing is not something Yellowfin will be able to assist you with, as it relates to modifying our repository database, and don't believe that a person should be able to have 5 different timezone set. After all, a person can't live in 5 cities at once ;)

Regards,

David