DB2 Error when installing purchased portlets from Marketplace

[David Welch, modifié il y a 9 années.]

I receive a DB2 error whenever I try to install any portlet or theme from the Marketplace. Below is the error when trying to install the Social Office portlets, but, this same error occurs every time:

[indent]04:10:24,881 ERROR [http-bio-80[indent]80-exec-9][JDBCExceptionReporter:82] [jcc][t4][102][10040][3.67.28] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.__Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null [Sanitized]
04:10:24,881 ERROR [http-bio-8080-exec-9][JDBCExceptionReporter:82] Error for batch element #1: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.67.28[/indent][/indent]

I don't know how to continue at this point. I'm using the standard Tomcat bundle for 6.2.1 CE GA3, and, the portal seems to function properly. I am able to deploy portlets/themes by copying files to the /deploy folder, but, can't get "Install" to work from the "Purchased" section at all.

Where can I start debugging this? Is there a way to turn on SQL tracing so I can see where the SQL statement is failing? The DB2 error is defined as "THE VALUE OF INPUT VARIABLE OR PARAMETER NUMBER position-number IS INVALID OR TOO LARGE FOR THE TARGET COLUMN OR THE TARGET VALUE", but, no specifics on what is being updated/inserted into DB2.

Thanks,
David

[David H Nebinger, modifié il y a 9 années.]

Is there a stack trace that goes along with this? That would help identify whether this is a failure of the plugin or of Liferay trying to make the portlet available...

[David Welch, modifié il y a 9 années.]

This is all that is written to the logs, the "Install" button then just hangs with the spinner icon.

[David Welch, modifié il y a 9 années.]

So, does anyone know how to turn on tracing for SQL in Liferay? Is this the wrong area to post questions like this?

Thanks for any assistance.

[Corné Aussems, modifié il y a 9 années.]

David Welch:

So, does anyone know how to turn on tracing for SQL in Liferay? Is this the wrong area to post questions like this?

Thanks for any assistance.

use the portal-ext.properties setting

hibernate.show_sql=true. 

[David Welch, modifié il y a 9 années.]

Yes, I had tried that, but, it doesn't provide bind variables. Seems some kind of tracing a the Spring/Hibernate level tracing that would indicate this, but, I'm not familiar enough with this layer.

As you can see below, the table it's having issues with is Marketplace_App. Viewing the table shows 3 rows currently there (Resources Importer, and 3 other themes that I installed previously from marketplace). The trace is:

Hibernate: insert into Marketplace_App (uuid_, companyId, userId, userName, createDate, modifiedDate, remoteAppId, title, description, category, iconURL, version, appId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
01:56:35,906 ERROR [http-bio-8080-exec-1][JDBCExceptionReporter:82] [jcc][t4][102][10040][3.67.28] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.__Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null [Sanitized]
01:56:35,909 ERROR [http-bio-8080-exec-1][JDBCExceptionReporter:82] Error for batch element #1: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.67.28

[Corné Aussems, modifié il y a 9 années.]

David Welch:

Yes, I had tried that, but, it doesn't provide bind variables. Seems some kind of tracing a the Spring/Hibernate level tracing that would indicate this, but, I'm not familiar enough with this layer.

As you can see below, the table it's having issues with is Marketplace_App. Viewing the table shows 3 rows currently there (Resources Importer, and 3 other themes that I installed previously from marketplace). The trace is:

Hibernate: insert into Marketplace_App (uuid_, companyId, userId, userName, createDate, modifiedDate, remoteAppId, title, description, category, iconURL, version, appId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
01:56:35,906 ERROR [http-bio-8080-exec-1][JDBCExceptionReporter:82] [jcc][t4][102][10040][3.67.28] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.__Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null [Sanitized]
01:56:35,909 ERROR [http-bio-8080-exec-1][JDBCExceptionReporter:82] Error for batch element #1: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.67.28

Well it is obvious it is somewhere in the package com.liferay.marketplace
https://github.com/liferay/liferay-plugins/blob/6.2.x/portlets/marketplace-portlet/docroot/WEB-INF/service/com/liferay/marketplace/service/AppLocalServiceUtil.java
Upping the logging for this probably won't tell you much but it is worth a try.


In a distant past I have had my share of problems with DB2 too, unfortunately i (nor any of our customers) have a DB2 running now.
What i always did was creating tables manually.
So if you;
1. undeploy the marketplace plugin.
2. Remove the related tables https://github.com/liferay/liferay-plugins/blob/6.2.x/portlets/marketplace-portlet/docroot/WEB-INF/service.xml
and run the sql creation and indexes manually https://github.com/liferay/liferay-plugins/tree/6.2.x/portlets/marketplace-portlet/docroot/WEB-INF/sql
of course looking at any message being thrown at you.
3. deploy marketplace again

I hope you get further.

C.heers

[Juan Gonzalez, modifié il y a 9 années.]

I am not sure, but this seems to be the error from Notifications portlet (included in Social Office) that has more than 30 characters as table name:

https://issues.liferay.com/browse/LPS-53122