{"id":190,"date":"2017-02-28T13:12:46","date_gmt":"2017-02-28T13:12:46","guid":{"rendered":"http:\/\/kloxo.id\/?p=190"},"modified":"2017-03-01T11:53:39","modified_gmt":"2017-03-01T11:53:39","slug":"gagal-update-master-ya","status":"publish","type":"post","link":"https:\/\/kloxo.web.id\/?p=190","title":{"rendered":"Gagal Update Master Ya?"},"content":{"rendered":"

Bila berjalan lancar..spse4 akan menunjukkan hasil update master instansi dkk seperti tampilan dibawah ini :<\/p>\n

\"1<\/a><\/p>\n

dan tidak selalu berjalan lancar, banyak juga yang mendapatkan pesan gagal update.<\/p>\n

sebaiknya mulai dari pemeriksaan konfigurasi dns \/etc\/resolv.conf, dan lakukan uji ping ke domain inaproc, sirup, sikap.<\/p>\n

dan cek\u00c2\u00a0webapp\/conf\/application.conf, pada baris berikut :<\/p>\n

sirup.url=https:\/\/sirup.lkpp.go.id\/sirup
\nsikap.url=https:\/\/sikap.lkpp.go.id
\nspse3.url=http:\/\/domainlpse\/eproc
\ndce.url=http:\/\/report-lpse.lkpp.go.id\/dce<\/p>\n

(setelah perubahan setting app conf, restart spse4 nya)<\/p>\n

bila tindakan diatas sudah dilakukan dan masih juga gagal update…hubungi lkpp…wkwkkw<\/p>\n

lanjut deh…kalo cara diatas belum mengatasi masalah update master, dicek ke log kira2 menghasilkan kalimat seperti ini :<\/p>\n

org.sql2o.Sql2oException: Error in executeUpdate, ERROR: update or delete on table “kabupaten” violates foreign key constraint “fk_rekanan_kabupaten” on table “rekanan”
\nDetail: Key (kbp_id)=(268933) is still referenced from table “rekanan”.<\/p>\n

kalo sudah begini..perlu treatment serius deh…hi hi,<\/p>\n

pasang phppgadmin, tata cara install nya bisa merujuk ke https:\/\/www.liquidweb.com\/kb\/how-to-install-and-configure-phpmyadmin-on-centos-6\/<\/a> atau ke https:\/\/tecadmin.net\/how-to-install-phpmyadmin-on-centos-using-yum\/<\/p>\n

akses phppgadmin dan mulailah menelusuri tabel ‘rekanan’, error diatas menunjuk rekanan yg menggunakan kbp_id = 268933 :<\/p>\n

\"3<\/a><\/p>\n

(contoh tabel rekanan)<\/p>\n

dan cek ke tabel kabupaten yang ber kbp_id = 268933 :<\/p>\n

\"2<\/a><\/p>\n

(contoh tabel kabupaten)<\/p>\n

adanya rekanan yg menggunakan kbp_id dengan kbp_nama = SPSE VARIANT akan menyebabkan update master gagal.<\/p>\n

diperbaiki dengan mengubah kbp_id rekanan ybs ke kbp_id = NULL atau diperbaiki sesuai alamat rekanan ybs.<\/p>\n

selamat mencoba, jangan lupa backup sebelum mulai bekerja…#upayaadajalanpulang<\/p>\n

catatan : kalo males pasang phppgadmin, bisa menggunakan CLI nya aja dari console linux \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"

Bila berjalan lancar..spse4 akan menunjukkan hasil update master instansi dkk seperti tampilan dibawah ini : dan tidak selalu berjalan lancar, banyak juga yang mendapatkan pesan gagal update. sebaiknya mulai dari pemeriksaan konfigurasi dns \/etc\/resolv.conf, dan lakukan uji ping ke domain inaproc, sirup, sikap. dan cek\u00c2\u00a0webapp\/conf\/application.conf, pada baris berikut : sirup.url=https:\/\/sirup.lkpp.go.id\/sirup sikap.url=https:\/\/sikap.lkpp.go.id spse3.url=http:\/\/domainlpse\/eproc dce.url=http:\/\/report-lpse.lkpp.go.id\/dce (setelah perubahan […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-190","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=190"}],"version-history":[{"count":3,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/190\/revisions"}],"predecessor-version":[{"id":196,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/190\/revisions\/196"}],"wp:attachment":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}