Project

General

Profile

Bug #2368

[ESS-MEDICAL] Medical plafon tidak menginsert ke phrpa0043 dan terjadi error

Added by Muhammad Bintar 12 months ago. Updated 11 months ago.

Status:
Closed
Priority:
Normal
Assignee:
M Azid Wahyudi
Start date:
10/13/2023
Due date:
10/19/2023
% Done:

0%

Estimated time:
Spent time:
22.00 h

Description

Dear tim developer ,
mohon support nya untuk perbaikan pada ess medical dimana pada saat mengajukan medical itu ada yang nyangkut di runtaskasync.
regid 28708, 28710, 28711

proc_data_md0041-Update_PHRPA0041_1 Failed to convert parameter value from a String to a Int64. - MinovaIS.MinovaES.Business.WorkFlow

proc_data_md0043-error on Create:Violation of PRIMARY KEY constraint 'PK_PHRPA0043_1'. Cannot insert duplicate key in object 'dbo.PHRPA0043'. The duplicate key value is (00000610, 1, 1).
The statement has been terminated. - MinovaIS.MinovaES.Business.WorkFlow

contoh employee 00000610

remote.minovais.com: 31120
remote.minovais.com, 1458 sql server 2019

Files

package ESS Medical.xlsx (20.4 KB) package ESS Medical.xlsx settingan db M Azid Wahyudi, 10/18/2023 03:38 PM
clipboard-202310261051-kenfg.png (75.5 KB) clipboard-202310261051-kenfg.png Muhammad Bintar, 10/26/2023 10:51 AM
clipboard-202310261052-yxauw.png (38.7 KB) clipboard-202310261052-yxauw.png Muhammad Bintar, 10/26/2023 10:52 AM
clipboard-202310261447-qtgyu.png (126 KB) clipboard-202310261447-qtgyu.png M Azid Wahyudi, 10/26/2023 02:47 PM
clipboard-202311011550-nqrda.png (192 KB) clipboard-202311011550-nqrda.png Muhammad Bintar, 11/01/2023 03:50 PM
#1

Updated by M Azid Wahyudi 12 months ago

dear masbin , udah bisa di test ya di port prod 61120 , issue ini karena banyak yg rancu yg bikin ess medical ini tidak stabil

package :

- DLL API1 & API 2 : MinovaIS.Implementation.Data.Element.MedHino.dll //ambil aja dllnya di prod
- bizproc medical(afterrender)
- custparam
> (AZ_IsMDCLUpdateHeaderSeq) // new
> WFMEDGETPLAFORI // edit

settingan :

- BizData
- Bizflow
- Deftask
- Deftaskcon

makasih

#2

Updated by Muhammad Bintar 12 months ago

update:
ane udah testing 2 pengajuan ess medical, tapi ada problem pas di medical pa43 nya

seharusnya amount nya 700000, kayaknya salah posting tabel field nya

#3

Updated by Muhammad Bintar 12 months ago

setelah di cek , ternyata di inbox atasan nya yang salah pada kolom covered by company nya. seharusnya itu tetep membaca dari tabel runbizdata dari creator saja sesuai yang tadi diinput oleh requester.

#4

Updated by M Azid Wahyudi 11 months ago

dear masbin , udah bisa di test ya

package :
bizproc (afterrender)

makasih

#5

Updated by Muhammad Bintar 11 months ago

okeh sudah dideploy ke server HINO development dan production

Also available in: Atom PDF