Hi we are right in the middel on testing / planing an upgrad from AX 3.0 (yes) via 2009 to 2012 R2..
Most of the Jobs in the AX 2012 data upgrade Center run fine and relativly fast .. except thos:
Split billing lines updateCostSalesLineFunders Proj 3198.35 min
Update PSAProjProposalProj table updatePSAProjProposalProjMajor Proj 4000 min
Did any one else have performace probs with both or one of them?
When looing at AOS and SQL both seem to be bored .. AOS somewhto 5-10% CPU, still mem free. DB Server 3 % CPU. mem ok, haveing about 1300 Batch requests per second. Not seeing any lock or heavy disk traffice..
any ideas welcome
I have not seen an upgrade with Projects. Until now only (re)new implementations. The reason why I anwer on this topic is that I have seen a strange performance issue due to some checks in the project postings when you have multiple funding sources per project.
You issue sound like this same experience I had before.
You can check if the upgrade results in lager number of funding sources in stead of one or some. I don't know your current setup. In many scenario's there will be just one funding source.
Did you make any progress with this issue?
We are having the same problem with the updatePSAProjProposalProjMajor job taking many days to complete.
I am considering splitting the job into multiple batch tasks each processing a subset of the ProjProposalJour records (and then run the jobs in parallel). Do you have any thoughts on this approach?
sorry to say.. nope .. is still converting ! (since Sep. 10th) ..
I don't dare so far to cancel the Job, as it is still creating some new records. When i look at AOS Server, it seems to do something ( ~ 7 % cpu) the DB Server is more than bored (no siginficant CPU, not Storage Action) just ~ 1500 Batch requests per sec.
We just started a perdormanc Analysis.. (with our developers)
maybe paralell could be a solution as it not seems to use many ressources .
Any other ideas?
I laughed at that, but actually it's not funny when you consider the system is unavailable to users when this job runs
We've only started to think of a solution but if we have any success I'll let you know (I think the problem lies with the row-by-row processing which uses the ProjTrans wrapper classes)
It's comforting to know we're not the only ones with this problem!
thanx.. well we have data of 13 (!!!!) years to Transfer!
And currently the Job has created ~1.2 mio (!!) records in PSAProjProposal...
Just wondering if anyone has worked out how to speed this up? I stopped the upgrade process after waiting 2 days for this to finish.
Even then PSAProjProposalProj table had no records inserted.
I'm upgrading from RTM to R2 btw - not from 2009.
well this one is still converting (since Sep 10th) .. i let it run just ..
We did split up for the next test in multiple batchjobs.. will run it tonight ..
we are upgrading from AX4 to AX2012R2 CU7.
Batch job "updateCostSalesLineFunders" is running for days and we do not have a clue why...
Would like to check back with you if there are any news you can share!
Did you ever find a solution to this long running job ? I know there is a hot fix from Microsoft for this, however i'm finding it still runs for a long time.
How did you get past this?
as mentioned above we did split the whole job und thousands ( yes) of single jobs. And did run them on parallel.. then it took a day or so .. and the server was nearly on fire ;)