on 10-29-2014 12:38 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
#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
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
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
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.