search

elastic / elasticsearch-sql-odbc

ODBC driver for Elasticsearch SQL
Other
0 stars 30 forks source link

ODBC Error: Invalid character value for cast specification #327

Closed RickL18393 closed 1 week ago

RickL18393 commented 1 week ago

I am using ODBC driver version 8.15.1-windows-x86_64 connecting to an ElasticSearch server running version 8.15.1. When I attempt to query data from an ElasticSearch table I am getting this ODBC error: [Elastic][EsODBC 8.15.1(v8.15.0-1-g43209d3,u,r) Driver]Invalid character value for cast specification;

When I turn on ODBC error logging I get this message: Mon Nov 18 12:12:53 2024 - [ERROR] sql2c_string()@convert.c:3489 [STMT@0x0000017FEFACF0B0] can't convert Soham Sarkar to double.

Is there a way to determine which column the bad data is in from the ODBC error message?

Let me know if you need any more information.

Thanks, Rick L.

bpintea commented 1 week ago

You should get a message like column #<number> is bound, copying data. before the failure message, which should help you id the column. Please feel free to use https://discuss.elastic.co/ for getting help, or open issues here if you encounter defects. Thanks!

RickL18393 commented 1 week ago

Which logging level should I use? The error message I sent was the only line in the log file when I had the logging level set to Error.

Thanks, Rick L.

Get Outlook for iOShttps://aka.ms/o0ukef

From: Bogdan Pintea @.> Sent: Tuesday, November 19, 2024 10:57:12 AM To: elastic/elasticsearch-sql-odbc @.> Cc: Leasure, Rick @.>; Author @.> Subject: Re: [elastic/elasticsearch-sql-odbc] ODBC Error: Invalid character value for cast specification (Issue #327)

Caution: External email. Do not open attachments or click on links if you do not recognize the sender.

Closed #327https://urldefense.com/v3/__https://github.com/elastic/elasticsearch-sql-odbc/issues/327__;!!IqUcNYopQPk7!O20clEdM5-rfuBda2DbpMOLJ-vFzpJDkHOfzeaPK9FH7-SaMqDARIuzZSMe5OVXWtMeHUsLRF6ipJWWyQU2zy8jl9xPdZg$ as not planned.

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https://github.com/elastic/elasticsearch-sql-odbc/issues/327*event-15351772563__;Iw!!IqUcNYopQPk7!O20clEdM5-rfuBda2DbpMOLJ-vFzpJDkHOfzeaPK9FH7-SaMqDARIuzZSMe5OVXWtMeHUsLRF6ipJWWyQU2zy8i51V3YIg$, or unsubscribehttps://urldefense.com/v3/__https://github.com/notifications/unsubscribe-auth/BNCAB2C2KIUUCBVOTF34RTD2BNNVRAVCNFSM6AAAAABSCHMK2GVHI2DSMVQWIX3LMV45UABCJFZXG5LFIV3GK3TUJZXXI2LGNFRWC5DJN5XDWMJVGM2TCNZXGI2TMMY__;!!IqUcNYopQPk7!O20clEdM5-rfuBda2DbpMOLJ-vFzpJDkHOfzeaPK9FH7-SaMqDARIuzZSMe5OVXWtMeHUsLRF6ipJWWyQU2zy8hfDMs7PQ$. You are receiving this because you authored the thread.Message ID: @.***>

This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or intended recipient’s authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.

bpintea commented 1 week ago

Which logging level should I use?

Debug