Batch Manufacturing Template

[Former Member]

I am importing the 'Configurations V1.zip' file for the aforementioned templates into MII 12.1 and facing this error -

"Unable to import message listeners rules, com.sap.xmii/dao.DAOException: com.sap.engine.services.dbpool.exceptions.BaseSQLException: Cannot begin JDBC transaction from this connection of "SAPXXXDB" DataSource. JTA transaction has already started."

Any clue what this means?

Regards,

Chanti.

[erik_schrampf · Accepted solution]

I believe this is a bug with the import of Message Listener Rules what version including build of MII do you have? To fix this just uncheck the message listener rule option and import without this. Then manually configure it with the following options:

Rule Name - CONTROL_RECIPE_DOWNLOAD

Rule Description - Control Recipes

Server Name - Choose the correct RFC Listener

Message Name - CONTROL_RECIPE_DOWNLOAD

Message Type - RFC

Processing Type - Category

Category - CONTROL_RECIPES

Category Description - queues the received control recipes

Transaction - Empty

Persist Transaction - Always

Log Level - None

[Former Member · Accepted solution]

I am on MII 12.1.4 Build(53).

Yes, I didn't notice the error when I unchecked message listener rules.

Thanks.

[Former Member · Accepted solution]

I receive the same error when I manually configure it. Any clue?

Here is something I found as "fatal" error in the logs -

"Couldn't rollback changes

[EXCEPTION]

com.sap.engine.services.dbpool.exceptions.BaseSQLException: Cannot rollback JDBC transaction from this connection of "SAPXXXDB" DataSource. This resource participates in a JTA transaction."

Edited by: CKxMII on Apr 1, 2010 5:01 PM

Edited by: CKxMII on Apr 1, 2010 5:02 PM

[erik_schrampf · Accepted solution]

I would recommend upgrading to the newest version of MII 12.1.5 Patch 1 where this error is not occurring and has been fixed.

Are you able to create a message listener rule which points to a trx and not use the category option?

Edited by: Erik Schrampf on Apr 1, 2010 11:24 AM

[Former Member · Accepted solution]

Can you tell me what is the encryption algorithm in "Configurations"? Should I be using a specific one for my scenario?

Regards,

Chanti.

[erik_schrampf · Accepted solution]

It should be set to Base 64.

[Former Member · Accepted solution]

Appreciate it. If you know it, can you just tell me what is an encryption algorithm in general? And why I should be using Base64 here?

[Former Member · Accepted solution]

Yes, I was able to create a transaction based processing rule. I am getting the error only in the case of category based processing rule. Any thoughts?

[Former Member · Accepted solution]

Follow this steps:

1. Create Rule with assigned TRX.

2. Save the Rule.

3. Modify from TRX to Category.

4. Create Category and select the Category.

5. Save the Rule again.

Now will work.

Cheers.

Pedro Iglesias

[Former Member · Accepted solution]

Thanks Pedro. Seemed to work for now. Will let you know if any more issues.