column AD_AuthorizationAccount.AccessToken is short on some case
Description
Environment
discovered while testing
Activity
Carlos Ruiz March 14, 2022 at 4:39 PM
Hi , you're right.
I repeated the test with your scenario and the issue is reproducible.
So, yes, please add those two instructions to the migration script.
Regards,
Carlos Ruiz
Nicolas Micoud March 14, 2022 at 4:16 PM
There’s nothing specific in this table.
The only cause thing I see is that there was records on the table before migration.
And the migration “breaks” the index.
But I haven’t analysed it further as the REBUILD instruction resolved the issue.
Carlos Ruiz March 14, 2022 at 4:09 PM
Well, I just tested importing a 2pack with authorization accounts and it doesn’t happen in my oracle.
Can it be that is something specific on your instance?
Nicolas Micoud March 14, 2022 at 3:12 PM
Hi,
On a v9 instance, I added credential and accounts for OAuth () and get ORA-01502: index or partition of such index is in usable state for 2 indexes:
AD_AUTHORIZATIONACCOUNT_KEY
AD_AUTHORIZATIONACCOUNT_UU_IDX
Solved using:
ALTER INDEX AD_AUTHORIZATIONACCOUNT_KEY REBUILD;
ALTER INDEX AD_AUTHORIZATIONACCOUNT_UU_IDX REBUILD;
, I don’t know if that should be included in migration scripts. If yes, tell me, I’ll create the PR
Regards,
Nicolas
Nicolas Micoud March 2, 2022 at 7:26 AM
Hi,
While testing migration from 8.2 to 9, I got an error with this ticket as my table had data (ORA-01439 column to be modified must be empty).
Details
Assignee
Carlos RuizCarlos RuizReporter
Hiep LqHiep LqLabels
Affects versions
Priority
Major
Details
Details
Assignee
Carlos RuizReporter
Hiep LqLabels
Affects versions
Priority
Major
i use a outlook (enterprise) account to test OAuth2
when run "Add Authorization Mail Account" process it can add a account email but also has error
accessToken = SecureEngine.encrypt(accessToken, getAD_Client_ID());
make string with length > 4000 character
so this field should switch to text