This discussion is archived
0 Replies Latest reply: Nov 20, 2012 12:01 PM by user10723736 RSS

User tables disappeared from our Planning SQL table

user10723736 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points