We're updating the issue view to help you get more done. 

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

Status

Assignee

Eric Dalquist

Reporter

Kevin Thomson

Labels

None

Estimated End Date

None

Audience

None

Components

Fix versions

Affects versions

2.5.3 GA
2.5.3.1
2.5.0 GA
2.6.1
2.6.0 GA
3.0.4
3.0.0
3.0.1
3.1.0
3.0.2
3.1.1
2.5.1 GA
2.5.2 GA
3.0.3

Priority

Blocker