an Identifier exceeds 36 characters

General discussion forum about all databases other than SqlBase.
gigit
Italy
Posts: 170
Joined: 14 Jun 2017, 15:04
Location: Italy

an Identifier exceeds 36 characters

Post by gigit » 24 Jan 2023, 18:06

hi to all.
I am facing this problem. This is the insert statement. The error seems to be with the column "ST4_1_ErroreDatamatrixInleggibile" that is 33 characters long . I am importing records from an automatic testing device and columns are named that way. Really the name of a column must be shorter than 33 characters? The database is SqlServer and doing that insert with Management Studio or other software, all is ok. With TD or SqlTalk not. Really? 32 characters?
Any solution? Thank you.

Code: Select all

Error: 00910 PRS ITL Identifier too long

      Reason: An identifier exceeds 36 characters.

      Remedy: Correct the identifier that exceeds 36 characters.

insert into aaa (c_stabilimento, Id,DataOraInizioBindello,Bindello,CodiceRosa,NomeArticolo,DatamatrixPezzo,DataOraLavorazionePezzo,EsclusioneDataMatrixViaRulli2,
EsclusioneStazione0,EsclusioneStazione1_1,EsclusioneStazione2_1,EsclusioneStazione3_1,EsclusioneStazione4_1,EsclusioneConfocale4_1,EsclusioneTelecamera4_1
,EsclusioneDatamatrix4_1,EsclusioneStazione5_1,EsclusioneStazione6_1,EsclusioneStazioneATEQ,ST4_1_SetIntensita,ST4_1_SetTolleranzaIntensita,
ST4_1_MemoIntensita,ST4_1_SelezioneTest1_2,ST4_1_SelezioneTest2_3,ST4_1_SelezioneTest1_3,ST4_1_Set_Layer1,ST4_1_Set_Layer2,ST4_1_Set_Layer3,
ST4_1_SetDelta1_2,ST4_1_SetDelta2_3,ST4_1_SetDelta1_3,ST4_1_SetTolleranza_Misura,ST4_1_Memo_Delta1_2,ST4_1_Memo_Delta2_3,ST4_1_Memo_Delta1_3,
ST4_1_SetTolleranza1_2Positiva,ST4_1_SetTolleranza1_2Negativa,ST4_1_SetTolleranza2_3Positiva,ST4_1_SetTolleranza2_3Negativa,
ST4_1_SetTolleranza1_3Positiva,ST4_1_SetTolleranza1_3Negativa,ST6_1_SetRotazione,ST6_1_SetTempoTotale,ST6_1_SetImpulsiR80,ST6_1_SetImpulsiR100,
ST6_1_SetImpulsiR160,EsitoGlobale,ST0_Scarto,ST0_ErroreChiusura,ST0_ErroreCoordinate,ST3_1_Scarto,ST4_1_Scarto,ST4_1_ErroreDatamatrixDoppio,
[b]ST4_1_ErroreDatamatrixInleggibile[/b], ST4_1_ErroreMagnete_TLC,ST4_1_ErroreAltezzaHotFoil,ST4_1_ErroreAssenzaHotFoil,ST5_1_Scarto,
ST5_1_ErroreAllineamentoLancetta,ST5_1_ErroreIngranaggi,ST5_1_ErroreColore,ST5_1_ErroreDiametroPignoni,ST5_1_ErroreHotFoilIncompleto,
ST5_1_ErroreAssenzaHotFoil,ST6_1_Scarto,ST6_1_EsitoR80,ST6_1_EsitoR100,ST6_1_EsitoR160,ST3_2_MemoPerdita,ST3_2_MemoPressione,ST3_2_Scarto,
ST3_2_SetProgrammaATEQ,EsclusioneDatamatrix6_1,EsclusioneSerialNumber6_1,SerialNumberPezzo) 
values 
('PRC','971214', '2022-11-30 18:17:34.3625650 +01:00', '', '', '1901', '1901000000021580', '2022-11-30 18:17:34.3625650 +01:00', '0', '0', '0', '0', '1', '1', '1', '1', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0,8954986', '0,5751812', '1,478508', '0', '0', '0', '0', '0', '0', '300', '4000', '73', '73', '73', '1', '0', '0', '0', '0', '0', '0', '0',  '0', '0', '0', '0','0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-13', '90,7', '0', '1', '0', '0', '29A89D041600140000000000'
);

Giorgio Bravi
Italy
Posts: 111
Joined: 09 Mar 2017, 18:08
Location: Bergamo, Italy

Re: an Identifier exceeds 36 characters

Post by Giorgio Bravi » 25 Jan 2023, 11:43

I had a similar problem a while ago with version 5.2, it seems that with 7.x it has been fixed but I haven't had the chance to verify it anymore.
In my case I solved by renaming the columns but it was my db and it didn't cause me any particular problems.
Giorgio Bravi
BLUENEXT SRL
www.bluenext.it
www.dolphin.it

gigit
Italy
Posts: 170
Joined: 14 Jun 2017, 15:04
Location: Italy

Re: an Identifier exceeds 36 characters

Post by gigit » 01 Feb 2023, 10:53

Ok, grazie Giorgio

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 3 guests