WM 9.9 Error while Connect to SQL server 2012

, ,
1

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

2

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?

3

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

4

Run the installer and select "DatabaseComponentConfigurator under Database Configuration "

5

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

Thanks.

wanna install.jpg

6

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

7

Dear M@he$h,

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

8

what did you do wrong which caused the issue ?

Thanks,

9

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.