1 Reply Latest reply on Sep 16, 2019 6:43 AM by rodrigo barcat

    Issue on Spoon Job, shows error as "Unable to save Job in repository, database rollback performed" while saving the job

    Nilesh Sawant
      Share This:

      Need some assistance on Spoon issue, Customer has upgraded to 19.02 Remedy Helix Env

       

      Through Spoon “GT DB CMDB AI Job isn't working” when investigated found that the path for the values on Parameter tab was incorrect.

       

      Tried setting the path correctly and saved, however will saving the job it show below error.

       

      Could you please advise what should we check further and save the job

       

       

      • org.pentaho.di.core.exception.KettleException:

      Unable to save Job in repository, database rollback performed.

      at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113)

      at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:70)

      at com.bmc.arsys.pdi.repository.ARPdiRepository.save (null:-1)

      at com.bmc.arsys.pdi.repository.ARPdiRepository.save (null:-1)

      at com.bmc.arsys.pdi.repository.delegates.ARPdiRepositoryJobDelegate.saveJob (null:-1)

      at com.bmc.arsys.pdi.repository.delegates.ARPdiRepositoryJobDelegate.saveJobHopMeta (null:-1)

      at com.bmc.arsys.pdi.repository.delegates.ARPdiRepositoryJobDelegate.insertJobHop (null:-1)

      at com.bmc.arsys.pdi.repository.data.JobHop.<init> (null:-1)

      at com.bmc.arsys.pdi.repository.data.JobHop.loadEntry (null:-1)

       

       

      Unable to save Job in repository, database rollback performed.

      at org.eclipse.jface.operation.ModalContext$ModalContextThread.run (ModalContext.java:113)

      at org.pentaho.di.ui.spoon.dialog.SaveProgressDialog$1.run (SaveProgressDialog.java:70)

      at com.bmc.arsys.pdi.repository.ARPdiRepository.save (null:-1)

      at com.bmc.arsys.pdi.repository.ARPdiRepository.save (null:-1)

      at com.bmc.arsys.pdi.repository.delegates.ARPdiRepositoryJobDelegate.saveJob (null:-1)

      at com.bmc.arsys.pdi.repository.delegates.ARPdiRepositoryJobDelegate.saveJobHopMeta (null:-1)

      at com.bmc.arsys.pdi.repository.delegates.ARPdiRepositoryJobDelegate.insertJobHop (null:-1)

      at com.bmc.arsys.pdi.repository.data.JobHop.<init> (null:-1)

      at com.bmc.arsys.pdi.repository.data.JobHop.loadEntry (null:-1)