BCC | Unable to complete accept production deployment

[sudheer devarasetty]

Hi All,

I am getting the below exception while accepting production deployment.Attached screen shot is the error

 statusCode: 500
      message: QUERY_EXCEPTION_MESSAGE: RQL query: id = ?0, Args: ?0=prc699001 
      requestURI: /PubPortlets/html/ProjectsPortlet/actionNote.jsp
      servletName: jsp
      exceptionType: class javax.ejb.EJBException

When i verified my backend server logs Below is the exception

18:02:13,572 ERROR [JTDataSource] Unable to connect to data source because of SQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: ad15d04:c569:5233cff1:2ec96 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: ad15d04:c569:5233cff1:2ec96 status: ActionStatus.ABORT_ONLY >)
18:02:13,573 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
javax.ejb.EJBException: QUERY_EXCEPTION_MESSAGE: RQL query: id = ?0, Args: ?0=prc699001
        at atg.repository.tojava.runtime.RJSupport.executeRqlStatementForOne(RJSupport.java:1132)
        at atg.epub.project._ProcessHome_ReposImpl.findById(_ProcessHome_ReposImpl.java:68)
        at atg.epub.servlet.FireWorkflowOutcomeFormHandler.addHistory(FireWorkflowOutcomeFormHandler.java:354)

But when i verified my DB Connection of pub schema,switching A and B  the connections are active. Any suggestions much appreciated?

Thanks,

Sudheer

[Raju]

Check your log, you may have got some other exception before this one, so the transaction error came in.

--
--
You received this message because you are subscribed to the Google Groups "ATG_Tech" group.
To post to this group, send email to atg_...@googlegroups.com
To unsubscribe from this group, send email to atg_tech-u...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/atg_tech?hl=en
---
You received this message because you are subscribed to the Google Groups "ATG_Tech" group.
To unsubscribe from this group and stop receiving emails from it, send an email to atg_tech+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--

Thanks and Regards

 Raju .G

[sudheer devarasetty]

Raju,

I am getting the below exception which is null pointer

:18:41,693 ERROR [WorkflowProcessManager] Error while processing individual event message of type atg.workflow.TaskOutcome; rolling back the transaction
va.lang.NullPointerException
      at atg.epub.workflow.process.action.ValidateProjectDeployed.executeAction(ValidateProjectDeployed.java:106)
      at atg.process.action.ActionImpl.execute(ActionImpl.java:419)
      at atg.process.ProcessManagerService.executeAction(ProcessManagerService.java:14001)
      at atg.process.ProcessManagerService.takeIndividualTransition(ProcessManagerService.java:13408)
      at atg.process.ProcessManagerService.takeIndividualTransition(ProcessManagerService.java:13453)
      at atg.process.ProcessManagerService.receiveIndividualEventMessage(ProcessManagerService.java:11878)
      at atg.process.ProcessManagerService.receiveIndividualEventMessage(ProcessManagerService.java:11573)
      at atg.process.ProcessManagerService.receiveMessage(ProcessManagerService.java:11383)
      at atg.process.ProcessManagerService.receiveMessage(ProcessManagerService.java:11341)
      at atg.dms.patchbay.ElementManager.deliverMessage(ElementManager.java:316)
      at atg.dms.patchbay.InputPort.onMessage(InputPort.java:190)
      at atg.dms.patchbay.InputDestination.onMessage(InputDestination.java:397)
      at atg.dms.local.MessageConsumerImpl.deliverMessage(MessageConsumerImpl.java:296)
      at atg.dms.local.TopicImpl.deliverToRecipients(TopicImpl.java:113)
      at atg.dms.local.DestinationImpl.deliverMessage(DestinationImpl.java:260)
      at atg.dms.local.TopicPublisherImpl.publish(TopicPublisherImpl.java:163)
      at atg.dms.patchbay.OutputDestination.sendMessage(OutputDestination.java:203)

Thanks,
Sudheer