Error executing sql: insert into client_stats

[dfernandez]

Hello,

I was receiving many error in the log about client_stats so I created the log and client_stats table in the developer and generated the war again, but now I receive that error in the servoy-admin log: Error executing sql: insert into client_stats
com.servoy.j2db.dataprocessing.DataException: Unknown errorCode 100
ERROR: null value in column "pk_id" violates not-null constraint

Error executing sql: insert into client_stats (pk_id, server_ip, server_name, total_clients_running, client_id, start_time, stop_time, extra_info, user_uid) values (?, ?, ?, ?, ?, ?, ?, ?, ?) with params: [NullValue with type: 4 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, '10.240.64.4' ,type: java.lang.String, 'diego' ,type: java.lang.String, 1 ,type: java.lang.Integer, '0BAF36AA-6399-44CF-9F7A-9EF64D783860' ,type: java.lang.String, 2023-04-05 21:16:28.365 ,type: java.sql.Timestamp, NullValue with type: 93 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue, 'HMotXMe+qjs70EaF9Pg2sg==' ,type: java.lang.String, NullValue with type: 12 ,type: com.servoy.j2db.dataprocessing.ValueFactory$NullValue]

Any ideas?

[rgansevles]

Hi,

When you open the clientstats table in Servoy Developer, what sequence type does the pk_id column have?
It should be something like servoy seq

Rob

[dfernandez]

Hi,

Yes, it was servoy seq. I changed to db identity trying to solve the error but Servoy says that it will not do that change into the database.

[rgansevles]

Do you get the error in Developer as well or is the client_stats table being filled ok there?

Rob

[dfernandez]

No. Nothing happens into the Developer.

I solved changing the pk_id Sequence Type to db identity. Deleted the client_stats table in the server and uploaded the war again.

Thank you