Project (pm_project) table records not creating in sn_align_core_project table during insert

[Rajeshkumar2]

I have enabled the "Alignment integration" for pm_project table.

I have created the project in "pm_project" table, but there is no alignment record created in "sn_align_core_project" table. The alignment record was not created only during the insert operation of pm_project table. When I try to update the same pm_poject record, that time I can see alignment record was created successfully in "sn_align_core_project" table. But I wish to execute the same process during insert of pm_project table as well.

In PDI, Its worked as I expected, but same process is not worked in dev instance. Recently only I installed related plugins and I am very sure there is no customization enabled. And I cross verified all the BR's, Script includes and flows with PDI and my Dev instance. All looks similar. Anyone please help me to resolve this?

Execution table - pm_project

Alignment table - sn_align_core_project

[shiwan_agrawal]

@Rajeshkumar2 Try the following steps:

- Click on "Generate Default Mapping Configuration"

- Open the pm_project record from the "Table Maps" related list

- Run "Import" 

Sometimes, there might be some configuration missing and hence, "Generate Default Mapping Configurations" should help. Additionally, there are chances that creation of record may take sometime. Try the above mentioned steps and see if issue gets resolved.

If this solves your query, request you to mark this as "Accepted Solution".

-Shiwan Agrawal

[Rajeshkumar2]

Hello Shiwan, I just tried what u suggested. But still facing the same issues.

We should update at least one field in pm_project table after we crated the project. Then only this project gets created on sn_alignment_core_project table.

I checked the related business rules also, trigger condition is set to both insert and update operation like PDI.

[Namita Mishra]

Hi @Rajeshkumar2 ,

Hope you are doing fine.

I don't think you have missed any step \ configuration. I have seen this issue in some other instance as well and the only workaround is to update the project but that is not a solution.

Sorry, I do not have an answer for this.

I would suggest you to create a support case for this issue. Support folks are the right people to find the root cause.

Thank You!

Namita Mishra

[Rajeshkumar2]

Hello Namitha,

Thanks for your response. Sure I will raise a ticket.

Thanks