Error SLIK “Gagal Mengirim Signature, Gagal Decrypt Signature”

Error SLIK "Gagal mengirim signature, Gagal decrypt signature!"

Jika anda bekerja di perusahaan leasing atau perusahaan pembiayaan dan sejenis-nya yang mewajibkan perusahaan anda membuat laporan SLIK (Sistem Laporan Informasi Keuangan) ke OJK ( Otoritas Jasa Keuangan ) tiap bulan-nya. Kali ini saya akan sharing mengenai error pada aplikasi SLIK yang pernah saya temui yaitu pada saat Mengirim / Upload data muncul error “Gagal Mengirim Signature, Gagal Decrypt Signature!”. Kemudian jika kita lihat file signature menggunakan menu Buka File Error, aplikasi SLIK akan menampilkan error “File Signature tidak ditemukan!”. 

Error SLIK "File signature tidak ditemukan!"

Solusi standart biasanya anda akan menghubungi OJK melalui hot line atau e-mail, tetapi percayalah respon-nya tidak akan secepat yang anda harapkan. Ketika anda mendapatkan e-mail balasan pun biasanya solusi-nya tidak tepat. Untuk kasus yang saya alami ini, saya bisa maklum ke team OJK karena error ini akan jarang terjadi di tempat lain, sehingga akan sulit mencari persamaan-nya. Solusi dari masalah ini akhirnya saya temukan sendiri.

Masalah yang muncul pada kasus saya adalah karena salah satu aturan OJK untuk pelaporan SLIK adalah setiap akhir bulan sehingga jika melaporkan dengan range waktu yang terlalu jauh, misal laporan Oktorober 2021 dilaporkan Januari 2022 maka aplikasi SLIK yang berbasis Java ini akan menampilkan pesan error “Gagal Mengirim Signature, Gagal Decrypt Signature!”. Hal ini tentu saja akan membuat anda tidak paham dan akan semakin pusing, karena pesan error-nya sendiri tidak jelas.

Solusinya ganti tanggal sistem komputer anda minimal B + 1 dari, misal bulan laporan  yang anda akan kirim yaitu Januari 2021, maka tanggal pada sistem komputer yang akan anda pakai untuk mengirim laporan SLIK minimal bulan Februari 2021 jika terlalu jauh atau melewati tahun maka akan muncul error seperti di atas. 

Q : Pertanyaan-nya adalah kenapa bisa terpaut jauh antara bulan pelaporan dengan bulan sistem komputer anda?

A : Jawabanya ada 2, yaitu anda atau perusahaan anda memang sangat terlambat untuk melaporkan laporan SLIK, atau tanggal sistem pada komputer anda ter-reset karena baterai CMOS habis atau ada yang merubahnya karena alasan tertentu.

Semoga bermanfaat.

How Fast JSON on Android ?

This time, I will show you, how fast Android Application parsed JSON from Microsoft SQL Server. I've used Android Emulator ( AVD Manager ), perhaps it will be so much faster on the real Android handset. First I check my speed connection with speedtest.net, and here is the result

 

And then i check signal bar on my modem, and here is the result 

I will query 1478 records from Microsoft SQL Server via internet using PHP web service from my house, it takes at least 10 seconds, on local network it takes at least 5 second, you can checked at this video.

When I use keyword for searching the records it takes under 2 seconds.

 

That means, JSON is fast enough to transfer data from Microsoft SQL Server to Android.

related links:

Ubuntu-Apache-PHP-FreeTDS-MS SQL

Android-PHP-Microsoft SQL Server

Android - PHP - Microsoft SQL Server

As I promised before, now I would like to share how to create Android applications that connect to Microsoft SQL Server database, using PHP Web Service. And one more thing I want to teach you about how to make Android application WITHOUT using the JAVA programming language. Okay, the tools we will use this time are:

1. Basic 4 Android, you can download it here.
2. XAMPP as a web server, you can download it here.
3. Microsoft SQL Server 2000, 2005 Express, 2005, 2008 or later, you can download it here.
4. Microsoft Drivers for PHP for SQL Server, you can download it here.
5. Android SDK which you can download here and Java JDK here.

First you must install the Basic 4 Android, and of course you have to buy licenses to use the library functions in it.

Then install XAMPP, need to be considered for connection to Microsoft SQL Server 2000 I recommend to use the old version for example XAMPP version 1.6.8. If you use Microsoft SQL Server 2005 and above, I recommend to install the latest version of XAMPP and also install the SQL Server Driver for PHP which you can download here. This is because the new version of XAMPP is not included drivers for connection from PHP to Microsoft SQL Server.

I will not go into too much detail for the setting on the Basic 4 Android, then XAMPP, I assume that you can, because if I was too detailed to discuss this article becoming too long. I hope you can understand, if you have any questions , you can email me at: budy_wijaya@yahoo.com or through comments on this blog.

First time we will make the user interface in the Basic 4 Android, by first running the Android SDK - AVD manager.


