Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

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


James Houck

Recommended Posts

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

Link to comment
Share on other sites

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.)

Link to comment
Share on other sites

×
×
  • Create New...