Untitled

From Unique Motmot, 4 Years ago, written in Plain Text.

A PHP Error was encountered

Severity: Warning

Message: sizeof(): Parameter must be an array or an object that implements Countable

Filename: helpers/language_helper.php

Line Number: 81

Backtrace:

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/helpers/language_helper.php
Line: 81
Function: _error_handler

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/themes/geocities/views/view/view.php
Line: 24
Function: random_expire_msg

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/core/MY_Loader.php
Line: 173
Function: include

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/core/MY_Loader.php
Line: 43
Function: _ci_load

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/controllers/Main.php
Line: 700
Function: view

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/index.php
Line: 315
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Trying to access array offset on value of type null

Filename: helpers/language_helper.php

Line Number: 81

Backtrace:

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/helpers/language_helper.php
Line: 81
Function: _error_handler

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/themes/geocities/views/view/view.php
Line: 24
Function: random_expire_msg

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/core/MY_Loader.php
Line: 173
Function: include

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/core/MY_Loader.php
Line: 43
Function: _ci_load

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/controllers/Main.php
Line: 700
Function: view

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/index.php
Line: 315
Function: require_once

This paste will in 1 Second.

URL http://geopaste.scratchbook.ch/view/1d973553

Embed

Download Paste or View Raw

<exception errorId="null_537_11304026820200616" appVersion="13.0.0">

<exceptionContext><![CDATA[com.pearson.ph.access.services.UploadStudentsInput@2d74478d]]></exceptionContext>

<message><![CDATA[From createJobDetailsForBulkUpload]]></message>

<rootCause><![CDATA[ERROR: value too long for type character varying(3000)

Where: PL/pgSQL function ncs_domain.registration_pkg_prc_insert_job_data(ncs_domain.blk_upload_students_arr[],character varying,numeric,numeric,character varying,character varying) line 12 at assignment

SQL statement "CALL ncs_domain.registration_pkg_prc_insert_job_data(Io_Student_Arr, p_Log_Id, l_Trans_Id, l_Customer_Id, l_Createdby_Oid, l_Owner_Orgunit_Oid)"

PL/pgSQL function ncs_domain.registration_pkg_prc_rum_create_job(ncs_domain.blk_upload_students_arr[],character varying,character varying,character varying,refcursor,numeric,numeric,numeric,numeric) line 247 at CALL]]></rootCause>

<stackTrace><![CDATA[ERROR_ID=null_537_11304026820200616

com.pearson.commonsys.exception.SNPSysException: From createJobDetailsForBulkUpload

at com.pearson.ph.access.services.RegistrationServiceImpl.createJobDetailsForBulkUpload(RegistrationServiceImpl.java:4086)

at com.pearson.ph.itext.jmsmdb.registration.UploadStudentsAdvancedForMigratedDistMessageBean.createJobDetailsForBulkUpload(UploadStudentsAdvancedForMigratedDistMessageBean.java:197)

at com.pearson.ph.itext.jmsmdb.registration.UploadStudentsAdvancedForMigratedDistMessageBean.onMessage(UploadStudentsAdvancedForMigratedDistMessageBean.java:73)

at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509)

at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:79)

at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:89)

at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:102)

at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:40)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53)

at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:185)

at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:364)

at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:144)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509)

at org.jboss.weld.module.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:81)

at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:89)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:47)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation(StartupAwaitInterceptor.java:22)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.deployment.processors.EjbSuspendInterceptor.processInvocation(EjbSuspendInterceptor.java:57)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:67)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.as.ejb3.component.messagedriven.MessageDrivenComponentDescription$5$1.processInvocation(MessageDrivenComponentDescription.java:252)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:60)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:438)

at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:627)

at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:57)

at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53)

at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:198)

at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185)

at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:81)

at com.pearson.ph.itext.jmsmdb.registration.UploadStudentsAdvancedForMigratedDistMessageBean$$$view20.onMessage(Unknown Source)

at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.doInvoke(MessageEndpointInvocationHandler.java:139)

at org.jboss.as.ejb3.inflow.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:73)

