error While Tracing

, ,
1

I have a subscribe service that inserts a file into a SQL data base.
While using the insert adapter, I manually map the values to the insert input file. When I run the service null values are inserted into the database and when I trace the its gives :“error while tracing”.

Has anyone seen this happen before.

Thanks:)

2

Can you give the code snippet of your flowservice…Is it transaction based?? like StartTransaction/…mapping…call InsertAdapterService…/CommitTransaction

If you have the start/commit trasactional services,just run the service but dont use Step or Trace it will throw error.

HTH,
RMG

3

It is transaction based. When I run the service , it runs with out any error if I dont specify any values in the input fields. If I do then it gives an error stating ‘Could not run the service’. There is mapping but only from the input published file to the insertinput file with out any transformations.

I have given the published file as input to the service. The code looks like this

Main Seq:
[INDENT]Try Seq
Start transaction
Insert adapter
Commint transaction

Catch
Roll back transcation
getlast error
exit
[/INDENT]

Also, the datatype on the published file is string and the datatypes of the adapter differ.

Thanks:)

4

That what i mentioned in my post if you have
Start transaction…Commint transaction in the flow you cannot Step/Trace the service you will see the error which is as expected.

So for testing directly Run the service this is the way to go.

HTH,
RMG

5

I always call the “start transaction” as first, because then the transaction field (input/output field of start transaction) is available in the catch.

Start transaction
Main Seq:
Try Seq
Insert adapter
Commit transaction
Catch
Roll back transcation
getlast error
exit

-Rob