# Error executing sql: insert into client\_stats

**URL:** <https://forum.servoy.com/t/error-executing-sql-insert-into-client-stats/20981>\
**Category:** Questions\
**Created:** [April 5, 2023, 9:23pm UTC](https://forum.servoy.com/t/error-executing-sql-insert-into-client-stats/20981 "2023-04-05T21:23:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dfernandez](https://avatars.discourse-cdn.com/v4/letter/d/da6949/32.png) [@dfernandez](https://forum.servoy.com/u/dfernandez)\
**Post date:** [April 5, 2023, 9:23pm UTC](https://forum.servoy.com/t/error-executing-sql-insert-into-client-stats/20981/1 "2023-04-05T21:23:03Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [April 7, 2023, 7:59am UTC](https://forum.servoy.com/t/error-executing-sql-insert-into-client-stats/20981/2 "2023-04-07T07:59:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dfernandez](https://avatars.discourse-cdn.com/v4/letter/d/da6949/32.png) [@dfernandez](https://forum.servoy.com/u/dfernandez)\
**Post date:** [April 10, 2023, 7:29pm UTC](https://forum.servoy.com/t/error-executing-sql-insert-into-client-stats/20981/3 "2023-04-10T19:29:42Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [April 14, 2023, 6:45am UTC](https://forum.servoy.com/t/error-executing-sql-insert-into-client-stats/20981/4 "2023-04-14T06:45:22Z")

</div>

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

Rob

---

<div class="post-metadata">

**Author:** ![dfernandez](https://avatars.discourse-cdn.com/v4/letter/d/da6949/32.png) [@dfernandez](https://forum.servoy.com/u/dfernandez)\
**Post date:** [April 14, 2023, 7:26pm UTC](https://forum.servoy.com/t/error-executing-sql-insert-into-client-stats/20981/5 "2023-04-14T19:26:55Z")

</div>

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