The Heap™ – Consultancy ©®

« first day (3508 days earlier) ← previous day next day → last day (1353 days later) »

John aka hot2use

6:11 AM

Morning

added my 2 centimes to the question

7 hours later…

Tom V

12:51 PM

is there any way to find the sql text for a failed query in azure sql?

the application generates a query and sends it to azure, resulting in "incorrect syntax near )" but I can't see the query

on prem I would profile or XE to get the sql_text somewhere but how can I do that on Azure

Tom V

1:04 PM

oh XE is available, it's just in another location in the UI

I'm such a noob

billinkc

SHAME!

Lamak

@TomV yeah, the UI it's complicated

Tom V

I don't use XE nearly enough to remember the t-sql syntax for it

jcolebrand

1:52 PM

@LowlyDBA it looks like there's still some conversational value here yeah?

A: string or binary data would be truncated in table '******', column '******'. Truncated value: '******'

I have experienced the same thing on System-versioned tables (Temporal Table). Do you use Temporal Tables? If you do, maybe it's related to that?

LowlyDBA

2:30 PM

Perhaps magical mod powers could turn that into comments.

Tom V

2:54 PM

It's an answer in my opinion

Sure it can be refined but "I've seen it with temporal tables, can't explain why but maybe your problem is related as well" is more an answer than a comment if you ask me

mustaccio

3:18 PM

I don't think it's an answer. The answer would be "It is a bug in how Azure SQL handles temporal tables. The workaround is ..../there is no workaround at this time but developers are looking into it". As is, it's definitely a comment.

3 hours later…

LowlyDBA

6:06 PM

Welp, he edited to improve the answer, so I guess it is a win/win. Removed my comment after it has already attracted tsk tsks about using the flagging feature on an innocent newbie.

5 hours later…

jcolebrand

11:00 PM

@LowlyDBA oh, I wasn't trying to railroad you sir. I was gonna come back to it for edits and I got ambushed with crap before I could get back to it

I'm literally just now getting back to look at this

DRP

Hi Team I seem to be failing in something simple and would really appreciate your input on this .Database is not flawless in design, it actually has plenty of design errors, however this error I'm failing to understand exactly why. Issue is with specific insert command, it's not even allowing the simplest of it.

MariaDB [hospitalv1]> INSERT INTO `hospitalv1`.`Ficha_Medica_Paciente` (`idFicha_Medica_Paciente`, `Valoracion_Servicio`, `Tipo_Enfermedad_idTipo_Enfermedad`, `Ficha_Visita_idFicha_Visita`, `Ficha_Visita_Medicamento_idMedicamento`, `Tipo_Cirugia_idTipo_Cirugia`, `Registro_Servici…

From the diagram it would be the insert on the top table named "Ficha_Medica_Paciente" , so of course there are many design issues which I totally get, but why then a simple insert is failing?

Research: I think I understand the error that it mentions about the constraint, but how could It be failing the constraint if: a) there is data, and b) I'm respecting normalization rules.

Yes I know this may seem a lame issue and not to mention the crappy hospital table designs... right now I'm just trying to get this insert to work.