Error Executing Database Query.
|
|
[Macromedia][Oracle JDBC Driver][Oracle]ORA-04031: unable to allocate 19204 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")
|
| |
The error occurred in D:\webtvEduc\component\video.cfc: line 853
|
851 : SELECT DISTINCT VIDEO_ID,VIDEO_META_DESC,VIDEO_META_TITLE,VIDEO_TITRE_WEBTV,VIDEO_TITRE_LONG,VIDEO_TITRE_SERIE,VIDEO_TITRE_PROG,VIDEO_TITRE_SUJET,VIDEO_CHAPO,VIDEO_CLEF,VIDEO_NOTE_MOYENNE,VIDEO_DOCU_DUREE,VIDEO_URL_PUB,VIDEO_LIEN_URL_PUB,VIDEO_DATE_PUBLI,VIDEO_VU_TOUT,VIDEO_FRIENDLY_URL, VIDEO_FORCE_ID
852 : FROM T_VIDEO,T_VIDEO_PILIER,T_PILIER,T_VIDEO_DOCU
853 : WHERE VIDEO_ID = <cfqueryparam cfsqltype="cf_sql_integer" value="#ARGUMENTS.VideoID#">
854 : AND VIDEO_DOCU_VIDEO_ID=VIDEO_ID
855 : AND VIDEO_ID=VIDEO_PILIER_VIDEO_ID
|
|
| SQLSTATE |
HY000 |
| SQL |
SELECT DISTINCT VIDEO_ID,VIDEO_META_DESC,VIDEO_META_TITLE,VIDEO_TITRE_WEBTV,VIDEO_TITRE_LONG,VIDEO_TITRE_SERIE,VIDEO_TITRE_PROG,VIDEO_TITRE_SUJET,VIDEO_CHAPO,VIDEO_CLEF,VIDEO_NOTE_MOYENNE,VIDEO_DOCU_DUREE,VIDEO_URL_PUB,VIDEO_LIEN_URL_PUB,VIDEO_DATE_PUBLI,VIDEO_VU_TOUT,VIDEO_FRIENDLY_URL, VIDEO_FORCE_ID
FROM T_VIDEO,T_VIDEO_PILIER,T_PILIER,T_VIDEO_DOCU
WHERE VIDEO_ID = (param 1)
AND VIDEO_DOCU_VIDEO_ID=VIDEO_ID
AND VIDEO_ID=VIDEO_PILIER_VIDEO_ID
AND VIDEO_PILIER_PILIER_ID=PILIER_ID
|
| VENDORERRORCODE |
4031 |
| DATASOURCE |
WEBTVEDUC |
|
|
Resources:
|
| Browser |
ColdFusion |
| Remote Address |
89.107.169.36 |
| Referrer |
|
| Date/Time |
31-Jan-12 12:15 PM |
|
|
Stack Trace
|
at cfvideo2ecfc477777217$funcGETVIDEOBYID.runFunction(D:\webtvEduc\component\video.cfc:853) at cfvideoPlayer2ecfm1519356130.runPage(D:\webtvEduc\frontoffice\_generator\display\videoPlayer.cfm:9)
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-04031: unable to allocate 19204 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)
at macromedia.jdbc.oracle.OracleImplConnection.open(Unknown Source)
at macromedia.jdbc.base.BaseConnection.connect(Unknown Source)
at macromedia.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
at macromedia.jdbc.base.BaseConnection.open(Unknown Source)
at macromedia.jdbc.base.BaseDriver.connect(Unknown Source)
at macromedia.jdbc.MacromediaDriver.connect(Unknown Source)
at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:589)
at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
at java.lang.Thread.run(Thread.java:619)
|
|