Solved

There is a syntactical error in the SQL statement. SQL statement got timed out.

  • 23 May 2024
  • 2 replies
  • 39 views

Badge

Hello!

I'm trying to perform an INSERT in the database but the following error is occurring:

There is a syntactical error in the SQL statement. SQL statement got timed out.

I did a test with the predefined data but the same message occurs, inserting the same data into the database directly works, but in Automation it is not working.

 

 

Comando SQL:

 

INSERT INTO rpa_descontinuacao_med    (assunto,     tipo_de_descontinuacao,     data_de_peticao,     data_de_reativacao,     motivo,     empresa,     produto,     principio_ativo,     clase_terapeutica,     registro,     apresentacao,     reativado)  

 

VALUES    (     'teste',     'teste',     (DATE '2024-05-24'),     (DATE '2024-05-24'),     'teste',     'teste',     'teste',     'teste',     'teste',     'teste',     'teste',     'teste')

icon

Best answer by Ganesh Bhat 23 May 2024, 20:16

View original

2 replies

Userlevel 3
Badge +7

It might be expecting a termination of the SQL command. Try adding ; (semi-colon) at the end of the string.

Userlevel 4
Badge +12

@Erick Lopes

 

Remove Extra space and Enters from the query 

try this 

INSERT INTO rpa_descontinuacao_med (assunto, tipo_de_descontinuacao, data_de_peticao, data_de_reativacao, motivo, empresa, produto, principio_ativo, clase_terapeutica, registro, apresentacao, reativado) VALUES ('teste', 'teste', (DATE '2024-05-24'), (DATE '2024-05-24'), 'teste', 'teste', 'teste', 'teste', 'teste', 'teste', 'teste', 'teste');
 

Reply