Skip to Content.
Sympa Menu

grouper-users - [grouper-users] column "value_integer" is of type bigint but expression is of type character varying

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] column "value_integer" is of type bigint but expression is of type character varying


Chronological Thread 
  • From: John Schrader <>
  • To:
  • Subject: [grouper-users] column "value_integer" is of type bigint but expression is of type character varying
  • Date: Sat, 7 Apr 2018 11:38:09 -0400
  • Ironport-phdr: 9a23:XxINqxaR5biY5VMZrHqILU7/LSx+4OfEezUN459isYplN5qZr8SybnLW6fgltlLVR4KTs6sC17KN9fi4EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQpFiCazbL9oMBm6sRjau9ULj4dlNqs/0AbCrGFSe+RRy2NoJFaTkAj568yt4pNt8Dletuw4+cJYXqr0Y6o3TbpDDDQ7KG81/9HktQPCTQSU+HQRVHgdnwdSDAjE6BH6WYrxsjf/u+Fg1iSWIdH6QLYpUjmk8qxlSgLniD0fOjA5/m/ZidF+grxHrx+6vRNz35TZbZuJOPZifK7Qe84RS2pbXsZWUixMGoeyb4wPD+oHIO1WspXyp1sUrRSkGAajGvnvwSJPi3Hy2q060+IhHRvb0gM8H9IOqm7bo8jrO6cISu21yrTHwS/dYPxLxDfw8Y7FeQ0vr/GLWLJ/a8vRyU83GgPKlFWQrpHlPyuL2eQXqWSU9fJgVfq3h247qwFxuCagyd0xhYXTnIIV11bE+T12wIYvIt24VVZ7bsC+EJRMrS6aM492Tdk5TGFspik20KEJtoS/fCgO0JgnyQPfa+Cac4iS/B3jSPyeISx7hH5/YrK/mhCy/E69weP/Tsm5yEhGoytZntTOs30N2R/e5dObRvZ48UqtxSqD2x3W5+5YPUw5lK/WJps/zrM/mZcet1nIEDXsl0XslqCWc10p+ui25OTjZbXrvpqcOJV1igH6K6gum8u/DfghPgkBQWSW9uux2Kfs/U3+R7VKgfk2nbfDvJ/GIsQbo7a1Aw5T0ok99xayFymq3dUEkXQFKV9FdhGKgJP1N1zLL/30Eeuzj0mpnTh32/zLP7jsD5DTInXMn7rtZbN95FRdyAo3w9Bf/ZVUCrQZLfLxQU/+qNzYDgUjPAOpzOvqE9N92Z4EVW2RH6CZLbvesUWU6eI3P+mMeIgVtS7yK/g/4P7ukGc5lkEHfaWwwJsXc263Hu59I0iCZXrsg8wBEXsRvgYgVuDqiVuCUSJNaHaoWaIz+C07BJy8AYjdW4+tne/J4CDuEYdRe3hLEBWRCnrybK2FXesBciSfPpUnnzAZBpa7TIp09xauskfBwLp9J+bZ4GVMl5Xj0p5O7O3JnB0/7xRyA4KQ33zbHDI8pX8BWzJjhPM3mkd60FrWiaU=

After patching a test install of Grouper I am seeing the following WARN events in the daemon logs.

Thoughts ?

Thanks!

-John

Daemon:
api patches installed:        0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99

Daemon log:

2018-04-06 12:16:29,481: [pool-1-thread-5] WARN  GrouperLoaderType.updateLoaderMetadataAttributes(3189) -  - Non-fatal error updating metadata on group: nd:ref:eds:nd-all-active-enterprise-accounts-gs_systemOfRecord
java.lang.RuntimeException: Problem with query in bysqlstatic: UPDATE grouper_attribute_assign_value SET hibernate_version_number = ?, context_id = ?, last_updated = ?, value_integer = ?, value_floating = ?, value_string = ?, value_member_id = ? WHERE id = ?,
Problem in HibernateSession: HibernateSession (3c17a40f): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (4be42902),
Problem in HibernateSession: HibernateSession (1f71a109): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (791e5c12)
        at edu.internet2.middleware.grouper.hibernate.BySql.executeSql(BySql.java:151)
        at edu.internet2.middleware.grouper.attr.value.AttributeAssignValue$1$1.callback(AttributeAssignValue.java:521)
        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:701)
        at edu.internet2.middleware.grouper.attr.value.AttributeAssignValue$1.callback(AttributeAssignValue.java:511)
        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:701)
        at edu.internet2.middleware.grouper.attr.value.AttributeAssignValue.saveOrUpdate(AttributeAssignValue.java:472)
        at edu.internet2.middleware.grouper.attr.value.AttributeAssignValueDelegate.internal_assignValue(AttributeAssignValueDelegate.java:260)
        at edu.internet2.middleware.grouper.attr.value.AttributeAssignValueDelegate.assignValue(AttributeAssignValueDelegate.java:217)
        at edu.internet2.middleware.grouper.attr.value.AttributeAssignValueDelegate.assignValue(AttributeAssignValueDelegate.java:324)
        at edu.internet2.middleware.grouper.attr.value.AttributeValueDelegate.assignValue(AttributeValueDelegate.java:74)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.updateLoaderMetadataAttributes(GrouperLoaderType.java:3171)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.access$500(GrouperLoaderType.java:119)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$14.callLogic(GrouperLoaderType.java:3125)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$14.callLogic(GrouperLoaderType.java:3119)
        at edu.internet2.middleware.grouper.util.GrouperCallable$1.callback(GrouperCallable.java:191)
        at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)
        at edu.internet2.middleware.grouper.util.GrouperCallable.callLogicWithSessionIfExists(GrouperCallable.java:188)
        at edu.internet2.middleware.grouper.util.GrouperCallable.call(GrouperCallable.java:154)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: column "value_integer" is of type bigint but _expression_ is of type character varying
  Hint: You will need to rewrite or cast the _expression_.
  Position: 126
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:384)
        at edu.internet2.middleware.grouper.hibernate.BySql.executeSql(BySql.java:146)
        ... 21 more


Thanks!
--
John Schrader
Identity and Access Management
Office of Information Technologies
University of Notre Dame

EVERYTHING SHOULD BE MADE AS SIMPLE AS POSSIBLE, BUT NOT ANY SIMPLER
—ALBERT EINSTEIN



Archive powered by MHonArc 2.6.19.

Top of Page