Forum Discussion

ssmith-nova's avatar
ssmith-nova
Contributor
2 years ago
Solved

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
    2 years ago

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

  • ssmith-nova's avatar
    ssmith-nova
    2 years 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. 

     

ssmith-nova's avatar
ssmith-nova
Contributor
2 years ago

Thank you, I missed the obvious.  I was catching the error, but then I was throwing an exception.  If I just capture the error and move on, I am good.  

seangly's avatar
seangly
New Contributor III
2 years ago

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
    Contributor
    2 years 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
      2 years ago

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