Just got the trial version of Prizm working for us, and it was running fine all day. Then I went to connect the next morning and it was down. Now, it will not restart. It gives me an error with the MySQL database information. I have looked at the databases and all the information is there.
Here is the log from an attempt to restart. Thanks
02/27/06 14:33:05 INFO SYSTEM Starting Prizm EMS Server…
02/27/06 14:33:05 INFO SYSTEM Build Version: 1.10.r01( 11.07.2005 17:27:49 )
02/27/06 14:33:05 INFO SYSTEM Java Version: 1.4.2
02/27/06 14:33:05 INFO SYSTEM Platform: i386
02/27/06 14:33:05 INFO SYSTEM Operating System: Linux
02/27/06 14:33:05 INFO SYSTEM OS Version: 2.4.21-20.ELsmp
02/27/06 14:33:05 INFO SYSTEM Installing Security Manager
02/27/06 14:33:05 INFO SYSTEM Checking for Licenses at: /usr/local/Canopy/FLEXnet/license_files
02/27/06 14:33:05 INFO SYSTEM Utilizing Licensing Source: /usr/local/Canopy/FLEXnet/license_files
02/27/06 14:33:05 INFO SYSTEM Exported class com.mot.canopy.prizm.core.Server at port: 12801
02/27/06 14:33:05 INFO SYSTEM Attempting to checkout Prizm Server license.
02/27/06 14:33:05 INFO SYSTEM Exported class com.mot.canopy.prizm.core.Licensing at port: 12802
02/27/06 14:33:05 INFO SYSTEM LOADING ENABLED SERVICE: Canopy.Prizm.DatabaseManager
02/27/06 14:33:05 INFO SYSTEM DBManager Connecting to Database: localhost:3306
02/27/06 14:33:05 INFO SYSTEM DBManager using Driver Profile: MySql
02/27/06 14:33:06 INFO SYSTEM LOADING ENABLED SERVICE: Canopy.Prizm.LogEventManager
02/27/06 14:33:06 INFO SYSTEM Checking for V1 Event Table Upgrade to V2
02/27/06 14:33:06 INFO SYSTEM Check for V1 Event Table Upgrade to V2 completed: 28 ms
02/27/06 14:33:06 INFO SYSTEM Checking for V2 Event Table Upgrade to 01_00_00
02/27/06 14:33:06 INFO SYSTEM Check for V2 Event Table Upgrade to 01_00_00 completed: 2 ms
02/27/06 14:33:06 INFO SYSTEM Checking for 01_00_00 Event Table Upgrade to 01_10_00
02/27/06 14:33:06 INFO SYSTEM Check for 01_00_00 Event Table Upgrade to 01_10_00 completed: 1 ms
02/27/06 14:33:06 INFO SYSTEM Log Event Table, loading Hash Cache:
02/27/06 14:33:06 INFO SYSTEM Log Event Table, loaded Hash Cache: 134 ms
02/27/06 14:33:06 INFO SYSTEM LogEvent Dispatcher: Thread started
02/27/06 14:33:06 INFO SYSTEM Exported class com.mot.canopy.prizm.services.logeventmanager.LogEventManager at port: 12803
02/27/06 14:33:06 INFO SYSTEM LOADING ENABLED SERVICE: Canopy.Prizm.UserManager
02/27/06 14:33:06 INFO SYSTEM Checking for 01_00_00 Preferences Table Upgrade to 01_10_00
02/27/06 14:33:06 INFO SYSTEM Check for 01_00_00 Preferences Table Upgrade to 01_10_00 completed: 1 ms
02/27/06 14:33:06 INFO SYSTEM Exported class com.mot.canopy.prizm.services.usermanager.UserManager at port: 12804
02/27/06 14:33:06 INFO SYSTEM LOADING ENABLED SERVICE: Canopy.Prizm.NodeManager
02/27/06 14:33:06 INFO SYSTEM missing column:port_6_rx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_1_tx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_8_rx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_8_tx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_7_rx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_7_status,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_6_tx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_4_rx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_5_tx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_5_rx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:gps_satellites_visible,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_5_tx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_6_rx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_1_status,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_7_tx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_8_rx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_7_tx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_7_tx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_1_tx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_8_tx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_7_rx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_5_rx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_5_rx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_5_tx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_4_tx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_5_status,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_5_tx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_3_rx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_2_tx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_4_rx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_3_rx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_1_rx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_6_tx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_3_rx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_4_status,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_6_rx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_3_tx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_2_rx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_8_tx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_6_tx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_2_rx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_8_rx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_4_tx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_5_rx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_2_status,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_3_status,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_8_rx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_7_rx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_3_tx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_4_tx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_7_tx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_2_rx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_1_rx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_3_rx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_4_rx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_2_tx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_1_tx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_1_tx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_7_rx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_4_tx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_6_status,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_6_tx_broadcast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_1_rx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_3_tx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:gps_satellites_tracked,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_6_rx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_3_tx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_8_tx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_4_rx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_8_status,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_1_rx_bytes,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_2_tx_discards,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_2_rx_multicast,type:double
02/27/06 14:33:06 INFO SYSTEM missing column:port_2_tx_broadcast,type:double
02/27/06 14:33:06 SEVERE SYSTEM ADD Column failed:java.sql.SQLException: Duplicate column name 'port_6_rx_multicast’
02/27/06 14:33:06 INFO SYSTEM LogEvent Dispatcher: Thread completed
02/27/06 14:33:06 SEVERE SYSTEM Start Server failed: NodeManager startup failed
02/27/06 14:33:06 SEVERE SYSTEM EXCEPTION: com.mot.canopy.prizm.core.InvalidConfigurationException: NodeManager startup failed
com.mot.canopy.prizm.services.nodemanager.NodeManager.startup(NodeManager.java:80)
com.mot.canopy.prizm.core.Server.loadServices(Server.java:939)
com.mot.canopy.prizm.core.Server.startup(Server.java:685)
com.mot.canopy.prizm.core.Server.startServer(Server.java:530)
com.mot.canopy.prizm.core.Server.main(Server.java:243)
02/27/06 14:33:06 SEVERE SYSTEM Prizm Server Failed to Start. See above errors.