Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
Expand all | Collapse all

MAS 9 Upgrade from 7613 - MS SQL DB - Getting error - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'a_longdescription'

  • 1.  MAS 9 Upgrade from 7613 - MS SQL DB - Getting error - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'a_longdescription'

    Posted Thu December 12, 2024 09:50 PM

    Hi All,

    Looking for help on below error.

    Getting this while running updatedb.sh for upgrading 7613 DB to MAS9.

    6 ms    create sequence eauditseq as bigint no cycle no maxvalue start with 28803238 increment by 1
    ;
     
    // Success.
     
    com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'a_longdescription'.
            at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:946)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:840)
            at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7739)
            at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4384)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263)
            at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:762)
            at com.ibm.tivoli.maximo.dbmanage.connection.LoggingStatement.executeQuery(LoggingStatement.java:279)
            at psdi.configure.Util.createOneSqlServerSequences(Util.java:18850)
            at psdi.configure.Util.createSqlServerSequences(Util.java:18534)
            at psdi.tools.UpdateDB.createSQLServerSequence(UpdateDB.java:287)
            at psdi.tools.UpdateDB.main(UpdateDB.java:3684)
    bash-4.4$
    ******************************
    I have checked below things.
    maxattribute, maxattributecfg, maxtable, maxobject, maxobjectcfg - table dont exist.
    logndescription - audit is not on.
    maxsequence - there was one entry related to A_LONGDESCRIPTION. Deleted the same, but error still exists.
    maxrelationship - no entry related to A_longdescription table.
    Could someone please advise on this?


    ------------------------------
    Ritesh Ranjan
    ------------------------------


  • 2.  RE: MAS 9 Upgrade from 7613 - MS SQL DB - Getting error - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'a_longdescription'

    Posted Fri December 13, 2024 08:39 AM

    A_LONGDESCRIPTION is a table that is supposed to exist out of the box. Long description is special because customers don't want to e-audit every long description, but rather long descriptions for specific objects (IE audit the ASSET.DESCRIPTION_LONGDESCRIPTION). 

    I honestly don't know how to tell you the best way to fix it so I would recommend opening a support case. You really want to get this audit table added back rather than avoiding the error related to sequences. 

    I'm providing the query we use to try and identify the sequences we need to create. I'm providing this for you to help identify potentially other problems. I would NOT use this to remove the reference because I'm not sure what other problems might occur.  

    select ms.sequencename, ms.tbname, ms.name 
    from maxsequence ms, maxtable mt, maxattribute ma 
    where ms.tbname = ma.objectname 
    and ms.name = ma.attributename 
    and mt.tablename = ma.objectname 
    and ms.tbname = ma.objectname 
    and ma.persistent = 1 



    ------------------------------
    Steven Shull
    ------------------------------



  • 3.  RE: MAS 9 Upgrade from 7613 - MS SQL DB - Getting error - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'a_longdescription'

    Posted Fri December 13, 2024 09:07 AM
    Edited by Srini Fri December 13, 2024 09:07 AM

    We are also planning to upgrade from 7613 to MAS. Do you have the link or document to share for upgrade ?

    Thanks



    ------------------------------
    Srini
    ------------------------------



  • 4.  RE: MAS 9 Upgrade from 7613 - MS SQL DB - Getting error - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'a_longdescription'

    Posted Sun December 15, 2024 05:53 PM

    Hi Srini,

    I used latest docker mascli image to install MAS9. You can also look at ansible approach to install MAS9, that is also good.

    And I am following IBM documents for the same.



    ------------------------------
    Ritesh Ranjan
    ------------------------------