Report query issue after upgrade of ALM to 12.20
| ♥ 0 |
We recently upgrade our ALM to 12.20 in test. We had some report queries from our older ALM that after the upgrade throw an instant error and the queries do not even try to run. The error is is : *Quality Center cannot run the query because it contains invalid statements* I have checked the code; there is nothing wrong with syntax or the like. The code also runs fine against the database directly.
Marked as spam
|
Posted by |
Private answer
Hello, Please check that your query does not contain any black listed words that could be getting removed by the validation_black_list site configuration parameter. That error could and likely does indicate that. And as you just upgraded, the site parameters are likely on and with the default values in use. From the guide: By default, to ensure that your queries are valid and do not alter the project database, ALM checks that the following conditions are fulfilled: * *The query starts with the command SELECT*. * *The query contains only one SQL statement.* * *****The query does not contain any of the following commands (except in comments): INSERT, DELETE, UPDATE, DROP,CREATE, COMMIT, ROLLBACK, ALTER, EXEC, EXECUTE, MERGE, GRANT, REVOKE, SET, INTO, or TRUNCATE.***** Marked as spam
 Posted by mrwhite (Questions: 1, Answers: 116) Answered on January 27, 2016 4:48 pm
|