Data Replication 2
Results 1 to 2 of 2

Thread: Express license: Target database File is not licensed under the Express license.

  1. #1
    asim is offline Junior Member
    Join Date
    Nov 2017
    Posts
    1
    Rep Power
    0

    Express license: Target database File is not licensed under the Express license.

    hey everybody,

    i installed and started attunity replicate express and if i want to replicate a DB2 database/table into MySQL or even into a file it pop up an error :
    "

    • Task cannot run.
    • Express license: Target database File is not licensed under the Express license."


    in the log file is written:


    00006812: 2017-11-08T14:33:46 [SERVER ]I: Attunity Replicate Server Log (V5.0.2.49 EX383.exxeta-de.local Microsoft Windows 64-bit, PID: 7376) started at Wed Nov 08 14:33:46 2017 (logger.c:475)
    00006812: 2017-11-08T14:33:46 [SERVER ]I: Licensed to Attunity Replicate Express users (software license acceptance implied)Express license: You are running the Express Edition with reduced functionality (131 days remaining) (logger.c:478)
    00006812: 2017-11-08T14:33:46 [SERVER ]I: The server is listening on TCP port 3550 (server.c:1353)
    00006812: 2017-11-08T14:33:46 [SERVER ]I: Client session (ID 19789) allocated (dispatcher.c:241)
    00004172: 2017-11-08T14:33:46 [REST_API ]I: Agent was started successfully (listening on port 3552). (atctl_serve.c:409)
    00008120: 2017-11-08T14:36:36 [REST_API ]E: DSP-E-NOHNDLR, No handler for the url entered </attunityreplicate/rest/servers/local/keepalive> Base general error. (dispatcher_misc.c:531)
    00010044: 2017-11-08T14:36:36 [REST_API ]E: DSP-E-NOHNDLR, No handler for the url entered </attunityreplicate/rest/servers/local/keepalive> Base general error. (dispatcher_misc.c:531)
    00010040: 2017-11-08T14:36:36 [REST_API ]E: DSP-E-NOHNDLR, No handler for the url entered </attunityreplicate/rest/servers/local/keepalive> Base general error. (dispatcher_misc.c:531)
    00005124: 2017-11-08T14:36:36 [REST_API ]E: DSP-E-NOHNDLR, No handler for the url entered </attunityreplicate/rest/servers/local/keepalive> Base general error. (dispatcher_misc.c:531)
    00010856: 2017-11-08T14:36:36 [REST_API ]E: DSP-E-NOHNDLR, No handler for the url entered </attunityreplicate/rest/servers/local/keepalive> Base general error. (dispatcher_misc.c:531)
    00006812: 2017-11-08T14:37:17 [SERVER ]I: Additional properties = '(null)' (db2luw_endpoint_imp.c:556)
    00006812: 2017-11-08T14:37:17 [SERVER ]I: DB2LUW connection string: DRIVER={IBM DB2 ODBC DRIVER};HOSTNAME=172.17.0.2;SERVICENAME=50000;DATA BASE=SAMPLE;UID=db2inst1;PWD=***; (db2luw_endpoint_imp.c:183)
    00006812: 2017-11-08T14:37:17 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T14:37:17 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T14:41:46 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T14:41:46 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:20 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:20 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:20 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:20 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:21 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:21 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:22 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:22 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:22 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:22 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:23 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:23 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:23 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:23 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:23 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:23 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:23 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:23 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:24 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:24 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:24 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:24 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:24 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:24 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:25:41 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:25:41 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:26:23 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:26:23 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:29:35 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:29:35 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:39:57 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:39:57 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:48:45 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:48:45 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:48:52 [INFRASTRUCTURE ]I: Allocated 20 ODBC connection handles (ar_odbc_func.c:193)
    00006812: 2017-11-08T15:48:52 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:48:52 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:49:00 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:49:00 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:49:23 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:49:23 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:49:29 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:49:29 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:50:27 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:50:27 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:50:48 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:50:48 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T15:55:26 [SERVER ]E: RetCode: SQL_ERROR SqlState: IM002 NativeError: 0 Message: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben [122502] ODBC general error. (ar_odbc_conn.c:434)
    00006812: 2017-11-08T15:55:26 [SERVER ]E: Cannot connect to DB2 LUW Server [122505] Fatal error has occurred (db2luw_endpoint_imp.c:564)
    00006812: 2017-11-08T16:07:41 [SERVER ]I: DB2 server version: 10.05.0005 (db2luw_endpoint_capture.c:63)
    00006812: 2017-11-08T16:07:41 [SERVER ]I: DB2 client version: 11.01.0000 (db2luw_endpoint_capture.c:64)
    00006812: 2017-11-08T16:07:41 [SERVER ]I: Parameter 'Max Buffer Size for Read' = 64 KB (db2luw_endpoint_capture.c:154)
    00006812: 2017-11-08T16:07:41 [SERVER ]I: Parameter 'Events Poll Interval' = 5 (db2luw_endpoint_capture.c:165)
    00006812: 2017-11-08T16:07:41 [SERVER ]I: Parameter 'CCSIdMapping' = NULL (db2luw_endpoint_capture.c:184)
    00006812: 2017-11-08T16:07:41 [SERVER ]I: Parameter 'Report DB2 Read Log Time' = -1 (db2luw_endpoint_capture.c:194)
    00006812: 2017-11-08T16:12:31 [SERVER ]I: Parameter 'Events Poll Interval' = 5 (db2luw_endpoint_capture.c:165)
    00006812: 2017-11-08T16:21:15 [SERVER ]E: Failed to load the library 'sqlncli11.dll' [720126] Das angegebene Modul wurde nicht gefunden. (system.c:448)
    00006812: 2017-11-08T16:21:15 [STREAM_COMPONENT]E: Error Initializing endpoint. Failed to load SQL Server Native Client 11.0 [121914] API library cannot be loaded. (sqlserver_api.c:118)
    00006812: 2017-11-08T16:21:15 [STREAM_COMPONENT]E: Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'. [121914] API library cannot be loaded. (streamcomponent.c:908)
    00006812: 2017-11-08T16:21:42 [SERVER ]E: Failed to load the library 'sqlncli11.dll' [720126] Das angegebene Modul wurde nicht gefunden. (system.c:448)
    00006812: 2017-11-08T16:21:42 [STREAM_COMPONENT]E: Error Initializing endpoint. Failed to load SQL Server Native Client 11.0 [121914] API library cannot be loaded. (sqlserver_api.c:118)
    00006812: 2017-11-08T16:21:42 [STREAM_COMPONENT]E: Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'. [121914] API library cannot be loaded. (streamcomponent.c:908)
    00006812: 2017-11-08T16:21:49 [SERVER ]E: Failed to load the library 'sqlncli11.dll' [720126] Das angegebene Modul wurde nicht gefunden. (system.c:448)
    00006812: 2017-11-08T16:21:49 [STREAM_COMPONENT]E: Error Initializing endpoint. Failed to load SQL Server Native Client 11.0 [121914] API library cannot be loaded. (sqlserver_api.c:118)
    00006812: 2017-11-08T16:21:49 [STREAM_COMPONENT]E: Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'. [121914] API library cannot be loaded. (streamcomponent.c:908)
    00006812: 2017-11-08T16:21:58 [SERVER ]E: Failed to load the library 'sqlncli11.dll' [720126] Das angegebene Modul wurde nicht gefunden. (system.c:448)
    00006812: 2017-11-08T16:21:58 [STREAM_COMPONENT]E: Error Initializing endpoint. Failed to load SQL Server Native Client 11.0 [121914] API library cannot be loaded. (sqlserver_api.c:118)
    00006812: 2017-11-08T16:21:58 [STREAM_COMPONENT]E: Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'. [121914] API library cannot be loaded. (streamcomponent.c:908)
    00006812: 2017-11-08T16:22:11 [SERVER ]E: Failed to load the library 'sqlncli11.dll' [720126] Das angegebene Modul wurde nicht gefunden. (system.c:448)
    00006812: 2017-11-08T16:22:11 [STREAM_COMPONENT]E: Error Initializing endpoint. Failed to load SQL Server Native Client 11.0 [121914] API library cannot be loaded. (sqlserver_api.c:118)
    00006812: 2017-11-08T16:22:11 [STREAM_COMPONENT]E: Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'. [121914] API library cannot be loaded. (streamcomponent.c:908)
    00006812: 2017-11-08T16:23:03 [SERVER ]E: Missing database name [120401] Endpoint initialization failed. (odbc_endpoint_imp.c:1895)
    00006812: 2017-11-08T16:23:11 [SERVER ]I: Going to connect to ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=test;U ID=root; (odbc_endpoint_imp.c:2112)
    00006812: 2017-11-08T16:37:03 [STREAM_COMPONENT]E: Getting DB object ('testFile') info from repository failed [120500] requested object was not found in the repository. (endpointshell.c:2218)
    00006812: 2017-11-08T16:37:03 [STREAM_COMPONENT]E: create_stream_handle failed [120500] requested object was not found in the repository. (endpointshell.c:2184)
    00006812: 2017-11-08T16:37:03 [STREAM_COMPONENT]E: Failed getting stream handle [120500] requested object was not found in the repository. (endpointshell.c:2323)
    00006812: 2017-11-08T16:37:03 [STREAM_COMPONENT]E: Command get_table_list failed when creating the stream component. [120500] requested object was not found in the repository. (endpointshell.c:2443)
    00006812: 2017-11-08T16:37:57 [SERVER ]I: File source using '65001' codepage (file_imp.c:145)
    00006812: 2017-11-08T16:45:49 [SERVER ]I: Parameter 'Events Poll Interval' = 5 (db2luw_endpoint_capture.c:165)

    Does anyone had the same problem and can help?

  2. #2
    reza.khan is offline Junior Member
    Join Date
    Jun 2013
    Posts
    25
    Rep Power
    0
    Hello Asim,

    Thank you for contacting Replicate Express support.

    Please note, that Replicate Express has limited source and target systems support, as described here:

    Attunity Replicate Free Trial

    As such, DB2 and File Endpoints are unsupported when using Replicate Express. Looking at your log, I saw that you also have Microsoft SQL Server configured, but the driver could not be found. Please ensure the following:

    1. Please install the 64 bit SQL native client 11 driver on the Attunity Replicate Express machine.
    2. After installing the driver, please restart the Attunity Replicate Server and UI services to ensure that the new drivers are detected and then run the task again using the source and target combinations listed in the link above.

    If you would like to gain access to a full version of Attunity Replicate to test DB2 and Files, please PM me your location and email address and I will connect you would a Regional Account Manager who can assist you further.

    Thank you.

    Reza K

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •