Maximo

 View Only

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

    Posted 6 days ago

    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 5 days ago

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

    Original Message


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

    Posted 5 days ago
    Edited by Srini 5 days ago

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

    Thanks



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

    Original Message


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

    Posted 3 days ago

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

    Original Message