I am running webMethods 6.1 on windows platform with SQL Server as my database. I did run all the scripts for the webMethods tables however, when I log on to WmMonitor on page load I get the following error
Failed getting instance list (java.sql.SQLException: [wm-cjdbc33-0009][SQLServer JDBC Driver][SQLServer]Invalid column name ‘AUDITTIMESTAMP’.)
Please can someone help me with it.
I got it … the reason it was happening because one of the webMethods tables was missing AUDITTIMESTAMP column to be precise it was the WMPROCESSASSOC table.
Best,
Abhijeet
Abhijeet,
look into the directory of database scripts. It’s supposed to have into this directory some scripts in order to update your database. Look the migrate directory…
Regards,
Kleber
Please look at SQLserver migration script 6.1.5. webMethods did not put right scripts for wM 6.1 Monitor.
Thanks Kleber and Fan I got it working with the migration scripts 6.1.5.
Best,
Abhijeet