Project

General

Profile

Support #685

Data Attendance Time Data Kosong / Kosong

Added by dian perdana putra almost 3 years ago. Updated almost 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
dian perdana putra
Start date:
12/27/2021
Due date:
% Done:

0%

Estimated time:

Description

Di minova sepertinya banyak data absen saya yang yang hilang. Seperti tgl 1 -14 november tidak ada datanya di minova.

Files

clipboard-202112271830-dg8ol.png (286 KB) clipboard-202112271830-dg8ol.png dian perdana putra, 12/27/2021 06:30 PM
clipboard-202112271831-xtcoe.png (167 KB) clipboard-202112271831-xtcoe.png dian perdana putra, 12/27/2021 06:32 PM
#1

Updated by dian perdana putra almost 3 years ago

dian perdana putra wrote:

Di minova sepertinya banyak data absen saya yang yang hilang. Seperti tgl 1 -14 november tidak ada datanya di minova.

1 . Check Table "select * from PHRPA0019 Where EmployeeID='00000320' and StartDate like '202112%'"
2 . Check Table "select * from MinovaAbsen.dbo.EmployeeHFI where NIK='00000320'"
3 . Check Table "select * from MinovaAbsen.dbo.attendance_karyawan where user_id='00000320' and year(tanggal)=2021 and month(tanggal)=12"

4 . EmployeeID PHRPA00001 di Minova Harus ada di MinovaAbsen.dbo.EmployeeHFI dengan nama Field NIK
5 . Data Di MinovaAbsen.dbo.attendance harus ada di MinovaES_HINO_Prod.dbo.PHRPA0019
6 . Jika MinovaAbsen.dbo.attendance & di MinovaES_HINO_Prod.dbo.PHRPA0019 Tidak sesuai Jalankan Service MinovaES_Hino_Finger ( Restart )

Tetapi check dahulu Field "synced" pada table MinovaAbsen.dbo.attendance.
Data yang akan di proses Service adalah yang value "synced" !=1 ( Bukan 1 ) jadi jika ingin di ulang ubah value ke 0 dulu lalu restart Service.


Also available in: Atom PDF