problemi dopo migrazione da sql server2008 a sql server2014

Question

problemi dopo migrazione da sql server2008 a sql server2014

dani0209

Grasshopper

Points: 13
More actions
November 25, 2014 at 5:36 am

#292394

Ciao a tutti!
Volevo mettervi a conoscenza di un problema che ho avuto dopo la migrazione!
Avevo una select che nella versione precedente funzionava perfettamente!
Dopo il cambio, mi dava, random, un errore stranissimo:ermm::
Microsoft][ODBC SQL Server Driver][SQL Server]Conversione non riuscita durante la conversione del valore varchar 'NAVICELLA DI LUSSO ' nel tipo di dati int
Dal momento che i campi non sono stati cambiati e che questo errore sbucava ogni tanto pur essendo lanciato sugli stessi record:crying:, e non sapendo più cosa cercare, ho lanciato da Microsoft Sql Server Management Studio, la "VISUALIZZAZIONE PIANO DI ESECUZIONE STIMATO" sulla select incriminata! La pianificazione mi ha detto che sarebbe stato utile creare un indice su una tabella:w00t:!
Bene! Creato l'indice ..... sparito l'errore:-P! Ho fatto 3 volte la controprova creando o cancellando l'indice suggeritomi dal PIANO DI ESECUZIONE! Se c'era l'indice TUTTO OK! Appena lo droppavo.... errore Microsoft][ODBC SQL Server Driver][SQL Server]Conversione non riuscita durante la conversione del valore varchar 'NAVICELLA DI LUSSO ' nel tipo di dati int.
Indi per cui ....... se è un errore stranissimo ..... provate anche questa strada:-P!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246695 More actions · Answer 1

English translation, anyone? 🙂

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Lowell SSC Guru Points: 323504 More actions · Answer 2

best i can do ?

translate.google.com

Hello everyone!
I wanted to let you know of a problem I had after migration!
I had a select that in the previous version worked perfectly!
After the change, it gave me, random, an error stranissimoErmm:
Microsoft] [ODBC SQL Server Driver] [SQL Server] Conversion failed when converting the varchar value 'NAVICELLA LUXURY' to data type int
Since the fields have not been changed and that this error popping out occasionally while being launched on the same recordCrying, and not knowing what to look for, I launched by Microsoft SQL Server Management Studio, the "DISPLAY PLAN FOR COMPLETION ESTIMATED" on select offending ! Planning told me that it would be useful to create an index on a tabellaw00t!
Well! Created the index ..... disappeared the erroreTongue! I did three times the rebuttal by creating or erasing the index suggeritomi from PLAN PERFORMANCE! If there was the index EVERYTHING OK! As soon as the error droppavo .... Microsoft] [ODBC SQL Server Driver] [SQL Server] Conversion failed when converting the varchar value 'NAVICELLA LUXURY' to data type int.
Then why ....... if an error is strange ..... try this too stradaTongue!

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Phil Parkin SSC Guru Points: 246695 More actions · Answer 3

I did three times the rebuttal

Sounds like a new dance move!!

Anyhow, I think we need to see the query which generated this error. I am suspecting that there's an implicit datatype conversion in there somewhere.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.