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

[Namita Mishra]

Sounds good @Rajeshkumar2 .

Please also share the learning with the community once you get the solution \ root cause from support. That would be helpful.

Have a Great Day!

Namita Mishra

[David Olson]

Hi @Rajeshkumar2,

Out of curiosity, have you checked the Strategic Planning integration errors (All->Strategic Planning->Integrations->ServiceNow Internal->Integration Errors (related list/tab)? In our instance, there are scenarios where projects aren't integrated from the execution record ([pm_project]) to the alignment record ([sn_align_core_project]) when, for example, the approved start/end dates have been updated incorrectly, such as an end date occurring before a start date.

While these types of errors shouldn't occur, sometimes they do, and the broader point is, if you haven't already, consider checking for integration errors associated with the projects that didn't integrate to look for clues as to why that's the case, especially in the Message field that often include the names of business rules that failed and generated the errors, for instance.

I hope this helps.

David

[Rajeshkumar2]

Hello David,

Thanks for the response. But already I have checked the integration errors. There is no such error created for pm_project table. All looks similar like PDI, but still record getting created while update not during insert.

Thanks

[Ed_SNOWden]

Hello, i have a problem in DEV Enviroment to auto generate the dafault Mapping Configurations. Error Message "The map configurations could not be created" (Screenshot 1). In PDI it works fine.
Even can't create Table Maps by my own for pm_project or demand list, cant choose the alignment tables for the planning items (Screenshot 2). sn_align_core_project and sn_align_core_demand Table is installed.

Could anybody give an advice?