SQL Error updating Orchestrator to 2023.4

Help Orchestrator
1

Hello,

I am migrating an on-premis Orchestrator instance from 2020.4 to 2023.4. The migration fails with the following SQL error

System.Exception: Migration failed: Incorrect syntax near the keyword ‘FROM’.
Incorrect syntax near ‘CATEGORY_ANCESTORS’.
Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword ‘FROM’.
Incorrect syntax near ‘CATEGORY_ANCESTORS’.

What could cause that ?

Thank you

2

@prepetti

Looks like your syntax is wrong…print your swl statement and check what error it is

Cheers

3

Hi,

I don’t think it’s “my” syntax, that SQL is executed by UiPath while migrating the db.
Do you mean that SQL can be found somewhere ? Where ?

Thank you

4

Hi @prepetti

Hope it helps!!