Hi,
I tried recovery without losing the data in the ANI database, but after I started the Daemon Manager, I saw the same error again in the ani.log file:
Failed (sql) to load table WbuPort because: com.sybase.jdbc2.jdbc.SybSQLException: SQL Anywhere Error -141: Table 'WbuPort' not found
Then i tried the second procedure - reinitialize the database. Here is the output of the command:
WARNING: Existing contents of ani database will be lost.
Do you want to continue [y/n]?y
INFO: Starting the DataBase
Starting database engine aniEng
INFO: Process created
INFO: Started the Database engine : aniEng Retry 0
INFO: Started the Database engine : aniEng Retry 1
INFO: Started the Database engine : aniEng Retry 2
INFO: Started the Database engine : aniEng Retry 3
INFO: Started the Database engine : aniEng Retry 4
INFO: Started the Database engine : aniEng Retry 5
INFO: Started the Database engine : aniEng Retry 6
INFO: Started the Database engine : aniEng Retry 7
INFO: Started the Database engine : aniEng Retry 8
INFO: Started the Database engine : aniEng Retry 9
INFO: Getting message
INFO: Connect the database dsn=ani
INFO: Connected the Database
INFO: Command Executed
INFO: Connecting the Database ani
INFO: Company=Cisco Systems;Application=NMTG;Signature=010fa55157edb8e14d818eb4f
e3db41447146f1571g32125eb777a87cbf8b29a954f559d4221b792ff8
INFO: Preparing AUTH cmd
INFO: AUTH Executed
INFO: AUTH cmd finished
INFO: Stopping the Database engine ani
Stopping database engine aniEng
SQL Anywhere Command File Hiding Utility Version 10.0.1.3830
INFO: Database [ani] authenticated successfully.
ani database initialization is completed.
This doesn't work also as seen in the log:
2011/09/20 09:26:40 main ani ERROR ServiceModule: Failed to instantiate com.cisco.nm.ani.server.dfmpoller.NoServiceModule
2011/09/20 09:26:40 main ani MESSAGE DBConnection: Created new Database connection [hashCode = 24499883]
2011/09/20 09:26:40 main ani MESSAGE PartialSMFCommit: Partial Commit is enabled for DataCollection
2011/09/20 09:26:41 main ani ERROR AniMain: error during dynamic initialize because : null
_Orb=org.jacorb.orb.ORB@14627a
2011/09/20 09:26:41 main ani MESSAGE AniEventMgr: Event Manager has been enabled
PBPB: EventSource::realCtor(): bind to event factory :EDSFactory on host=PLOVDATASRV01
orbProperties={org.omg.CORBA.ORBInitialPort=42342, org.omg.CORBA.ORBClass=org.jacorb.orb.ORB, org.omg.CORBA.ORBInitialHost=PLOVDATASRV01, org.omg.CORBA.ORBSingletonClass=org.jacorb.orb.ORBSingleton, jacorb.implname=CSEDSPersistentIOR, org.omg.PortableInterceptor.ORBInitializerClass.bidir_init=org.jacorb.orb.giop.BiDirConnectionInitializer}
September 20, 2011 9:26:41 AM ES_PLOVDATASRV01__1316500001412 PLOVDATASRV01 Debug ByteToObject: constructed
September 20, 2011 9:26:41 AM ES_PLOVDATASRV01__1316500001412 PLOVDATASRV01 Debug EDSClassLoader: init_connection:
September 20, 2011 9:26:41 AM ES_PLOVDATASRV01__1316500001412 PLOVDATASRV01 Debug EDSClassLoader: constructed
PBPB: EventSource::realCtor(): factory.createSourceConnector() = 0, ES_PLOVDATASRV01__1316500001412
Trying to get the already bounded object
2011/09/20 09:26:41 main ani ERROR POStore: Failed (sql) to load table WbuPort because: com.sybase.jdbc2.jdbc.SybSQLException: SQL Anywhere Error -141: Table 'WbuPort' not found
2011/09/20 09:26:41 main ani ERROR AniMain: SQL Anywhere Error -141: Table 'WbuPort' not found
ANI Server failed to load from the database.
Please stop and restart the system. You may need to re-initialize the database.
If this does not work, please contact technical support.
