Run arcot-db-config-for-adapter-statemanager.sql with new Installer

Idea created by lotti01 Employee on Aug 3, 2017
    New
    Score4
    • Venkata Sagar Tummala
    • Stefan_Ginal
    • lotti01
    • paled03

    The new Simplified Installer for AA 9.0 says that database scripts are run automatically.

    This is true for all except of arcot-db-config-for-adapter-statemanager.sql

     I suggest to run this one as well with the installer.

     

    Otherwise you will end with the following errors in arcotsm.log

    2017-08-01 13:43:58,118 [Token janitor] ERROR server.tsmimpl.iBatisTSMImpl(286)  -> Unable to delete expired tokens (issued before 20170801112858.102, used before 20170801112858.102:    --- The error occurred in com/arcot/integrations/toksvr/server/tsmimpl/TsToken.xml.   --- The error occurred while applying a parameter map.   --- Check the sqlDeleteTokenOlderThan-InlineParameterMap.   --- Check the statement (update failed).   --- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ARTSTOKENS'. 2017-08-01 13:44:07,259 [http-nio-8080-exec-2] ERROR server.tsmimpl.iBatisTSMImpl(147)  -> Unable to create token fe3a436b0ab12084fb06bf46a59f3628e9c7169d | 20170801114407.259.fe3a436b: com.ibatis.common.jdbc.exception.NestedSQLException:    --- The error occurred in com/arcot/integrations/toksvr/server/tsmimpl/TsToken.xml.   --- The error occurred while applying a parameter map.   --- Check the sqlInsertTokenNoRisk-InlineParameterMap.   --- Check the statement (update failed).   --- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ARTSTOKENS'. 2017-08-01 13:44:07,259 [http-nio-8080-exec-2] ERROR toksvr.server.TokenManager(233)  -> Unable to create token from given data! 2017-08-01 13:44:28,118 [Token janitor] ERROR server.tsmimpl.iBatisTSMImpl(286)  -> Unable to delete expired tokens (issued before 20170801112928.118, used before 20170801112928.118:    --- The error occurred in com/arcot/integrations/toksvr/server/tsmimpl/TsToken.xml.   --- The error occurred while applying a parameter map.   --- Check the sqlDeleteTokenOlderThan-InlineParameterMap.   --- Check the statement (update failed).   --- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ARTSTOKENS'. 2017-08-01 13:44:41,009 [http-nio-8080-exec-7] ERROR server.tsmimpl.iBatisTSMImpl(147)  -> Unable to create token 62d15b485235376719e963c52d9b09bf477ad922 | 20170801114441.008.62d15b48: com.ibatis.common.jdbc.exception.NestedSQLException:    --- The error occurred in com/arcot/integrations/toksvr/server/tsmimpl/TsToken.xml.   --- The error occurred while applying a parameter map.   --- Check the sqlInsertTokenNoRisk-InlineParameterMap.   --- Check the statement (update failed).   --- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ARTSTOKENS'. 2017-08-01 13:44:41,011 [http-nio-8080-exec-7] ERROR toksvr.server.TokenManager(233)  -> Unable to create token from given data!