Error: " Error in getting Phase costs in Project Handler - The imported spread data cannot be saved because the periods are not monthly or financial" When Attempting to Import Weekly Cost From P6 Into Prime Projects (Doc ID 2381563.1)

Last updated on JUNE 04, 2019

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Can weekly spread actual cost be brought in from P6 -> Gateway -> Prime?

EXPECTED BEHAVIOR
-----------------------
No this is an enhancement.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Configure Prime, Gatway and P6 to connect
2. Create a project in P6 with Actual cost spread
3. Attempt to sync weekly spreads to gateway
4. Error in Gateway

com.oracle.pgbu.pdi.provider.ProviderException:
at com.oracle.pgbu.pdi.primeProvider.project.PrimeProjectSaveStep.save(PrimeProjectSaveStep.java:73)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSaveStep(JobSimulator.java:823)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSaveSideSteps(JobSimulator.java:703)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeCompare(JobSimulator.java:595)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSingleFlow(JobSimulator.java:384)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.execute(JobSimulator.java:332)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.run(JobSimulator.java:194)
at com.oracle.pgbu.framework.akka.jobs.ServiceExecutorWrapperActor.wrappedReceive(ServiceExecutorWrapperActor.java:36)
at com.oracle.pgbu.framework.akka.metrics.UntypedActorWithMetrics.processMessage(UntypedActorWithMetrics.java:39)
at com.oracle.pgbu.framework.akka.metrics.UntypedActorWithMetrics.onReceive(UntypedActorWithMetrics.java:33)
at akka.actor.UntypedActor$$anonfun$receive$1.applyOrElse(UntypedActor.scala:165)
at akka.actor.Actor$class.aroundReceive(Actor.scala:497)
at akka.actor.UntypedActor.aroundReceive(UntypedActor.scala:95)
at akka.actor.ActorCell.receiveMessage(ActorCell.scala:526)
at akka.actor.ActorCell.invoke(ActorCell.scala:495)
at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:257)
at akka.dispatch.Mailbox.run(Mailbox.scala:224)
at akka.dispatch.Mailbox.exec(Mailbox.scala:234)
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
Original Exception:
com.oracle.pgbu.pdi.provider.ProviderException: Error in Project Flow - java.lang.Exception: com.oracle.pgbu.pdi.provider.ProviderException: Error in converting PDI Document to request operation of Project Handler - Error in getting Phase costs in Project Handler - The imported spread data cannot be saved because the periods are not monthly or financial.
at com.oracle.pgbu.pdi.primeProvider.project.PrimeProjectSaveStep.save(PrimeProjectSaveStep.java:61)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSaveStep(JobSimulator.java:823)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSaveSideSteps(JobSimulator.java:703)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeCompare(JobSimulator.java:595)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSingleFlow(JobSimulator.java:384)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.execute(JobSimulator.java:332)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.run(JobSimulator.java:194)
at com.oracle.pgbu.framework.akka.jobs.ServiceExecutorWrapperActor.wrappedReceive(ServiceExecutorWrapperActor.java:36)
at com.oracle.pgbu.framework.akka.metrics.UntypedActorWithMetrics.processMessage(UntypedActorWithMetrics.java:39)
at com.oracle.pgbu.framework.akka.metrics.UntypedActorWithMetrics.onReceive(UntypedActorWithMetrics.java:33)
at akka.actor.UntypedActor$$anonfun$receive$1.applyOrElse(UntypedActor.scala:165)
at akka.actor.Actor$class.aroundReceive(Actor.scala:497)
at akka.actor.UntypedActor.aroundReceive(UntypedActor.scala:95)
at akka.actor.ActorCell.receiveMessage(ActorCell.scala:526)
at akka.actor.ActorCell.invoke(ActorCell.scala:495)
at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:257)
at akka.dispatch.Mailbox.run(Mailbox.scala:224)
at akka.dispatch.Mailbox.exec(Mailbox.scala:234)
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
Original Exception:
java.lang.Exceptioncom.oracle.pgbu.pdi.provider.ProviderException:
at com.oracle.pgbu.pdi.primeProvider.project.PrimeProjectSaveStep.save(PrimeProjectSaveStep.java:73)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSaveStep(JobSimulator.java:823)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSaveSideSteps(JobSimulator.java:703)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeCompare(JobSimulator.java:595)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSingleFlow(JobSimulator.java:384)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.execute(JobSimulator.java:332)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.run(JobSimulator.java:194)
at com.oracle.pgbu.framework.akka.jobs.ServiceExecutorWrapperActor.wrappedReceive(ServiceExecutorWrapperActor.java:36)
at com.oracle.pgbu.framework.akka.metrics.UntypedActorWithMetrics.processMessage(UntypedActorWithMetrics.java:39)
at com.oracle.pgbu.framework.akka.metrics.UntypedActorWithMetrics.onReceive(UntypedActorWithMetrics.java:33)
at akka.actor.UntypedActor$$anonfun$receive$1.applyOrElse(UntypedActor.scala:165)
at akka.actor.Actor$class.aroundReceive(Actor.scala:497)
at akka.actor.UntypedActor.aroundReceive(UntypedActor.scala:95)
at akka.actor.ActorCell.receiveMessage(ActorCell.scala:526)
at akka.actor.ActorCell.invoke(ActorCell.scala:495)
at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:257)
at akka.dispatch.Mailbox.run(Mailbox.scala:224)
at akka.dispatch.Mailbox.exec(Mailbox.scala:234)
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
Original Exception:
com.oracle.pgbu.pdi.provider.ProviderException: Error in Project Flow - java.lang.Exception: com.oracle.pgbu.pdi.provider.ProviderException: Error in converting PDI Document to request operation of Project Handler - Error in getting Phase costs in Project Handler - The imported spread data cannot be saved because the periods are not monthly or financial.
at com.oracle.pgbu.pdi.primeProvider.project.PrimeProjectSaveStep.save(PrimeProjectSaveStep.java:61)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSaveStep(JobSimulator.java:823)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSaveSideSteps(JobSimulator.java:703)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeCompare(JobSimulator.java:595)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeSingleFlow(JobSimulator.java:384)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.execute(JobSimulator.java:332)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.run(JobSimulator.java:194)
at com.oracle.pgbu.framework.akka.jobs.ServiceExecutorWrapperActor.wrappedReceive(ServiceExecutorWrapperActor.java:36)
at com.oracle.pgbu.framework.akka.metrics.UntypedActorWithMetrics.processMessage(UntypedActorWithMetrics.java:39)
at com.oracle.pgbu.framework.akka.metrics.UntypedActorWithMetrics.onReceive(UntypedActorWithMetrics.java:33)
at akka.actor.UntypedActor$$anonfun$receive$1.applyOrElse(UntypedActor.scala:165)
at akka.actor.Actor$class.aroundReceive(Actor.scala:497)
at akka.actor.UntypedActor.aroundReceive(UntypedActor.scala:95)
at akka.actor.ActorCell.receiveMessage(ActorCell.scala:526)
at akka.actor.ActorCell.invoke(ActorCell.scala:495)
at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:257)
at akka.dispatch.Mailbox.run(Mailbox.scala:224)
at akka.dispatch.Mailbox.exec(Mailbox.scala:234)
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
Original Exception:
java.lang.Exception

Changes

Cause

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