WM 9.9 Error while Connect to SQL server 2012

Hi All,

I had installed WM 9.9 in our development server and try to connect to SQL Server 2012 in DB server.
I got no error while installation. When I access http://localhost:5555, it doesn’t work. page can’t be displayed

url : jdbc:wm:sqlserver://Server\XXX;DatabaseName=DBNAME

I tried to add sqljdbc42.jar in C:\SoftwareAG\IntegrationServer\lib\jars. But it doesn’t work.

I got this error in my server.log.

[code]
2016-02-05 09:54:46 ICT [ISS.0137.0006E] Scheduler: Error initializing scheduler: [SoftwareAG][SQLServer JDBC Driver][SQLServer]Invalid object name ‘IS_USER_TASKS’.
2016-02-05 09:54:46 ICT [WmAuditingSC.destination.1122E] Destination ‘ErrorDBDest’ caught unexpected Throwable logging audit event: [SoftwareAG][SQLServer JDBC Driver][SQLServer]Invalid object name ‘WMERROR’.
2016-02-05 09:54:46 ICT [WmAuditingSC.logger.3405E] In logger ‘Error Logger’, failed to log to destination; reason: Fatal SQLException detected
2016-02-05 09:54:46 ICT [ISS.0028.0012I] WmRoot: Startup service (wm.server.dispatcher:init)
2016-02-05 09:54:46 ICT [ISS.0028.0012I] WmRoot: Startup service (wm.server.tx:init)
2016-02-05 09:54:46 ICT [WmAuditingSC.destination.1122E] Destination ‘ErrorDBDest’ caught unexpected Throwable logging audit event: [SoftwareAG][SQLServer JDBC Driver][SQLServer]Invalid object name ‘WMERROR’.
2016-02-05 09:54:46 ICT [WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘Error Queue’ failed to log event to destination ‘ErrorDBDest’; reason ‘[SoftwareAG][SQLServer JDBC Driver][SQLServer]Invalid object name ‘WMERROR’.’; stack trace follows
2016-02-05 09:54:46 ICT [WmAuditingSC.queue.2416I] In queue ‘Error Queue’ worker, the preceding error is non-recoverable; failing-over

Please advise us why this error is happening.

Regards,

Hutagaol

Hi,

Kindly share the components in wM product suite you want to install and use?

Did you ran the db component configuration tool after successful installation?

Hi M@he$h,

Thank you for the post,

where can I find the db component configuration tool?
I haven’t run it yet.

Bellow I attached the products I’ve been installed and my Installation folder look like.
wm9.9.jpg
softwareAG.jpg

Run the installer and select "DatabaseComponentConfigurator under Database Configuration "

I can’t find “DatabaseComponentConfigurator under Database Configuration” .
Is something missing from my image?

Thanks.

wanna install.jpg

Yes, check your image. You may also download the free wM 9.9 trial version available on tech community.

Dear M@he$h,

Thank you for your guidance,
it’s work for me.

what did you do wrong which caused the issue ?

Thanks,

I forgot to run and configure DB component configuration tool. In the other side, I have no component configuration tool in my image. My partner will try to create another image.
I try the trial version for a while, and using embedded RDBMS in my development machine.