0 Replies Latest reply: Nov 20, 2012 2:01 PM by user10723736 RSS

    User tables disappeared from our Planning SQL table

    user10723736
      All of the user tables in the SQL database associated with our Planning application mysteriously disappeared.

      We created a classic Planning application and converted it to an EPMA application. We deployed the application in our test environment and then used Lifecycle Management to migrate it to production. Everything was functioning well until we started getting errors saying "Creating rebind thread to RMI
      Query Failed: SQL_GET_SYSTEMCFG: null
      java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'HSP_SYSTEMCFG'."

      We checked the tables in our production Planning relational database and all of the HSP* tables were gone. The HSP_SYSTEMCFG table disappeared sometime before 11/14/12 and the remaining tables disappeared between 11/14 and 11/16. The tables went missing in both our test and production environments, but I'm not sure of the timing for the test database. Our SQL DBA couldn't find any unusual activity in the SQL logs. We are trying to determine the cause and have not had any luck so far. Has anyone else experienced this problem?

      We have restored the tables from a database backup but are concerned that the problem could occur again.