Skip to Content
0
Former Member
Oct 15, 2007 at 11:16 AM

Federated Portal - OpenSQLException

33 Views

Hi,

I am running a Portal 7.0 sps10 on my consumer and an EP 7.0 sps12 on my producer.

I have federated portal running, but if my full path to an object on my consumer is longer than 105 char, then an error message is appearing.

System Error:

Exception Class: class com.sapportals.portal.pcd.pl.PlRuntimeException

Exception Message:unexpected SQLException when converting short string to long stringCannot assign a java.lang.String object of length 125 to host variable 1 which has JDBC type VARCHAR(105).

The technical name of the role (full path to the role... http://server:port/....pcd:portal_content/com.sap.production/com.sap.federated/com.sap.role/com.sap.remote), is needed to be 105 char or lower in the consumer.

When the technical URL is lower than 105 char, then the error message is removed, and the object is correctly showed.

When using iView assigned to a page, assigned to a workset, assigned to a role, 105 char is too small.

Question: Is there a way to manually change this VARCHAR(105) to a larger number?