View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0002494 | SymmetricDS | Bug | public | 2016-02-15 08:52 | 2022-09-09 21:21 |
Reporter | azarubkin | Assigned To | elong | ||
Priority | normal | ||||
Status | closed | Resolution | won't fix | ||
Product Version | 3.7.28 | ||||
Summary | 0002494: Upgrade alter table error, could not find stored procedure sp_executesql | ||||
Description | When upgrading existing 3.6 installation to 3.7, the following error is thrown and the process fails: ~~~~ 2016-02-05 10:17:53,406 INFO [main] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Checking if SymmetricDS tables need created or altered 2016-02-05 10:17:55,765 INFO [main] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] There are SymmetricDS tables that needed altered 2016-02-05 10:17:55,781 INFO [main] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] DDL applied: SET quoted_identifier on 2016-02-05 10:17:55,781 WARN [main] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] DDL failed: "guard"."symmetricds".sp_executesql N'DROP INDEX "sym_idx_reg_req_1" ON "sym_registration_request"' 2016-02-05 10:17:55,796 WARN [main] [JdbcSqlTemplate] [symmetric-engine-startup-0] Could not find stored procedure 'guard.symmetricds.sp_executesql'.. Failed to execute: "guard"."symmetricds".sp_executesql N'DROP INDEX "sym_idx_reg_req_1" ON "sym_registration_request"' ~~~~ Apparently, SymmetricDS prepends database and schema name to sp_executesql procedure call. It shouldn't do so. My DB is MS SQL 2005. | ||||
Additional Information | It can be solved by manually deleting the index. | ||||
Tags | ddl/schema, upgrade | ||||
|
We require stored procedure sp_executesql to be available. |
|
It is available as sp_executesql, but SymmetricDS searches it with wrong name, as guard.symmetricds.sp_executesql. |
|
I can't find any use of sp_executesql in the SymmetricDS code, so I think it's coming from the JDBC driver. Are you using the JTDS JDBC driver that was packaged with SymmetricDS or another driver? What is the db.url that you are using? Does it have "guard" in the db.url? |
|
db.url=jdbc:jtds:sqlserver://localhost:1433/guard I believe I use the driver packaged in SymmetricDS. |
|
This sounds like a bug in the JTDS JDBC driver. Unfortunately, the JTDS project appears stagnant for years now. We've switched to the Microsoft JDBC driver as the default for SQL-Server, since it's improved over time and is on par with JTDS now. |
Date Modified | Username | Field | Change |
---|---|---|---|
2016-02-15 08:52 | azarubkin | New Issue | |
2019-04-23 20:39 | elong | Tag Attached: Upgrade | |
2019-04-23 20:39 | elong | Tag Attached: ddl/schema | |
2019-05-13 20:29 | elong | Assigned To | => elong |
2019-05-13 20:29 | elong | Status | new => closed |
2019-05-13 20:29 | elong | Resolution | open => won't fix |
2019-05-13 20:29 | elong | Note Added: 0001476 | |
2019-05-14 05:41 | azarubkin | Status | closed => feedback |
2019-05-14 05:41 | azarubkin | Resolution | won't fix => reopened |
2019-05-14 05:41 | azarubkin | Note Added: 0001478 | |
2019-05-14 12:17 | elong | Note Added: 0001479 | |
2019-05-14 13:16 | azarubkin | Note Added: 0001481 | |
2019-05-14 13:16 | azarubkin | Status | feedback => assigned |
2019-05-17 23:55 | elong | Summary | Upgrade process error => Upgrade alter table error, could not find stored procedure sp_executesql |
2022-09-09 21:21 | elong | Note Added: 0002189 | |
2022-09-09 21:21 | elong | Status | assigned => closed |
2022-09-09 21:21 | elong | Resolution | reopened => won't fix |