IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Incorrect syntax near the keyword 'IF'. CREATE COMPONENTTRACKER [25.0] FAILED

  • 1.  Incorrect syntax near the keyword 'IF'. CREATE COMPONENTTRACKER [25.0] FAILED

    Posted Fri January 03, 2020 03:48 AM

    Hi All,

    while I was trying to run the migrate the ISinternal Db scripts thru DB configuration I am getting the below error:

    OS: Windows 2008
    IS : 9.12 version

    • create Database Component: ComponentTracker CTR
    • Versions
    • Version: mysql 25.0
    • Scripts create

    •   Script(1): D:\SoftwareAG-912\pregp1esb912a\common\db/scripts/mysql/componenttracker/25/create/mys_ctr_c_ddl.sql

    • Executing script : D:\SoftwareAG-912\pregp1esb912a\common\db/scripts/mysql/componenttracker/25/create/mys_ctr_c_ddl.sql

    Error: [SoftwareAG][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword ‘IF’.
    CREATE COMPONENTTRACKER [25.0] FAILED
    CDC ERROR [SoftwareAG][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword ‘IF’.
    Suspending execution…

              Summary of installation errors

    Error in executing file D:\SoftwareAG-912\pregp1esb912a\common\db/scripts/mysql/componenttracker/25/create/mys_ctr_c_ddl.sql
    SQL error [SoftwareAG][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword ‘IF’.

          Database component configurator summary

    Date : Fri Jan 03 06:46:21 GMT 2020
    Database : MySQL
    User : ISGP1912_OWNER
    Action : migrate

    Migration failed

    ComponentTracker 25.0

    Could you please help me with the resolution if you have come across the above error.

    Regards
    Hari


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 2.  RE: Incorrect syntax near the keyword 'IF'. CREATE COMPONENTTRACKER [25.0] FAILED

    Posted Fri January 03, 2020 04:49 AM

    You should raise this under subforum “webMethods Integration Server & ESB”, not under "webMethods Adapters and E-Standards ". This has nothing to do with adapter or e-standards adapters.

    This is purely IS related DB configurator issue.


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 3.  RE: Incorrect syntax near the keyword 'IF'. CREATE COMPONENTTRACKER [25.0] FAILED

    Posted Mon January 06, 2020 09:15 AM

    Hi Hari,

    can you provide us the list of fixes applied to your installation for the following parts?

    IntegrationServer
    DatabaseConfiguration
    SharedComponents → DataDirect

    Additionally provide the Database-URL you are using.
    The error message looks like it is using a driver for MS SQL Server instead of MySQL.

    I am not sure if MySQL is already fully supported by wM 9.12. Might be that this was introduced in 10.x

    Regards,
    Holger


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 4.  RE: Incorrect syntax near the keyword 'IF'. CREATE COMPONENTTRACKER [25.0] FAILED

    Posted Mon January 06, 2020 09:25 AM

    Hi Holger,

    Thanks for the reply. I got the issue fixed. actually I was selecting the DB type as MYSQL rather than SQL DB.

    Regards
    Hari


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


Related Content