Uploaded image for project: 'mod-source-record-manager'
  1. mod-source-record-manager
  2. MODSOURMAN-419

SQL Exception WRT count function

    XMLWordPrintable

Details

    • Folijet Sprint 111, Folijet Sprint 112
    • 1
    • Folijet
    • R1 2021 Bug Fix

    Description

      When importing a record . The change manager returns 200/201 all along.. But under the hood something is terribly wrong. 

      ERROR PostgresClient       [618919eqId] query with count: { "message": "syntax error at end of input", "severity": "ERROR", "code": "42601", "internalPosition": "109", "internalQuery": "EXPLAIN SELECT jsonb FROM diku_mod_source_record_manager.job_execution_source_chunks WHERE (jsonb->>'id') = ", "where": "PL/pgSQL function count_estimate_smart2(bigint,bigint,text) line 7 at FOR over EXECUTE statement\nPL/pgSQL function count_estimate(text) line 7 at assignment", "file": "scan.l", "line": "1115", "routine": "scanner_yyerror" } - SELECT diku_mod_source_record_manager.count_estimate('SELECT jsonb FROM diku_mod_source_record_manager.job_execution_source_chunks WHERE (jsonb->>''id'') = ')

      mod-source-record-manager-2.5.0-SNAPSHOT.362

      See attached full log.

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Task - A task that needs to be done. MODSOURMAN-427 Release v3.0.3

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            defines

            New Feature - New feature requests UXPROD-2681 Folijet support work for Single record OCLC import

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. MODDATAIMP-370 OCLC single record import: Updates don't work, and the Create action uses the wrong job profile

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Task - A task that needs to be done. MODSOURMAN-400 Ensure exactly once processing for data-import-SRM interaction via Kafka

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODCPCT-19 Neither import, nor update works

            • TBD - To be determined
            • Closed

            Task - A task that needs to be done. MODCPCT-21 Provide unique ID in RawRecordsDto

            • TBD - To be determined
            • Closed

            Task - A task that needs to be done. MODDATAIMP-394 Triage Honeysuckle bugs

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Activity

              People

                VRohach Volodymyr Rohach
                adam Adam Dickmeiss (Inactive)
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases