Record "new" has no field "loanspolicy_fixedduedatescheduleid"
Description
CSP Request Details
CSP Rejection Details
Potential Workaround
Attachments
- 28 Jul 2020, 12:55 PM
- 28 Jul 2020, 12:19 PM
blocks
duplicates
is blocked by
Checklist
hideTestRail: Results
Activity
Marc Johnson April 1, 2021 at 12:32 PM
@Julian Ladisch @Jakub Skoczen
This is marked as a duplicate. Why is it in the `Awaiting deployment` status?
Stanislav Miroshnichenko July 28, 2020 at 12:55 PM
Here is DB tables:
Marc Johnson July 28, 2020 at 12:22 PM
@Bohdan Suprun
Thank you for your investigation. I believe this may be a duplicate of the issue found on the BugFest environment described in https://folio-org.atlassian.net/browse/CIRCSTORE-224#icft=CIRCSTORE-224 and that only manifests itself during upgrades.
I believe you are right, that it is an underlying issue within RAML Module Builder that I believe @Julian Ladisch is investigating.
Bohdan Suprun July 28, 2020 at 12:20 PMEdited
Hi @Marc Johnson, @Cate Boerema,
I recall we had something similar on either snapshot or bugfest with this Record "new" has no field "loanspolicy_fixedduedatescheduleid" error.
It seems to me an RMB issue. The column for foreign key is not created however there is the update_references DB trigger that do expect these columns.
CC: @Julian Ladisch, @Adam Dickmeiss, @Jakub Skoczen.
Marc Johnson July 28, 2020 at 12:14 PM
@Julian Ladisch Is this a duplicate of https://folio-org.atlassian.net/browse/CIRCSTORE-224#icft=CIRCSTORE-224?
Details
Details
Assignee
Reporter
Labels
Priority
P2
Overview:
This bug happens when registering tenant for 'mod-circulation-storage-12.1.0-SNAPSHOT.251'
Steps to Reproduce:
In Scratch Env. setup 'mod-circulation-storage-12.1.0-SNAPSHOT.251' and try 'docker run --rm --name folio-okapi-registration1 -e TENANT_ID=diku -e OKAPI_URL=https://<project name>-okapi.ci.folio.org -e MODULE_NAME=mod-circulation-storage docker.dev.folio.org/folio-okapi-registration'
Expected Results:
Normal tenant registration
Actual Results:
Error log:
28 Jul 2020 11:55:23:742 ERROR TenantLoading [] PUT http://mod-circulation-storage/loan-policy-storage/loan-policies/43198de5-f56a-4a53-a0bd-5a324418967a returned status 400: { "cause" : null, "stackTrace" : [ { "methodName" : "toException", "fileName" : "ErrorResponse.java", "lineNumber" : 29, "className" : "io.vertx.pgclient.impl.codec.ErrorResponse", "nativeMethod" : false }, { "methodName" : "handleErrorResponse", "fileName" : "QueryCommandBaseCodec.java", "lineNumber" : 57, "className" : "io.vertx.pgclient.impl.codec.QueryCommandBaseCodec", "nativeMethod" : false }, { "methodName" : "handleErrorResponse", "fileName" : "ExtendedQueryCommandBaseCodec.java", "lineNumber" : 70, "className" : "io.vertx.pgclient.impl.codec.ExtendedQueryCommandBaseCodec", "nativeMethod" : false }, { "methodName" : "decodeError", "fileName" : "PgDecoder.java", "lineNumber" : 233, "className" : "io.vertx.pgclient.impl.codec.PgDecoder", "nativeMethod" : false }, { "methodName" : "decodeMessage", "fileName" : "PgDecoder.java", "lineNumber" : 122, "className" : "io.vertx.pgclient.impl.codec.PgDecoder", "nativeMethod" : false }, { "methodName" : "channelRead", "fileName" : "PgDecoder.java", "lineNumber" : 102, "className" : "io.vertx.pgclient.impl.codec.PgDecoder", "nativeMethod" : false }, { "methodName" : "channelRead", "fileName" : "CombinedChannelDuplexHandler.java", "lineNumber" : 251, "className" : "io.netty.channel.CombinedChannelDuplexHandler", "nativeMethod" : false }, { "methodName" : "invokeChannelRead", "fileName" : "AbstractChannelHandlerContext.java", "lineNumber" : 379, "className" : "io.netty.channel.AbstractChannelHandlerContext", "nativeMethod" : false }, { "methodName" : "invokeChannelRead", "fileName" : "AbstractChannelHandlerContext.java", "lineNumber" : 365, "className" : "io.netty.channel.AbstractChannelHandlerContext", "nativeMethod" : false }, { "methodName" : "fireChannelRead", "fileName" : "AbstractChannelHandlerContext.java", "lineNumber" : 357, "className" : "io.netty.channel.AbstractChannelHandlerContext", "nativeMethod" : false }, { "methodName" : "channelRead", "fileName" : "DefaultChannelPipeline.java", "lineNumber" : 1410, "className" : "io.netty.channel.DefaultChannelPipeline$HeadContext", "nativeMethod" : false }, { "methodName" : "invokeChannelRead", "fileName" : "AbstractChannelHandlerContext.java", "lineNumber" : 379, "className" : "io.netty.channel.AbstractChannelHandlerContext", "nativeMethod" : false }, { "methodName" : "invokeChannelRead", "fileName" : "AbstractChannelHandlerContext.java", "lineNumber" : 365, "className" : "io.netty.channel.AbstractChannelHandlerContext", "nativeMethod" : false }, { "methodName" : "fireChannelRead", "fileName" : "DefaultChannelPipeline.java", "lineNumber" : 919, "className" : "io.netty.channel.DefaultChannelPipeline", "nativeMethod" : false }, { "methodName" : "read", "fileName" : "AbstractNioByteChannel.java", "lineNumber" : 163, "className" : "io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe", "nativeMethod" : false }, { "methodName" : "processSelectedKey", "fileName" : "NioEventLoop.java", "lineNumber" : 714, "className" : "io.netty.channel.nio.NioEventLoop", "nativeMethod" : false }, { "methodName" : "processSelectedKeysOptimized", "fileName" : "NioEventLoop.java", "lineNumber" : 650, "className" : "io.netty.channel.nio.NioEventLoop", "nativeMethod" : false }, { "methodName" : "processSelectedKeys", "fileName" : "NioEventLoop.java", "lineNumber" : 576, "className" : "io.netty.channel.nio.NioEventLoop", "nativeMethod" : false }, { "methodName" : "run", "fileName" : "NioEventLoop.java", "lineNumber" : 493, "className" : "io.netty.channel.nio.NioEventLoop", "nativeMethod" : false }, { "methodName" : "run", "fileName" : "SingleThreadEventExecutor.java", "lineNumber" : 989, "className" : "io.netty.util.concurrent.SingleThreadEventExecutor$4", "nativeMethod" : false }, { "methodName" : "run", "fileName" : "ThreadExecutorMap.java", "lineNumber" : 74, "className" : "io.netty.util.internal.ThreadExecutorMap$2", "nativeMethod" : false }, { "methodName" : "run", "fileName" : "FastThreadLocalRunnable.java", "lineNumber" : 30, "className" : "io.netty.util.concurrent.FastThreadLocalRunnable", "nativeMethod" : false }, { "methodName" : "run", "fileName" : "Thread.java", "lineNumber" : 748, "className" : "java.lang.Thread", "nativeMethod" : false } ], "severity" : "ERROR", "code" : "42703", "detail" : null, "message" : "record \"new\" has no field \"loanspolicy_fixedduedatescheduleid\"", "localizedMessage" : "record \"new\" has no field \"loanspolicy_fixedduedatescheduleid\"", "suppressed" : [ ] } POST http://mod-circulation-storage/loan-policy-storage/loan-policies returned status 500: record "new" has no field "loanspolicy_fixedduedatescheduleid"