java.sql.SQLSyntaxErrorException: ORA-00917: missing comma Error Encountered when editing a channel from uportal

Description

INFO [org.jasig.portal.ChannelManager#53] CWebProxy.access.[] Oct/23 10:44:11 - logAccess: 331 admin http://www.st-andrews.ac.uk/cc/portal/news/ 200 0.076
INFO [org.jasig.portal.ChannelManager#74] CWebProxy.access.[] Oct/23 10:44:11 - logAccess: 433 admin https://onlineshop.st-andrews.ac.uk/navigation.asp 200 0.279
INFO [http-443-7] url.PortletUrlSyntaxProviderImpl.[] Oct/23 10:45:37 - No portlet defintion found for channel definition '7' with fname 'admin.navigation.links'. skipping portlet parameter processing
INFO [http-443-7] url.PortletUrlSyntaxProviderImpl.[] Oct/23 10:45:40 - No portlet defintion found for channel definition '43' with fname 'portal/channelmanager/general'. skipping portlet parameter processing
INFO [org.jasig.portal.ChannelManager#67] groupsmanager.Utility.[] Oct/23 10:45:57 - CGroupsManagerFactory took 40 ms to instantiate selection servant
INFO [org.jasig.portal.ChannelManager#71] portal.ChannelRegistryManager.[] Oct/23 10:46:34 - Caching channel types.
ERROR [org.jasig.portal.ChannelManager#68] portal.RDBMChannelRegistryStore.[] Oct/23 10:46:39 - Exception saving channel definition org.jasig.portal.ChannelDefinition@1358f1fa
java.sql.SQLSyntaxErrorException: ORA-00917: missing comma

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.jasig.portal.RDBMChannelRegistryStore.insertChannelParam(RDBMChannelRegistryStore.java:765)
at org.jasig.portal.RDBMChannelRegistryStore.saveChannelDefinition(RDBMChannelRegistryStore.java:651)
at org.jasig.portal.ChannelRegistryManager.publishChannel(ChannelRegistryManager.java:591)
at org.jasig.portal.channels.CChannelManager.doAction(CChannelManager.java:545)
at org.jasig.portal.channels.CChannelManager.setRuntimeData(CChannelManager.java:137)
at org.jasig.portal.ChannelRenderer$Worker.execute(ChannelRenderer.java:498)
at org.jasig.portal.utils.threading.BaseTask.run(BaseTask.java:27)
at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.orm.jpa.JpaInterceptor.invoke(JpaInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at org.jasig.portal.$Proxy57.run(Unknown Source)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
ERROR [http-443-7] portal.ChannelRenderer.[] Oct/23 10:46:39 - Channel rendering failed while getting title for channel renderer ChannelRenderer channel = [BaseChannel: staticData = [ChannelStaticData: Channel Publish ID = [43] Ch
annel Subscribe ID = [ctf2] person= [org.jasig.portal.security.provider.PersonImpl fullName=[Admin User] id=[2] securityContext=[org.jasig.portal.security.provider.UnionSecurityContext principal:org.jasig.portal.security.provider.
ChainingSecurityContext$ChainingPrincipal@33784d10 additionalDescriptor:null isAuth:true[org.jasig.portal.security.provider.ChainingSecurityContext$Entry@1f0b6fd6, org.jasig.portal.security.provider.ChainingSecurityContext$Entry@2
7db5a86]] attributes=[{uid=[admin], user.name.family=[User], mail=[admin.user@jasig.org], sn=[User], user.login.id=[admin], givenName=[Admin], uPortalTemplateUserName=[defaultTemplateUser], username=[admin], RDBMDistributedLayoutS
tore.PLF=[[#document: null]], UserProfile=[name :HTML browser profile,description: A sample profile for common web browsers,layout_id: 1,struct_ss_id: 1,theme_ss_id: 1,system: true,localeManager: LocaleManager's locales
----------------------- Session locales:

uportal 3.1.1

If I create a new image channel portlet and then re-edit the sub caption putting an apostrophe ' in the text on entering "finished" I get

ctf2
Message:

IChannelRenderer.completeRendering() threw
Error type:

Channel failed to render (code 1)
Problem type:

General rendering problem
Error message

java.sql.SQLSyntaxErrorException: ORA-00917: missing comma

The

<snip from portal.log>
User locales:
Browser locales: en_GB,en;q=0.5
Portal locales: en_US,ja_JP,sv_SE,de_DE
JVM locale: en_GB
Sorted locales: en_US,ja_JP,sv_SE,de_DE,en_GB
], displayName=[Admin User], user.home-info.online.email=[admin.user@jasig.org], user.name.given=[Admin]}] isGuest:false] ] runtimeData = [ChannelRuntimeData: map=[{uPCM_submit=[Ljava.lang.String;@34765e02, uPCM_action=[Ljava.lang
.String;@4715f036, uPCM_step=[Ljava.lang.String;@714d8daf}] browserInfo = [[content-type]=[application/x-www-form-urlencoded] [cookie]=[JSESSIONID=A48D2427D33F5A6A40A8DD22B7224379; __utma=151691899.105634410.1255363177.1256207756.
1256229754.13; __utmz=151691899.1255363177.1.1.utmccn=(referral)|utmcsr=facebook.com|utmcct=/home.php|utmcmd=referral; __utmc=151691899] [connection]=[keep-alive] [accept-language]=[en-gb,en;q=0.5] [host]=[vincent.st-andrews.ac.uk
--More--(76%)

Environment

SunOS vincent 5.10 Generic_141414-02 sun4v sparc SUNW,T5240
java version "1.6.0_16"
Java(TM) SE Runtime Environment (build 1.6.0_16-b01)
Java HotSpot(TM) Server VM (build 14.2-b01, mixed mode)
tomcat 6.0.20
Oracle 10g
jdbc version 11.2.0.1.0

Activity

Show:
Eric Dalquist
November 24, 2009, 4:30 PM

This doesn't affect trunk since RDBMChannelRegistryStore has been replaced with a JPA implementation

PatrickM
July 28, 2014, 11:33 AM

High few headaches of world have been proposed, including first norepinephrine heart, adderall 10mg blue addiction, cerebral tics, and paraphernalia people.
http://www.surveyanalytics.com//userimages/sub-2/2007589/3153260/29851520/7787459-29851520-stopadd48.html
United states through unnecessary children and with normal recognition.

Assignee

Eric Dalquist

Reporter

Kevin Thomson

Labels

None

Estimated End Date

None

Components

Fix versions

Priority

Blocker
Configure