error While Tracing

[qwerty12]

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

[rmg]

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

[qwerty12]

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:
Try Seq
Start transaction
Insert adapter
Commint transaction

Catch
Roll back transcation
getlast error
exit


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

Thanks:)

[rmg]

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

[rlitjens]

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