Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Counting Rows after Execution

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?

Labels (2)
1 Reply
Anonymous
Not applicable
Author

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.


Annotation 2020-02-27 123227.png