The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!
A chart showing the TIBCO Platform vision
Jump to content
Forums
Ask questions and gain insight from discussions

SCRIBE ONLINE - Using MS SQL Server connector - step that inserts parent record is returning null primary key in later steps


Recommended Posts

Posted

I'm having an issue with retrieving the primary key of a previously created record in my map. The parent record is successfully created in my MS SQL server DB, but the flow errorserrors outs on the first child record create because the refrenced primary key from the parent create step is showing as NULL.

Can anyone please help I've been searching around for a couple hours and can't seem to find any answers. Thanks in advance if you can help!

-James

Posted

Double check if the create Parent record block is using batch, turn it off to troubleshoot and see if that solves the problem.

Also verify how are you passing/mapping your record ID to the child create block (are there any other SQL level constraints, what is the datatype being mapped from and to, are they the same ).

To troubleshoot/test if you are getting record id, try using Debug or Scribe labs Tools connector.

https://support.tibco.com/s/article/Scribe-Labs-Tools(shows you how to write to Log file for troubleshooting.)

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...