Migrating Spotfire database

[Carlos Lozano]

Hello,

we recently migrated our Spotfire servers to a different environment. Im not admin so Im not sure what are the 'internals' of the migration. The thing is that any edited SQL in information links (ILs) has been lost....

We open ILs in the new environment and although the yellow message appears informing it has been edited, the query is exactly the same as the original.

IS anyone aware of this Is there any solution to keep edited SQL

 

Thanks!

PS. Edited because the problem with names of columns is solved. It was unrelated to the mirgation.

[Carlos Lozano]

I think that the answer is that since the SQL dialect is different, the edited SQL, which is stored as a string,cannot validated and Spotfire defaults to the original query...