Error "User defined SQL is not permitted" after importing report from Cognos 10

[ale137]

Hello, im having an issue with reports that i am importing to Cognos 11.0.13 from Cognos 10.2
When i migrate the reports using the method Copy report to clipboard/Open report from clipboard i get the following error when i try to execute it:
"RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0148 User defined SQL is not permitted. "


The reports arent using a model/package to feed the table but a single SQL query.
I gave my admin account the full access to the capability "User Defined SQL" from Report Studio but the error is the same.

Is there another way to solve this issue?

[Hardik Binnani]

Hi,

Is your report missing to point to any package?

[ale137]

Hello

I replaced the reference to a package to a new model that had all the tables that where being queried.

The missing package error tends to happen before the User defined SQL is not permitted.