Failed to promote user groups with users with error null in 'RelativePath'

[former_member403878]

Greetings.

I currently had run into this error when try to promote certain groups with users or no users at all while using the LCM CLI to execute live to live transportation.

Tried the method in kba 2052001 but did not work.

Error- While trying to invoke the method java.lang.string.lastIndexOf(int) of a null object loaded from local variable 'relative path'

The query is: exportQuery1= SELECT TOP 10000 static, relationships, SI_PARENT_FOLDER_CUID, SI_OWNER, SI_PATH FROM CI_INFOOBJECTS,CI_APPOBJECTS,CI_SYSTEMOBJECTS WHERE (SI_NAME='Academic' AND SI_KIND='UserGroup') OR ANCESTORS("SI_NAME='USERGROUP-USER'", "SI_NAME='Academic'") OR DESCENDANTS("SI_NAME='USERGROUP-USER'", "SI_NAME='Academic'")

When trying to investigate the pattern of those folders, some has the administrator account which is the account performing the promotion in it. The others are pure groups only with no users or has a long list of users.

Tried to exclude the administrator user using the following code with no avail.

exportQuery1= SELECT TOP 10000 static, relationships, SI_PARENT_FOLDER_CUID, SI_OWNER, SI_PATH FROM CI_INFOOBJECTS,CI_APPOBJECTS,CI_SYSTEMOBJECTS WHERE (SI_NAME='Administrators' AND SI_KIND='UserGroup') and (SI_NAME not in ('Administrator') AND SI_KIND='User') OR ANCESTORS("SI_NAME='USERGROUP-USER'", "SI_NAME='Administrators'") OR DESCENDANTS("SI_NAME='USERGROUP-USER'", "SI_NAME='Administrators'")

The reason that we did not use the web portal to export is that we cannot select users as dependency at all.

It will clear out the whole group selections if we try so and the promote job cannot be executed at all with a 500 server error with not explanation.

Much appreciated if someone could shed some lights on how to find a solution for this issue.