Solution: This is a known issue in EFP r1.3. It can be fixed by following below steps and it is fixed in EFP r1.4.

1. Open the attached query pcETL spFix_ChangedLabel, make sure you change the destination DB to your pcDATA using replace all.


2. Go to pcINTEGRATOR -> table Member. Verify whether you have Time row, if not, add it in modify mode.

SELECT *
  FROM [pcINTEGRATOR].[dbo].[Member]
  WHERE MemberID IN (1000, 30000000)


3. Truncate table S_DS_Time from pcDATA DB


4. Run night load job from SQL Server Agent.


DONE.