column AD_AuthorizationAccount.AccessToken is short on some case

Hi @Nicolas Micoud, 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

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.

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?

Hi,

On a v9 instance, I added credential and accounts for OAuth (https://idempiere.atlassian.net/browse/IDEMPIERE-3101) 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;

@Carlos Ruiz, I don’t know if that should be included in migration scripts. If yes, tell me, I’ll create the PR

Regards,

Nicolas

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).