Remedy - Server - Error: error "Table or View does not exist" during an upgrade while tables TV<table_id> are attempted to be dropped

Version 7
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    AR System


    APPLIES TO:

    Remedy AR Server 9.x and higher.



    QUESTION:

    During an upgrade errors are observed wsuch:
    ................
    "ORA-00942: table or view does not exist"
    ................

    when the installer tries to drop tables(s) TV<table_id> 

    Example of the stack error shows:
    ......................
    org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE TV285_1];  nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE TV336_1];  nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE TV205_1];  nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist. ...................... 
    What are these TV tables?


    ANSWER:

    TV* tables
    These tables are AR Vendor tables typically created during Static or Dynamic joins where Vendor forms are involved.
    Such tables are created dynamically when data is requested from a
    Vendor-Join form and these tables may or may not get deleted once the data is used.
    These tables should get dropped on subsequent startup of the server.

    In the reported upgrade scenario, these errors are seen when the AR Server database contains one or more TV tables.
    After the upgrade if you attempt to look for these tables, they may not be available as AR Server restart should drop them during the upgrade process.

    To identify if your system has any TV tables, use the following SQL statements:
    For Oracle:

    select table_name from user_tables where table_name like 'TV%'

    For SQL Server:
    select name from sysobjects where name like 'TV%' and xtype='U'

    These errors/tables have no functional impact and so, these can be ignored.

     


    Article Number:

    000154739


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles