Hello
I have an issue with a custom projection entity
When I try to publish my projection, I got compilation error :
Here is the detail of error :
ProjectionConfigHandling/ProjectionConfigDetail (server error)
Database error occurred. Contact administrator.
Error details: [{"code":24344,"message":"ORA-24344: success with compilation error"}]
Server stack trace error(s):
Failed to execute the generated database statement
ORA-24344: success with compilation error
ORA-06512: at "IFSAPP.PROJECTION_CONFIG_API", line 1201
ORA-06512: at "IFSAPP.CUSTOM_PROJECTION_UTIL_API", line 154
ORA-06512: at "IFSAPP.CUSTOM_PROJECTION_UTIL_API", line 252
ORA-06512: at "IFSAPP.CUSTOM_PROJECTION_UTIL_API", line 118
ORA-06512: at "IFSAPP.CUSTOM_PROJECTION_UTIL_API", line 72
ORA-06512: at "IFSAPP.PROJECTION_CONFIG_API", line 1192
ORA-06512: at "IFSAPP.PROJECTION_CONFIG_HANDLING_SVC", line 7465
ORA-06512: at "IFSAPP.PROJECTION_CONFIG_HANDLING_SVC", line 1721
ORA-06512: at line 2
ORA-24344: success with compilation error
ORA-06512: at "IFSAPP.PROJECTION_CONFIG_API", line 1201
ORA-06512: at "IFSAPP.CUSTOM_PROJECTION_UTIL_API", line 154
ORA-06512: at "IFSAPP.CUSTOM_PROJECTION_UTIL_API", line 252
ORA-06512: at "IFSAPP.CUSTOM_PROJECTION_UTIL_API", line 118
ORA-06512: at "IFSAPP.CUSTOM_PROJECTION_UTIL_API", line 72
ORA-06512: at "IFSAPP.PROJECTION_CONFIG_API", line 1192
ORA-06512: at "IFSAPP.PROJECTION_CONFIG_HANDLING_SVC", line 7465
ORA-06512: at "IFSAPP.PROJECTION_CONFIG_HANDLING_SVC", line 1721
ORA-06512: at line 2
I initially had issue with the entity (RecUserOdbc) because when you generate the projection of custom entity, you can’t customize projection (i had to add a custom action to the projection).
So I unchecked the “generate projection” on the entity page to then create a custom projection for the custom entity.
But i had an error saying there already was a projection for the custom entity.
I refreshed cache.
Nothing changed.
I deleted the projection from the database, nothing changed.
I deleted the entity from the database and remade it.
Still issue when creating projection, so I decided to create a projection with another name. It worked.
I was then able to create the page of the entity with element displayed (list to create ODBC user).
When I tried to add the custom action on the projection, I run into projection compilation issue you can see above.
Then the ifs app still had the projection in reference even after.
Here is my projection :
Here is my entity :
What I tried is to remove the custom action from the projection but I stilll can not compile the projection when publishing (before adding the custom action, everything was working fine).
I also tried to create a page for “custom administration tasks” with a command executeaction but the button doesnt display on the custom administration page so I don’t know what to do.
Goal of the action is to synchronise IFS role system with oracle role system so if I use event for this there will be tons of background task when adding projection to permissionset.
This is why I chosen a global synchronisation between IFS and ORACLE permissions.