Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
4 replies Latest Post - ‏2012-01-31T17:23:04Z by SystemAdmin
SystemAdmin
SystemAdmin
33 Posts
ACCEPTED ANSWER

Pinned topic Data transfer failure- secure connector running....without stop

‏2012-01-24T05:45:56Z |
Hi.

DB2 and Salesforce can be connected through secure connector.
After the when I run the transformation the data transformation is not taking place.
In the connector I can see the deploy activity called but it does not transfer any data.

There is also no update or error message in the Activities of cast iron express

Thanks
suresh
Updated on 2012-01-31T17:23:04Z at 2012-01-31T17:23:04Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    33 Posts
    ACCEPTED ANSWER

    Re: Data transfer failure- secure connector running....without stop

    ‏2012-01-30T15:40:21Z  in response to SystemAdmin
    Hi,

    What is the error that you're getting?
    Thanks,
    --Vasile
    • SystemAdmin
      SystemAdmin
      33 Posts
      ACCEPTED ANSWER

      Re: Data transfer failure- secure connector running....without stop

      ‏2012-01-30T21:03:02Z  in response to SystemAdmin
      Sorry..I didn't realize that they were no error logged.

      Now, when started the integration what was the operation that you were using on the database, and were you asked to create the assets?
      If the assets were created successfully(you can see the sql statements) assuming that the integration has been started after this step, did you notice any successfull mesage in the activity feed that involve this integration?

      Thanks,
      --Vasile
      • SystemAdmin
        SystemAdmin
        33 Posts
        ACCEPTED ANSWER

        Re: Data transfer failure- secure connector running....without stop

        ‏2012-01-31T01:56:03Z  in response to SystemAdmin
        > {quote:title=6QK3_Vasile_Patrascu wrote:}{quote}
        > Sorry..I didn't realize that they were no error logged.
        >
        > Now, when started the integration what was the operation that you were using on the database, and were you asked to create the assets?
        > If the assets were created successfully(you can see the sql statements) assuming that the integration has been started after this step, did you notice any successfull mesage in the activity feed that involve this integration?
        >
        > Thanks,
        > --Vasile

        Hi Vasile
        Thanks for your reply.
        Using insert operation from salesforce to DB2.
        Yes only once express asked me to create the assets and transformation started but failed.
        So second time I tried that time there was no message to create assets again the transformation failed.

        When I do the deploy, I can see the deploy action/message in the secure connector but there is no message in the
        express activity feed.Please refer to the attached screen shot of secure connector.
        • SystemAdmin
          SystemAdmin
          33 Posts
          ACCEPTED ANSWER

          Re: Data transfer failure- secure connector running....without stop

          ‏2012-01-31T17:23:04Z  in response to SystemAdmin
          What happens when you're are inserting a new row in the table? Can you query the "buffer" table(you should see a table named CI_BT_INSERT_<TABLE_NAME>) that the assets creates and check if the rows has been also inserted in that table?

          Thanks,
          --Vasile