CLI for Promotion Management in BI 4.1

[Former Member]

Hi Experts,

I am unable to promote User/ User Groups via Command Line Interface for promotion Management in BI 4.1 SP04.

Running this on the windows enivornment.

Query used in Properties File for Promotion:

SELECT static, relationships, SI_PARENT_FOLDER_CUID, SI_OWNER, SI_PATH FROM

ci_infoobjects,ci_appobjects,ci_systemobjects WHERE

DESCENDENTS("SI_NAME='UserGroup-User'","SI_NAME='Test Group' AND SI_KIND='UserGroup'")

Requirement is to promote a single group via Command line.

Error message received is:

com.crystaldecisions.sdk.exception.sdk.exception.SDKServerException:Not a valid query.<FWB 00025>

The server Supplied the following details:OCA_Abuse exception 7683 at [.\infostore.cpp..5967] 48163 {}

Error generating parse tree

Any clue will be highly appreciated.

Thanks in advance.

Regards

Sumeet

[former_member185603 · Accepted solution]

Check this kb- Looks like there is quotation marks issue.

1886588  - Error not a valid query (FWB 00025) returned by LCM Command-line Interface script

[Former Member · Accepted solution]

Hi jawahar,

Thank you so much for your reply

This is the command used:

E:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0

\win64_x64\scripts>lcm_cli.bat -lcmproperty c:\Test.Properties

Regards

Sumeet Zalpuri

[former_member185603 · Accepted solution]

can you post your script? Check if any quotation marks in script.

[Former Member · Accepted solution]

Hi Jawahar,

Are you referring to CLI Property File.

Regards

Sumeet

[former_member185603 · Accepted solution]

Yes

[Former Member · Accepted solution]

#action=export
#exportLocation=C:/work.lcmbiar
action=promote
#importLocation=C:/lcm1.lcmbiar

LCM_CMS=<<Server:6400>>
LCM_userName=Administrator
LCM_password=<Password>
LCM_authentication=SecEnterprise

Source_CMS=<<Server:6400>>
Source_userName=Administrator
Source_password=<Password>
Source_authentication=SecEnterprise

Destination_CMS=<<Server:6400>>
Destination_userName=Administrator
Destination_password=<Password>
Destination_authentication=SecEnterprise

exportQueriesTotal=1
exportQuery1=SELECT TOP 100000 static, relationships, SI_PARENT_FOLDER_CUID, SI_OWNER, SI_PATH FROM
ci_infoobjects,ci_appobjects,ci_systemobjects where DESCENDENTS("si_name='Folder Hierarchy'","si_name='CLI Test'
and si_kind='Folder'")

exportDependencies=false
includeSecurity=false

stacktrace=false
consolelog=false

[former_member185603 · Accepted solution]

Are you doing export or Promote? If you are doing export, why the destination CMS information in the properties file?

And also i see you are missing lcmproperty which is mandatory. Refer the admin guide for more information.

You can remove all these entries, which anyway it is default values =False. it is not necessary to add those values in the properties file.

exportDependencies=false
includeSecurity=false

stacktrace=false
consolelog=false

[Former Member · Accepted solution]

Hi Jawahar,

Thank you again for your prompt reply.

Here in the above Scenario I am running a promote you can see in the property file

action=promote .

I am bit confused about lcmproperty that you are talking about,as far as I know I am using it when running it from command prompt.

Now my Question is do we have to mention this property in properties file as well if yes is their any specefic format that it needs to added in the property file.

Also I tried to remove all the below properties but it made no difference still same error message:

exportDependencies=false
includeSecurity=false

stacktrace=false
consolelog=false

Any inputs are valuable.

Regards

Sumeet

[former_member185603 · Accepted solution]

Check this..

[Former Member · Accepted solution]

HI Jawahar,

Thank you again for your reply.

The issue was with the query in properties file  that was used for promoting user/user groups ,it was found and recorrected and it did the  trick.Now it seems to be working.

Regards

Sumeet