Maximo Open Forum

 View Only

 Point existing maximo (with Oracle database) to MSSQL database

  • Everything Maximo
Channakeshava Gode's profile image
Channakeshava Gode posted 04-05-2023 21:44

Hi everyone,
Need your advice on below issue please. In one of my windows VM, I have maximo 761 installed with Oracle database. And I want to use mssql database instead of Oracle. So I have installed MS SQL server database (express edition) and followed ibm document for configuring mssql db manually. And updated maximo.properties to point to sql database. But when executing encryptproperties.bat getting below driver (com.inet.tds.Tdsdriver) not found error. Has anyone faced this earlier or any advised please...?

Error Message:

Starting Encryption of Maximo.properties. Wed Apr 05 22:32:06 CST 2023 --- Starting ---- BMXAA6806I - Reading the properties file maximo.properties. java.lang.ClassNotFoundException: com.inet.tds.TdsDriver at java.lang.Class.forNameImpl(Native Method) at java.lang.Class.forName(Class.java:295) at psdi.configure.CommonShell.setupFromPropfile(CommonShell.java:1426) at psdi.util.EncryptProperties.setupFromPropfile(EncryptProperties.jav 448) at psdi.configure.CommonShell.setup(CommonShell.java:1219) at psdi.util.EncryptProperties.main(EncryptProperties.java:511) java.lang.Exception: BMXAA6813E - The database driver was not established: com net.tds.TdsDriver at psdi.configure.CommonShell.setupFromPropfile(CommonShell.java:1436) at psdi.util.EncryptProperties.setupFromPropfile(EncryptProperties.jav 448) at psdi.configure.CommonShell.setup(CommonShell.java:1219) at psdi.util.EncryptProperties.main(EncryptProperties.java:511) BMXAA6813E - The database driver was not established: com.inet.tds.TdsDriver W Apr 05 22:32:06 CST 2023 BMXAA6819I - EncryptProperties completed with errors. Wed Apr 05 22:32:06 CST 23

Prashant Sharma's profile image
Prashant Sharma posted 04-06-2023 01:43

You need to place the driver Jar file based on the SQL Server version of the Express edition inside SMP folder.

This should help finding the correct Jar.
https://learn.microsoft.com/en-US/sql/connect/jdbc/using-the-jdbc-driver?view=sql-server-ver16

Channakeshava Gode's profile image
Channakeshava Gode posted 04-06-2023 02:04

Thanks Prashant for your reply.

This error is resolved and could connect to mssql DB by using the below driver instead of  "mxe.db.driver=com.inet.tds.TdsDriver" in maximo.properties file.
com.microsoft.sqlserver.jdbc.SQLServerDriver.

However, when maxinst command is run (maxinst -tPRIMARY -sPRIMARY -imaxdb76), it's failing to read maxdb76.SQS file saying access denied error although user has full permission.
Any suggestions, please?

Error Message:

C:\maximo\maximo\tools\maximo>maxinst -tPRIMARY -sPRIMARY -imaxdb76
!
!!! WARNING !!!
!
! Maxinst will drop and rebuild all the tables in your database.
!
! If you are not sure you should be running Maxinst, hit Ctrl/C now!!!!
!
! Otherwise,
Press ENTER to continue . . .

Log file: Cleandb20230406124501.log
Connecting to: jdbc:sqlserver://192.168.189.128:1433;databaseName=maxdb76
Cleandatabase complete: Successful
Thu Apr 06 12:45:03 CST 2023 --- Starting ----
BMXAA6806I - Reading the properties file maximo.properties.
java.io.FileNotFoundException: en\maxdb76.sqs (Access is denied.)
        at java.io.FileInputStream.open(FileInputStream.java:212)
        at java.io.FileInputStream.<init>(FileInputStream.java:152)
        at java.io.FileInputStream.<init>(FileInputStream.java:104)
        at psdi.configure.Maxinst.endSetupInstance(Maxinst.java:2463)
        at psdi.configure.CommonShell.endSetup(CommonShell.java:1722)
        at psdi.configure.CommonShell.setup(CommonShell.java:1232)
        at psdi.configure.Maxinst.main(Maxinst.java:2551)
java.lang.Exception: Input file en\maxdb76.sqs could not be read.
        at psdi.configure.Maxinst.endSetupInstance(Maxinst.java:2478)
        at psdi.configure.CommonShell.endSetup(CommonShell.java:1722)
        at psdi.configure.CommonShell.setup(CommonShell.java:1232)
        at psdi.configure.Maxinst.main(Maxinst.java:2551)
Input file en\maxdb76.sqs could not be read. Thu Apr 06 12:45:05 CST 2023
BMXAA6819I - Maxinst completed with errors. Thu Apr 06 12:45:05 CST 2023

Channakeshava Gode's profile image
Channakeshava Gode posted 04-06-2023 08:20

The above error (access denied) is also resolved. just moved.SQS file to different location and ran maxinst command and it wokred... 

Related Content