Then connect the menu Designer at Basic 4 Android to AVD manager.


Then create a login view, user text box, password text box, then the Login button, then save by name Login_Form, as shown below


Then we move to make the code in Basic 4 Android, the language used is Basic, or Visual Basic Like. First put all the variables in Sub Globals, as shown below


Then the procedure Activity_Create type the code shown below, the function of this code is to load Login_Form. And do not forget to checked the necessary library ,library http and json library.


Then create a procedure to capture input on user text box , create a procedure and code like in the picture below


For complete syntax querp.php you can see here and you have to replace mysql_connect to mssql_connect (because we used Microsoft SQL Server not MySQL as database server), if you use XAMPP is necessary to note problems like this.

Then at procedure hc_responseSuccess, type the code as shown below:


When finished,try to run the program in Basic 4 Android, for the initial setting Basic 4 Android, you can see the tutorial here


Then try the user name previously already exists in Microsoft SQL Server database, and then press enter, if successful it will appear as below:


Related Links:

How to connect Java to MySQL

How to connect Java to SQL Server

Ubuntu-PHP-Apache-FreeTDS-MS SQL Server 

How Fast JSON on Android?

How to Connect Java to MySQL

After we learn how to connecting Java Program to Microsoft SQL Server, now we learn to connecting our java program to MySQL.

So we must prepare tools for that, and the tools is:

1. NetBeans IDE 7.0, you can download here.
2. MySQL 5.0 , and you can download here.
3. JDBC Driver for MySQL, you can download on this site. Add this driver to our Java Project library that we will make it.

First, we must create project Java on NetBeans IDE, for the example ConnectMySQL.
And then create packages by right click on Source Packages and choose New -> Java Packages and create name on that packages for the example same with the Project Name Connect MySQL.

After that, create one class by right click on our new packages , and choose New -> Java Class and create our New Java Class with MySQLConnection.java and type or copy paste this code on our new Java Class.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

class MySQLConnection{
Connection Connect;
public Connection ConnectDB(){
String url = "jdbc:mysql://localhost/test";
try{

Class.forName("com.mysql.jdbc.Driver");
Connect = DriverManager.getConnection(url, "root", "root");

}catch(ClassNotFoundException e){
System.out.println("Driver Load Failed!");
}catch(SQLException e){
System.out.println("Connection Failed!");
}
return Connect;
}


public static void main(String[] abc){
Connection Con = new MySQLConnection().ConnectDB();
if(Con != null){
System.out.println("Connection Succesfull!");
}else{
System.out.println("Connection Failed!");
}
}
}

If you have finished, then we must create New Java Form by right click on MySQLServer packages and then choose New -> JFrame Form. And create one button and name on it with "Test Connection MySQL". And then copy paste this code to our new button.

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
Connection con = new MySQLConnection().ConnectDB();
try{
if(con != null){
JOptionPane.showMessageDialog(null, "Connection Succesfull!");
}else{
JOptionPane.showMessageDialog(null, "Connection Failed!");
}
}catch(Exception e){

}
}

and do the same thing like our Java to SQL Server project.

How to Connect Java to SQL Server

This time, we learn how to connecting Our Java program to Microsoft SQL Server, i hope this article will help you and everyone to code on Java, have fun!

Tools :

1. NetBeans IDE 7.0 download here.
2. SQL Server 2008 Enterprise / SQL Server Express, you can download here.
3. Microsoft JDBC Driver for SQL Server, you can download here. And dont forget to add the library on our Java project.

First, we must create project Java on NetBeans IDE, for the example ConnectSQLServer.
And then create packages by right click on Source Packages and choose New -> Java Packages and create name on that packages for the example same with the Project Name Connect SQLServer.

After that, create one class by right click on our new packages , and choose New -> Java Class and create our New Java Class with SQLServerConnection.java and type or copy paste this code on our new Java Class.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

class SQLServerConnection{
Connection Connect;
public Connection ConnectDB(){
String url = "jdbc:sqlserver://localhost:1433;databaseName=tempdb;";
try{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connect = DriverManager.getConnection(url, "sa", "p455w0rd");

}catch(ClassNotFoundException e){
System.out.println("Driver Load Failed!");
}catch(SQLException e){
System.out.println("Connection Failed!");
}
return Connect;
}


public static void main(String[] abc){
Connection Con = new SQLServerConnection().ConnectDB();
if(Con != null){
System.out.println("Connection Succesfull!");
}else{
System.out.println("Connection Failed!");
}
}
}

If you have finished, then we must create New Java Form by right click on ConnectSQLServer packages and then choose New -> JFrame Form. And create one button and name on it with "Test Connection SQL Server". Let code the button with this code:

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
Connection con = new SQLServerConnection().ConnectDB();
try{
if(con != null){
JOptionPane.showMessageDialog(null, "Connection Succesfull!");
}else{
JOptionPane.showMessageDialog(null, "Connection Failed!");
}
}catch(Exception e){

}
}


And Now we can check the code and run the program on NetBeans by press F6, test it!