at com.pearson.ph.itext.jmsmdb.registration.UploadStudentsAdvancedForMigratedDistMessageBean$$$endpoint1.onMessage(Unknown Source)

at org.apache.activemq.artemis.ra.inflow.ActiveMQMessageHandler.onMessage(ActiveMQMessageHandler.java:319)

at org.apache.activemq.artemis.core.client.impl.ClientConsumerImpl.callOnMessage(ClientConsumerImpl.java:1031)

at org.apache.activemq.artemis.core.client.impl.ClientConsumerImpl.access$400(ClientConsumerImpl.java:50)

at org.apache.activemq.artemis.core.client.impl.ClientConsumerImpl$Runner.run(ClientConsumerImpl.java:1154)

at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:42)

at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:31)

at org.apache.activemq.artemis.utils.actors.ProcessorBase.executePendingTasks(ProcessorBase.java:66)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at org.apache.activemq.artemis.utils.ActiveMQThreadFactory$1.run(ActiveMQThreadFactory.java:118)

Caused by: com.pearson.commonsys.app.persistence.DataAccessException: SQL exception while creating job details

at com.pearson.ph.access.persistence.dao.RegistrationDAOImpl.createJobDetailsForBulkUpload(RegistrationDAOImpl.java:2297)

at com.pearson.ph.access.services.RegistrationServiceImpl.createJobDetailsForBulkUpload(RegistrationServiceImpl.java:4078)

... 79 more

Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(3000)

Where: PL/pgSQL function ncs_domain.registration_pkg_prc_insert_job_data(ncs_domain.blk_upload_students_arr[],character varying,numeric,numeric,character varying,character varying) line 12 at assignment

SQL statement "CALL ncs_domain.registration_pkg_prc_insert_job_data(Io_Student_Arr, p_Log_Id, l_Trans_Id, l_Customer_Id, l_Createdby_Oid, l_Owner_Orgunit_Oid)"

PL/pgSQL function ncs_domain.registration_pkg_prc_rum_create_job(ncs_domain.blk_upload_students_arr[],character varying,character varying,character varying,refcursor,numeric,numeric,numeric,numeric) line 247 at CALL

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2505)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2241)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310)

at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:368)

at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:158)

at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:77)

at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:147)

at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442)

at com.pearson.ph.access.persistence.dao.RegistrationDAOImpl.createJobDetailsForBulkUpload(RegistrationDAOImpl.java:2283)

... 80 more

]]></stackTrace>

</exception>

Author

Title

Language

Your paste - Paste your paste here

