Skip to content

bug: querying data through SQL doesn't work #172

Description

@honzakostejn

Problem

When querying data from tables, the call fails with duplicate header error. I suspect the issue is in tables where there is 5k+ records. Wasn't investigating properly.

Repro

dnx TALXIS.CLI -- environment data query sql "SELECT TOP 5 talxis_addressid FROM talxis_address" -p devbox-kos-pct24002-01
14:18:17+02:00 [INFO]  Resolved target environment 'https://devbox-kos-pct24002-01.crm4.dynamics.com' using profile 'devbox-kos-pct24002-01', connection 'devbox-kos-pct24002-01', credential 'jan.kostejn@thenetw.org' (source: CommandLine).
14:18:17+02:00 [INFO]  Resolved target environment 'https://devbox-kos-pct24002-01.crm4.dynamics.com' using profile 'devbox-kos-pct24002-01', connection 'devbox-kos-pct24002-01', credential 'jan.kostejn@thenetw.org' (source: CommandLine).
14:18:17+02:00 [INFO]  Resolved target environment 'https://devbox-kos-pct24002-01.crm4.dynamics.com' using profile 'devbox-kos-pct24002-01', connection 'devbox-kos-pct24002-01', credential 'jan.kostejn@thenetw.org' (source: CommandLine).
An item with the same key has already been added. Key: Cookie
14:18:19+02:00 [ERROR] Command failed: An item with the same key has already been added. Key: Cookie
14:18:19+02:00 [INFO]  If this is unexpected, report at https://github.com/TALXIS/tools-cli/issues
  Session: e77ec090-b8b5-40b4-a072-05f67ed4067c
  Operation: 40288463d8c5858e3ee44d13f0e512ba
  Logs: /tmp/nix-shell.xBpvLb/txc/logs/session-e77ec090-b8b5-40b4-a072-05f67ed4067c.jsonl

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions