WebMethods Monitor problem

[abhijeet]

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.

[abhijeet]

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

[kleberferreira]

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

[fz1231]

Please look at SQLserver migration script 6.1.5. webMethods did not put right scripts for wM 6.1 Monitor.

[abhijeet]

Thanks Kleber and Fan I got it working with the migration scripts 6.1.5.

Best,
Abhijeet