Error: Send TOC PMC Command Faied
I was testing locally on branch toc-collection-support and I updated the cron job so it would generate the TOCs for all books which had book components with status published but the following error occurred:
| 2022-02-07T15:41:57.385Z - info: kafka Subscribe topic submit_package_receipt
server_1 | 2022-02-07T15:42:00.002Z - info: Start sending Toc xml to be previewed
server_1 | 2022-02-07T15:42:00.002Z - info: Start execution of Send Toc PMC Command - sendTocPMC
db_1 | 2022-02-07 15:42:05.396 UTC [34] ERROR: column "component_type" does not exist at character 35
db_1 | 2022-02-07 15:42:05.396 UTC [34] STATEMENT: select "tocs".* from "tocs" where "component_type" = $1
server_1 | 2022-02-07T15:42:05.401Z - error:
server_1 | {
server_1 | message: 'select "tocs".* from "tocs" where "component_type" = $1 - column "component_type" does not exist',
server_1 | stack: 'DBError: select "tocs".* from "tocs" where "component_type" = $1 - column "component_type" does not exist\n' +
server_1 | ' at wrapError (/home/node/app/node_modules/db-errors/lib/dbErrors.js:19:14)\n' +
server_1 | ' at handleExecuteError (/home/node/app/node_modules/objection/lib/queryBuilder/QueryBuilder.js:1489:32)\n' +
server_1 | ' at QueryBuilder.execute (/home/node/app/node_modules/objection/lib/queryBuilder/QueryBuilder.js:670:20)\n' +
server_1 | ' at processTicksAndRejections (node:internal/process/task_queues:96:5)\n' +
server_1 | ' at async SendTocPmcCommand.run (/home/node/app/server/services/CommandService/domainCommands/commands/sendTocPMC.js:24:19)\n' +
server_1 | ' at async Domain.executeCommand (/home/node/app/server/services/CommandService/baseCommand.js:27:20)\n' +
server_1 | ' at async Task.execution (/home/node/app/server/services/scheduledTaskService/index.js:27:9)',
server_1 | name: 'DBError',
server_1 | nativeError: {
server_1 | length: 114,
server_1 | name: 'error',
server_1 | severity: 'ERROR',
server_1 | code: '42703',
server_1 | detail: undefined,
server_1 | hint: undefined,
server_1 | position: '35',
server_1 | internalPosition: undefined,
server_1 | internalQuery: undefined,
server_1 | where: undefined,
server_1 | schema: undefined,
server_1 | table: undefined,
server_1 | column: undefined,
server_1 | dataType: undefined,
server_1 | constraint: undefined,
server_1 | file: 'parse_relation.c',
server_1 | line: '3349',
server_1 | routine: 'errorMissingColumn',
server_1 | originalStack: 'error: select "tocs".* from "tocs" where "component_type" = $1 - column "component_type" does not exist\n' +
server_1 | ' at Parser.parseErrorMessage (/home/node/app/node_modules/pg-protocol/dist/parser.js:287:98)\n' +
server_1 | ' at Parser.handlePacket (/home/node/app/node_modules/pg-protocol/dist/parser.js:126:29)\n' +
server_1 | ' at Parser.parse (/home/node/app/node_modules/pg-protocol/dist/parser.js:39:38)\n' +
server_1 | ' at Socket.<anonymous> (/home/node/app/node_modules/pg-protocol/dist/index.js:11:42)\n' +
server_1 | ' at Socket.emit (node:events:390:28)\n' +
server_1 | ' at addChunk (node:internal/streams/readable:315:12)\n' +
server_1 | ' at readableAddChunk (node:internal/streams/readable:289:9)\n' +
server_1 | ' at Socket.Readable.push (node:internal/streams/readable:228:10)\n' +
server_1 | ' at TCP.onStreamRead (node:internal/stream_base_commons:199:23)'
server_1 | },
server_1 | client: 'postgres'
server_1 | }
server_1 | Error: Running command: Send Toc PMC Command Failed
server_1 | at Domain.executeCommand (/home/node/app/server/services/CommandService/baseCommand.js:30:15)
server_1 | at processTicksAndRejections (node:internal/process/task_queues:96:5)
server_1 | at async Task.execution (/home/node/app/server/services/scheduledTaskService/index.js:27:9)