Russell Skovera Posted November 3, 2022 Share Posted November 3, 2022 Integration Flow reads account info from Dynamics 365, and performs an update/insert into a table on an IBM iseries (AS400/Power8). Updates work fine, but when performing an insert only a blank record is created in the target table. Has anyone else had this issue? Link to comment Share on other sites More sharing options...
Laura Pintescu Posted November 8, 2022 Share Posted November 8, 2022 Hi Russell,could you give me more information about the flow implementation type (IBM activity used, eventual schema, do you see if the input in the Activity IBM contains the information insert ecc ) ? Link to comment Share on other sites More sharing options...
Russell Skovera Posted November 8, 2022 Author Share Posted November 8, 2022 My flow reads information from Dynamics CRM using a Query. I map 2 Fields and perform an insert/update using an ODBC connector. The ODBC connector I am using on the TCI agent is the IBM iseries supplied ODBC driver. I currently have an on-prem version of Insight using the same driver and it is working fine. According to the Trace logs I generated from the TCI agent, the Values are being passed from Cloud to the ODBC driver. I also have a case logged on this. I am working with my network Admin to generate some ODBC trace logs from the IBM side. per the Tech's request. He also verified that the values are being passed to the ODBC driver. I am using the same USERID on the IBM side that i am using for the current on-prem version. Link to comment Share on other sites More sharing options...
Laura Pintescu Posted November 8, 2022 Share Posted November 8, 2022 Just for my understanding. You are using IBMi DB2 legacy on premise server using scribe Insight connector to Ms CRM D365 correct ? If yes, try to updated iSeries driver. Sometimes we recommend the DB2 from CData. https://www.cdata.com/drivers/db2/ Link to comment Share on other sites More sharing options...
Russell Skovera Posted November 8, 2022 Author Share Posted November 8, 2022 I currently have on-prem Insight using the IBM supplied iseries ODBC driver. Insight is being deprecated. We are moving to Tibco Cloud. I am using the same IBM supplied Driver that we are currently using for Insight, Insight works fine for all of my current DTS scripts. All of the Flows I have created reading from DB2 and writing to CRM work fine on cloud. The issue i am having is inserting into DB2 from CRM using Tibco cloud. Updates to existing data work fine. Link to comment Share on other sites More sharing options...
Laura Pintescu Posted November 8, 2022 Share Posted November 8, 2022 Check also the compatibility between connectors, product and versions. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now