Support #1534
[ESS PMS] - Error posting PHRPA0051
0%
Description
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
Files
.png){kind=link}
.png){kind=link}
Updated by Fiona Avangeline Jonathan about 2 years ago
- Description updated (diff)
- Status changed from New to Assigned
Updated by Mr. Yusuf about 2 years ago
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).
.
Updated by Mr. Yusuf about 2 years ago
- Assignee changed from Mr. Yusuf to Fiona Avangeline Jonathan
Updated by Fiona Avangeline Jonathan about 2 years ago
- File ROHTO_DB_FIELDPOST_PA51.xlsx ROHTO_DB_FIELDPOST_PA51.xlsx added
- Status changed from QA Test to Assigned
- Assignee changed from Fiona Avangeline Jonathan to Mr. Yusuf
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.
Updated by Mr. Yusuf about 2 years ago
Fiona Avangeline Jonathan wrote in #note-5:
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.
RegID yang mana?
Updated by Mr. Yusuf about 2 years ago
- File Screenshot (172).png Screenshot (172).png added
- File Screenshot (173).png Screenshot (173).png added
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
Updated by Fiona Avangeline Jonathan about 2 years ago
- Status changed from Assigned to Closed
Pak Yusuf,
PMS Goal Setting sudah berhasil terposting, terima kasih.
Updated by Muhammad Bintar about 2 years ago
Dear Pak Ucup,Azid dan fiona
Apa saja yang perlu di deploy untuk ke client??
saya sudah tes di kantor dan sudah bisa untuk mengajukan ess pms goal setting.