XMLPost Failing To Upload Asset with Error "ORA-00933: SQL command not properly ended" (Doc ID 1902356.1)

Last updated on MARCH 13, 2023

Applies to:

Symptoms

XMLPost using the RemoteContentPost element fails to create an asset, with these errors in the futuretense.txt log file:

2014-06-04 09:16:26.319][CS.DB][ERROR] SQLException executing query: SELECT t2.id AS assetid,t3.assettypename AS assettypename,t2.attributetype AS attributetype,t3.charsetname AS charsetname,t3.contenttype AS contenttype,t3.deptype AS deptype,t2.description AS description,t3.diffconv AS diffconv,t3.diffmethod AS diffmethod,t3.diffpres AS diffpres,t3.editing AS editing,t3.embedtype AS embedtype,t3.enginename AS enginename,t3.externalcolumn AS externalcolumn,t3.externalid AS externalid,t3.externaltable AS externaltable,t2.name AS name,t1.ordinal AS ordinal,t1.requiredflag AS required,t3.searchconv AS searchconv,t3.storage AS storage,t3.type AS type,t3.upload AS upload,t3.valuestyle AS valuestyle FROM SPComDocument_A t2,SPComDocument_A_Extension t3,SPComDocument_CD_TAttr t1 WHERE t2.id=t3.ownerid AND t1.ownerid=Variables.flexassets:flextemplateid AND t1.attributeid=t2.id ORDER BY ordinal ASC
java.sql.SQLException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
...

[2014-06-04 09:16:26.324][CS.DB][ERROR] Failed to execute query SELECT t2.id AS assetid,t3.assettypename AS assettypename,t2.attributetype AS attributetype,t3.charsetname AS charsetname,t3.contenttype AS contenttype,t3.deptype AS deptype,t2.description AS description,t3.diffconv AS diffconv,t3.diffmethod AS diffmethod,t3.diffpres AS diffpres,t3.editing AS editing,t3.embedtype AS embedtype,t3.enginename AS enginename,t3.externalcolumn AS externalcolumn,t3.externalid AS externalid,t3.externaltable AS externaltable,t2.name AS name,t1.ordinal AS ordinal,t1.requiredflag AS required,t3.searchconv AS searchconv,t3.storage AS storage,t3.type AS type,t3.upload AS upload,t3.valuestyle AS valuestyle FROM SPComDocument_A t2,SPComDocument_A_Extension t3,SPComDocument_CD_TAttr t1 WHERE t2.id=t3.ownerid AND t1.ownerid=Variables.flexassets:flextemplateid AND t1.attributeid=t2.id ORDER BY ordinal ASC for query _DUMMYRESULT_
[2014-06-04 09:16:26.326][CS][ERROR] Exception in FLEXTEMPLATES.GETATTRIBUTEINFO endTag() in tag com.openmarket.gator.seed.TemplateAssetManager in page 'OpenMarket/Xcelerate/Actions/RemoteContentPost' in element 'OpenMarket/Gator/FlexibleAssets/Common/RemotePost' errno: -105 errdetail: 0
com.openmarket.basic.interfaces.AssetException: SQL statement 'SELECT t2.id AS assetid,t3.assettypename AS assettypename,t2.attributetype AS attributetype,t3.charsetname AS charsetname,t3.contenttype AS contenttype,t3.deptype AS deptype,t2.description AS description,t3.diffconv AS diffconv,t3.diffmethod AS diffmethod,t3.diffpres AS diffpres,t3.editing AS editing,t3.embedtype AS embedtype,t3.enginename AS enginename,t3.externalcolumn AS externalcolumn,t3.externalid AS externalid,t3.externaltable AS externaltable,t2.name AS name,t1.ordinal AS ordinal,t1.requiredflag AS required,t3.searchconv AS searchconv,t3.storage AS storage,t3.type AS type,t3.upload AS upload,t3.valuestyle AS valuestyle FROM SPComDocument_A t2,SPComDocument_A_Extension t3,SPComDocument_CD_TAttr t1 WHERE t2.id=t3.ownerid AND t1.ownerid=Variables.flexassets:flextemplateid AND t1.attributeid=t2.id ORDER BY ordinal ASC' failed; -105:
at com.openmarket.basic.querylist.QueryList.getResults(QueryList.java:133)
at com.openmarket.basic.querylist.QueryList.getResults(QueryList.java:69)
at com.openmarket.gator.common.TemplateAttributes.getAttributeInfo(TemplateAttributes.java:362)
at com.openmarket.gator.flextemplates.FlexTemplateManager.getAttributeInfo(FlexTemplateManager.java:229)
at com.openmarket.gator.seed.TemplateAssetManager.worker(TemplateAssetManager.java:81)
...

[2014-06-04 09:16:26.379][CS.REQUEST][ERROR] Exception including resource /jsp/cs_deployed/OpenMarket/Gator/FlexibleAssets/Common/AssetGather.jsp
java.lang.NullPointerException
at jsp_servlet._jsp._cs_deployed._openmarket._gator._flexibleassets._common.__assetgather._jspService(__assetgather.java:727)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)

[2014-06-04 09:16:26.384][CS.JSP][ERROR] Failure executing JSPOpenMarket/Gator/FlexibleAssets/Common/AssetGather Exception calling include: page:/jsp/cs_deployed/OpenMarket/Gator/FlexibleAssets/Common/AssetGather.jsp
java.lang.NullPointerException tossed:null

[2014-06-04 09:16:26.385][CS][ERROR] Unable to evaluate element OpenMarket/Gator/FlexibleAssets/Common/AssetGather
[2014-06-04 09:16:26.386][CS.XML][ERROR] Failed to run template:OpenMarket/Gator/FlexibleAssets/Common/RemotePost
[2014-06-04 09:16:26.386][CS][ERROR] Unable to evaluate element OpenMarket/Gator/FlexibleAssets/Common/RemotePost
[2014-06-04 09:16:26.386][CS.XML][ERROR] Failed to run template:OpenMarket/Gator/FlexibleAssets/FlexAssets/PreUpdate
[2014-06-04 09:16:26.387][CS][ERROR] Unable to evaluate element OpenMarket/Gator/FlexibleAssets/FlexAssets/PreUpdate
[2014-06-04 09:16:26.387][CS.XML][ERROR] Failed to run template:OpenMarket/Xcelerate/AssetType/SPComDocument_C/PreUpdate
[2014-06-04 09:16:26.388][CS][ERROR] Unable to evaluate element OpenMarket/Xcelerate/AssetType/SPComDocument_C/PreUpdate
[2014-06-04 09:16:26.388][CS.XML][ERROR] Failed to run template:OpenMarket/Xcelerate/Actions/RemoteContentPost

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.