CLIENT SUPPORT » ROHTO BUGS

Fiona Avangeline Jonathan wrote:

Pak Yusuf,

Mohon dibantu pak ada error ketika posting saat create form ESS PMS Goal Setting. Error yang muncul di RUNTASKASYNC adalah proc_data_PHRPA0051-error on Create:Failed to convert parameter value from a String to a Decimal. - MinovaIS.MinovaES.Business.WorkFlow.

RegID contoh: 2649

Port: http://remote.minovais.com:61121/
Login: fiona
DB: remote.minovais.com,1445 | MinovaES_Rohto_Prod

Banyak mapping yg tidak cocok antara table DEFBIZDATA, FIELDPOST, PHRPA0051, dan PCMWFCUSTPARAM (ID=WFPMSDEFAULTQUALG).
.

Pak Yusuf,

isu posting masih belum terselesaikan, masih ada error proc_data_PHRPA0051-error on Create:Failed to convert parameter value from a String to a Decimal. - MinovaIS.MinovaES.Business.WorkFlow ketika posting . Saya sudah gunakan excel untuk mapping field2 saat posting namun belum berhasil. Mohon dibantu pak.

Terima kasih.

Fiona Avangeline Jonathan wrote in #note-7:

RegID 2648 pak.

Errornya : Cannot insert duplicate key in object 'dbo.PHRPA0051'. The duplicate key value is (00000058, G, 26, 24, 0).
Artinya ada key yg double saat masuk ke PA51.
Coba cek di runbizdata yg mau diposting ke PA51
SELECT TOP (200) RegID, Sequence, BizProcessID, TableReference, FieldID, DataSequence, Value
FROM PCMWFRUNBIZDATA
WHERE (RegID = 2650) AND (Sequence = 4) AND (TableReference = 'PHRPA0051ESS') AND (FieldID IN ('HeaderSequence_51', 'Sequence_51', 'SequenceSub_51', 'AppraisalType_51'))
ORDER BY FieldID, DataSequence

Terlihat Sequence_51 isinya 24 semua, seharusnya kan 1,2,3 (urutan).

Setelah dicek ternyata saat create request Goal pertama kali saat mengambil list Qualification dari tabel OM8, data sequencenya jg isinya 24 semua.
Coba diubah sequence di OM8 nya dulu, terus request lg

Pak Yusuf,

PMS Goal Setting sudah berhasil terposting, terima kasih.