Based on the job as in the attached image, i want to count the rows executed and for every %5 executions send a constant int value to a newly created column in the output table. Any advice how to manage it if possible?
I modified the job as in the attachment but it shows me:
Exception in component tDBSP_2 (DataQuality) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Incorrect number of arguments for PROCEDURE ods_aui.dq_insert_result; expected 5, got 6 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1307) at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:921) at ods_main.dataquality_0_1.DataQuality.tMysqlInput_1Process(DataQuality.java:4906) at ods_main.dataquality_0_1.DataQuality.tJava_1Process(DataQuality.java:939) at ods_main.dataquality_0_1.DataQuality.runJobInTOS(DataQuality.java:6537) at ods_main.dataquality_0_1.DataQuality.main(DataQuality.java:6164)
I added the column on the database and on the schemas but it keeps showing me the error.
