Skip to main content
Solved

Compensation Page Does Not Load - Data mapping error due to type mismatch

  • September 16, 2022
  • 5 replies
  • 861 views
Shangavi Subendrarajah
Sidekick (Employee)
Forum|alt.badge.img+6

Hi,

 

I have an issue in IFS CLOUD 22R2. 

In Human Capital Management/HCM Services/Employee Management/Employee File, when we select the Compensation we get a Server Error. When we checked the detail below error was displayed:

 

Url:<customer_utl>/main/ifsapplications/projection/v1/PersonnelFileCompensationHandling.svc/CompanyPersonSet(CompanyId='XXX',EmpNo='XXX')/EmpSalaryInfoSet?$filter=(ValidTo%20ge%202022-09-14%20and%20ValidFrom%20le%202022-09-14)&$orderby=ValidFrom%20desc&$select=PayrollVendor,PropertyCodeWageClass,PropertyCodeWageCodes,CompanyId,Objgrants,EmpNo,ValidTo,AmountperPayPeriod,Amount,SalaryPeriod,FullTimeAmount,CurrencyCode,PayFrequency,ValidFrom,WageClass,WageCode,BasicSalary,PayType,PayTypePeriod,PlannedAmount,TransferToPayroll,NoWageClassLovValidations,LastUpdated,Notes,Objstate,PayrollVendorExist,SalaryReasonId,Cf_Planned_Pct_Of_Base,Cf_Base_To_Commission_Ratio,luname,keyref&$expand=CurrencyCodeRef($select=Description,luname,keyref),PayTypeRef($select=PayTypeDescription,luname,keyref),SalaryWageClassRef($select=WageClassName,luname,keyref),SalaryWageCodeRef($select=WageName,PerResWageGrp,WageType,luname,keyref),ReasonForChangeRef($select=SalaryChangeReason,luname,keyref)&$skip=0&$top=25


        Date = 2022-09-14T08:58:34.748Z
        Request Id = b924df24-6784-42e0-af6d-4979a4538752
        Client version = 22.1.5.20220804125354.0

 

As a workaround we tried to clear the cache, then it was working. However next day the error was recreated. 

 

Could anyone can provide a solution for this issue? 

 

Regards,

Shangavi.

Best answer by Sachini Epa

Hi Shanghavi,

I have come across a similar scenario and sometimes this issue occurs due to incompatible values in the underlying table.

You can check the table from which the data is fetched for this page and that might contain incompatible values as such which will lead to this error.

Thank you.
Best Regards,
Sachini

View original
Did this topic help you find an answer to your question?

5 replies

S
Do Gooder (Employee)
Forum|alt.badge.img+4
  • Sachini Epa
  • Do Gooder (Employee)
  • 11 replies
  • Answer
  • September 21, 2022

Hi Shanghavi,

I have come across a similar scenario and sometimes this issue occurs due to incompatible values in the underlying table.

You can check the table from which the data is fetched for this page and that might contain incompatible values as such which will lead to this error.

Thank you.
Best Regards,
Sachini

Shangavi Subendrarajah
Sidekick (Employee)
Forum|alt.badge.img+6

Hi @Sachini Epa,

 

I thought the same but the records seems to be fine. When we refresh the cache and meta-cache the issue gets resolves. And this is for all the end users and for all the employees in the employee file. 

 

Any other reasons to solve the issue?

 

Thank you.

Best regards,

Shangavi

prlalk
1 person likes this
  • prlalk
    prlalk
Shangavi Subendrarajah
Sidekick (Employee)
Forum|alt.badge.img+6

HI @Sachini Epa ,

 

It was noted that Transfer_to_payroll value in database was ‘False’ which actually should be ‘FALSE’. 

 

When we sort this, we were able to fix it. 

 

Regards,

Shangavi

Yasas Kasthuriarachchi
S
L
5 people like this
  • Yasas Kasthuriarachchi
    Yasas Kasthuriarachchi
  • S
    Sachini Epa
  • L
    Lakshan Kulasinghe
  • prlalk
    prlalk
  • T
    truth_trump
Yasas Kasthuriarachchi
Superhero (Employee)
Forum|alt.badge.img+30

HI @Shangavi Subendrarajah,
Thanks for posting the answer too, would you be able to create a KBA on this and comment it here or under our Master Article so I will include it in: 

https://community.ifs.com/framework-and-experience-101/master-article-sorry-there-was-an-unexpected-server-error-26523

Thanks & Best Regards,
Yasas 

Shangavi Subendrarajah
Sidekick (Employee)
Forum|alt.badge.img+6

Hi @Yasas Kasthuriarachchi ,

Kindly see the below KBA article, however this needs to be reviewed. 

 

KB0042691

 

Regards,

Shangavi

prlalk
1 person likes this
  • prlalk
    prlalk

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings