Maximo Open Forum

Daniel,

Was the A_ASSET e-audit table existing or is this the first time that you are enabling e-audit on the ASSET table? If it is the first time and since you indicated this is SQL Server I would verify that SQL Server FullText Index Search is installed which is a pre-requisite. You can verify by running:

SELECT 
    CASE 
         WHEN 
             FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1 
         THEN 
              'INSTALLED' 
         ELSE 
              'NOT INSTALLED' 
    END IsFullTextInstalled

If the A_ASSET existed previously then what is the change you made i.e. new attribute, existing attribute but change the data type or the size, change the search type? Is there data in the A_ASSET table you need for historical reason as this may determine what steps you need to take to resolve this problem. I doubt the issue is user permission and the error is misleading and "full-text index" is the root cause and my previous suggestion is likely the fix which is to install Microsoft SQL Server Full-text Index Search https://learn.microsoft.com/en-us/sql/relational-databases/search/get-started-with-full-text-search?view=sql-server-ver16. 

Mike

the a_asset table was existing. Your sql returned "Installed" .  dbconfig used to work in this environment. The test being used is editing the number of characters of an existing field in the asset table. The data in the a_asset table is not needed.

If the data in the table is not needed I would then try to

1. change the length back to what you originally had (Apply Changes) or if it failed you may be able to Discard changes)
2. remove the E-Audit on the table (run Apply Changes), 
3. Change the length (run apply changes)
4. enable E-audit on the appropriate fields (run apply changes).

Mike

can only uncheck audit enable on table level. Could not uncheck audit enable on the single field.

The audit enable uncheck process ran a clean dbconfig.   The edit of adding field length failed.

BMXAA0345I - Altering table ASSET.
BMXAA0345I - Altering table A_ASSET.
User does not have permission to perform this action.
BMXAA6819I - ConfigDB completed with errors.
BMXAA6820I - RestoreFromBackup completed without errors.

Also checking the Full text search set up with my DBA

It seems your db user doesn't have access to your a_asset table.

Check if this link can help you identify the owner and permissions on your table and work with your DBA to fix it, if necessary.

https://dba.stackexchange.com/questions/114994/script-to-show-all-the-permissions-for-a-table