Forum Discussion

ssmith-nova's avatar
ssmith-nova
New Contributor III
7 months ago

Capture No valid DataKeys Message

I have a BR that runs a load process using ExecuteParseAndTransform.  When the data source is empty for that profile it throws the "No valid DataKeys" error and stops the job.  I don't even get the o...
Data Integration
  • franciscoamores's avatar
    franciscoamores
    7 months ago

    Hi, You can capture the exception and check the exception message

  • ssmith-nova's avatar
    ssmith-nova
    5 months ago
    Try
  ImportInfo  = BRApi.Import.Process.ExecuteParseAndTransform(si, wfClusterPk, String.Empty, Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False)

Catch ex As Exception
   log.AppendLine(ex.ToString)
End Try

    This is what I am doing. 

     

seangly's avatar
seangly
New Contributor III

Hi, 

Do you know how you can catch the error, when I ouput my exception message, it's seem to be blank.

Regards,
Seang

ssmith-nova's avatar
ssmith-nova
New Contributor III
5 months ago
Try
  ImportInfo  = BRApi.Import.Process.ExecuteParseAndTransform(si, wfClusterPk, String.Empty, Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False)

Catch ex As Exception
   log.AppendLine(ex.ToString)
End Try

This is what I am doing. 

 

  • seangly's avatar
    seangly
    New Contributor III
    5 months ago

    Thank for your update.
    I that message is to technical and long. 
    I used a shorter version
    failureSummary.AppendLine(ex.StackTrace.ToString)