&lt;exception errorId=&quot;null_537_11304026820200616&quot; appVersion=&quot;13.0.0&quot;&gt;
&lt;exceptionContext&gt;&lt;![CDATA[com.pearson.ph.access.services.UploadStudentsInput@2d74478d]]&gt;&lt;/exceptionContext&gt;
&lt;message&gt;&lt;![CDATA[From createJobDetailsForBulkUpload]]&gt;&lt;/message&gt;
&lt;rootCause&gt;&lt;![CDATA[ERROR: value too long for type character varying(3000)
  Where: PL/pgSQL function ncs_domain.registration_pkg_prc_insert_job_data(ncs_domain.blk_upload_students_arr[],character varying,numeric,numeric,character varying,character varying) line 12 at assignment
SQL statement &quot;CALL ncs_domain.registration_pkg_prc_insert_job_data(Io_Student_Arr, p_Log_Id, l_Trans_Id, l_Customer_Id, l_Createdby_Oid, l_Owner_Orgunit_Oid)&quot;
PL/pgSQL function ncs_domain.registration_pkg_prc_rum_create_job(ncs_domain.blk_upload_students_arr[],character varying,character varying,character varying,refcursor,numeric,numeric,numeric,numeric) line 247 at CALL]]&gt;&lt;/rootCause&gt;
&lt;stackTrace&gt;&lt;![CDATA[ERROR_ID=null_537_11304026820200616
com.pearson.commonsys.exception.SNPSysException: From createJobDetailsForBulkUpload
	at com.pearson.ph.access.services.RegistrationServiceImpl.createJobDetailsForBulkUpload(RegistrationServiceImpl.java:4086)
	at com.pearson.ph.itext.jmsmdb.registration.UploadStudentsAdvancedForMigratedDistMessageBean.createJobDetailsForBulkUpload(UploadStudentsAdvancedForMigratedDistMessageBean.java:197)
	at com.pearson.ph.itext.jmsmdb.registration.UploadStudentsAdvancedForMigratedDistMessageBean.onMessage(UploadStudentsAdvancedForMigratedDistMessageBean.java:73)
	at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509)
	at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:79)
	at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:89)
	at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:102)
	at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:40)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53)
	at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:185)
	at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:364)
	at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:144)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509)
	at org.jboss.weld.module.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:81)
	at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:89)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:47)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation(StartupAwaitInterceptor.java:22)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.deployment.processors.EjbSuspendInterceptor.processInvocation(EjbSuspendInterceptor.java:57)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:67)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.as.ejb3.component.messagedriven.MessageDrivenComponentDescription$5$1.processInvocation(MessageDrivenComponentDescription.java:252)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:60)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:438)
	at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:627)
	at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:57)
	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53)
	at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:198)
	at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185)
	at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:81)
	at com.pearson.ph.itext.jmsmdb.registration.UploadStudentsAdvancedForMigratedDistMessageBean$$$view20.onMessage(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.doInvoke(MessageEndpointInvocationHandler.java:139)
	at org.jboss.as.ejb3.inflow.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:73)
	at com.pearson.ph.itext.jmsmdb.registration.UploadStudentsAdvancedForMigratedDistMessageBean$$$endpoint1.onMessage(Unknown Source)
	at org.apache.activemq.artemis.ra.inflow.ActiveMQMessageHandler.onMessage(ActiveMQMessageHandler.java:319)
	at org.apache.activemq.artemis.core.client.impl.ClientConsumerImpl.callOnMessage(ClientConsumerImpl.java:1031)
	at org.apache.activemq.artemis.core.client.impl.ClientConsumerImpl.access$400(ClientConsumerImpl.java:50)
	at org.apache.activemq.artemis.core.client.impl.ClientConsumerImpl$Runner.run(ClientConsumerImpl.java:1154)
	at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:42)
	at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:31)
	at org.apache.activemq.artemis.utils.actors.ProcessorBase.executePendingTasks(ProcessorBase.java:66)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.activemq.artemis.utils.ActiveMQThreadFactory$1.run(ActiveMQThreadFactory.java:118)
Caused by: com.pearson.commonsys.app.persistence.DataAccessException: SQL exception while creating job details 
	at com.pearson.ph.access.persistence.dao.RegistrationDAOImpl.createJobDetailsForBulkUpload(RegistrationDAOImpl.java:2297)
	at com.pearson.ph.access.services.RegistrationServiceImpl.createJobDetailsForBulkUpload(RegistrationServiceImpl.java:4078)
	... 79 more
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(3000)
  Where: PL/pgSQL function ncs_domain.registration_pkg_prc_insert_job_data(ncs_domain.blk_upload_students_arr[],character varying,numeric,numeric,character varying,character varying) line 12 at assignment
SQL statement &quot;CALL ncs_domain.registration_pkg_prc_insert_job_data(Io_Student_Arr, p_Log_Id, l_Trans_Id, l_Customer_Id, l_Createdby_Oid, l_Owner_Orgunit_Oid)&quot;
PL/pgSQL function ncs_domain.registration_pkg_prc_rum_create_job(ncs_domain.blk_upload_students_arr[],character varying,character varying,character varying,refcursor,numeric,numeric,numeric,numeric) line 247 at CALL
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2505)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2241)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:368)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:158)
	at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:77)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:147)
	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442)
	at com.pearson.ph.access.persistence.dao.RegistrationDAOImpl.createJobDetailsForBulkUpload(RegistrationDAOImpl.java:2283)
	... 80 more
]]&gt;&lt;/stackTrace&gt;
&lt;/exception&gt;

Create Shorturl - Create a shorter url that redirects to your paste?

Private - Private paste aren't shown in recent listings.

Delete After - When should we delete your paste?

A PHP Error was encountered

A PHP Error was encountered

Reply to "Untitled"