on 10-03-2013 10:33 AM
Hi,
I have a Problem with the MII JTA Custom Actions and wonder if anyone can point me to the right direction. I am working on an MII 12.1.6. System and the "basic" JTA actions blocks ("JTA Basic Query", "JTA Command") are working.
Now I want to use a prepared statement. I used this document http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/900ca908-078e-2b10-5d94-9c6e38e95... and created an even simpler version for my test.
If I execute it, I get the following output:
In the NetWeaver log:
I already tried:
- defining the list as a local property and linking it directly instead of using the append(emptylist...) --> same error
- use the JTA Batch statement instead --> same error
Every help is greatly appreciated.
Thanks and best regards,
Gernot
The problem was solved by deploying a new version of the custom action provided by Salvatore Castro.
Thanks for your help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Gernot,
Send me an email it's just my [Removed by Moderator] and I will send you the updated version of the actions.
The reason why this version of the JTA actions breaks is due to a change in the interface to the Security API for retrieving the credentials from the credential store of MII. There are other minor changes and adjustments to the updated version and I should point out that this functionality has been rolled into standard product as of the MII 14.0 release.
Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Salvatore,
thanks again for the updated custom action JAR. Unfortunately, it did not solve my problem. If I execute my simple test transaction in the workbench, then I get the exact same error messages as described in my initial posting. The only difference I noticed is that with the new version, no error messages are written to the NetWeaver log. I only get an error some minutes later about a transaction time out.
I would greatly appreciate if you (or of course anyone else reading this thread) has some idea about what I could do to get this functionality up and running.
Thanks and best regards,
Gernot
Gernot,
Which database are you using and does the insert command work using the standard query template interface? I just created the same scenario locally and it works without issue against my database.
Also...
Regards,
Sam
PS: The Commit/Rollback functionality was added to the standard MII 14.0 release and the SQL actions already use store procedures when you are using the "Typed" query parameters.
Hi Sam,
I am using an MS SQL Server 2008 database.
The insert works with the standard actions as well as with the JTA Command action. I also tried the Prepared Statement action with a simple update query (without the questionmarks): this also works (which is an improvement to the old JTA Version where this did not work).
But as soon as I add an questionmark into the prepared Statement and link the value list to the Execute Prepared Statement action, the error is thrown.
In the JTA_Start action I only linked the "DataSourceNames" to a list with my datasource.
Unfortunately, I cannot add a Catch action block, because it is not available on my system. As far as I now the Catch action was introduced in version 12.2, but this system is running on 12.1.
Thanks and best regards,
Gernot
If you run the transaction from the workbench using Ctrl + F5 you should see a lot of details in the Execution Log. Can you copy and paste the results into your next post?
Thanks,
Sam
PS: You can also run the transaction via Runner with the &LogType=Advanced parameter set and it will give you the XML version of the execution trace log.
Hello Sam,
thanks for the help and for the hint with the Runner; it may come in handy.
Here is the requested output. I only want to set one field, so the "Values Length: 1" seems correct to me:
Best regards,
Gernot
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.