Skip to main content

SIMANTRA - ISSUE LIST

Appendix​

SQL SERVER

SQL_AUTH = SQLHO01  
SQL_AUTH_DB = OauthDB

ORACLE

ORA_SHP = KNPROD

Common Issues & Troubleshooting​

Issue 1: Ga bisa login​

Login failed: Already Login in device 005m A055F 15 at 12/19/2025 8:27:07 PM. Please Logout in previous device
  1. maka fixingnya harus mengunakan SQL_AUTH
  2. ke TABLE tUserLoginMobile
  3. cari username sesuai user yang ga bisa login terus update dtLogOut isi now()
  4. selesai.

Issue 2 : Update Simantra mobil​

    nopol D 9830 AG non active karena salah vendor.
  1. mengunakan ORA_SHP
  2. SELECT * FROM xxshp.XXSHP_SMT_M_VEHICLE WHERE TXT_NO_POLISI LIKE '%D 9830 AG%';
  3. update sesuai case status/bitactive dsb.
  4. selesai

Issue 3 : Update Status SPM​

    mundurin SPM KNS25120155 dari UNLOADING ke ORDER
  1. mengunakan ORA_SHP
  2. select * from xxshp.xxshp_smt_t_order WHERE spm_no = 'KNS25120155';
  3. UPDATE sesuai request dan ambil 'ORDER_ID'
  4. sekarang kita synconize history order
  5. SELECT * FROM XXSHP.XXSHP_SMT_T_ORDER_HISTORY WHERE ORDER_ID = <ORDER_ID Dari xxshp_smt_t_order>;
  6. hapus / tambahkan history order sesuai request