Transaction processing problem in UBE

[lefab]

Hi all,


I'm trying to use transaction processing for UBEs and it's not working for the moment.

Here is the code :

Begin Transaction(VA evt_TransId_TCID)
F59TEST.Open
F59TEST.Insert
F59TEST.Close
Rollback Transaction(VA evt_TransId_TCID)

When I look at the table, the insert is made ...
The VA evt_TransId_TCID value return by begin transaction is "0".
The transaction processing is enable in the global properties of the report.
The UBE runs on local fat client.

What's wrong ?

- Code problem ?
- JDE.INI problem ?
- transaction processing for UBE only runs on server ?

Thanks a lot for help.

 

[Nicolas_V]

The Begin Transaction does not return a value. See attached file.

 

[Juan Esteban]

The variable GOES evt_TransId_TCID is initialized in 1 and to increase
whenever a transaction begins and finalizes.

Check that this check box of the options Advanced is on when
opening the table.

see attached file

 

[lefab]

That's what I thought ...
So where does it come from ?

 

[lefab]

Yes, the include in transaction option is checked in the open table I/O.

What do you mean about the TCID variable ? The documentation says it's for future use. You mean "Begin Transaction" system function should initialize it to 1 or I should initialise the variable by myself before calling "Begin Transaction" ?

 

[Juan Esteban]

yes, yoo should initialise the variable by myself before calling "Begin Transaction" and to increase
whenever a transaction begins and finalizes

 

[lefab]

I initialised it to "1" and it's still not working ...

 

[Juan Esteban]

Example

Begin Transaction(VA evt_TransId_TCID)
F59TEST.Open
F59TEST.Insert
F59TEST.Close
Commit Transaction(VA evt_TransId_TCID)

 

[lefab]

That's exactly what I'm doing ...

I think more and more about somthing from the JDE.INI.

The documentation is giving something about lock manager section for both client and server ini files. Is that all that needs to be done ? Maybe working ini files for server and client could help.

Thank you.

 

[Zoltan_Gyimesi]

Hi Fabien,

I suppose, you enabled Transaction Processing on the Advanced tab of Report Properties, am I right?

Regards,

Zoltán