Usage and configuring connection.properties for command line utility product import/export
Hi All,
Could someone help me how to use the connection.properties from prpcUtils.bat.
I could get that, using it we can import to multiple instance. (Please correct me if i'm wrong)
How to use the connection.properties file to be used to get my instance list when executing the prpcUtils.bat.
What configuration or changes to be done to use it.
Thanks,
ArulDevan
***Updated by moderator: Lochan - User still needing assistance. Adding #helpme tag***
Pegasystems Inc.
US
This PDN article has the details.
https://docs-previous.pega.com/how-import-or-export-archive-command-line
Virtusa
IN
Hi Carissa,
Thanks for the reply...
My doubt here is regarding the "connection.properties" file and not the general "prpcUtils.properties".
The mentioned article speaks about configuring "prpcUtils.properties" which will have a single target instance and not about the "connection.properties" .
Thanks,
ArulDevan
Pegasystems Inc.
US
What connection.properties file are you talking about? You need to populate the connection details in the prpcUtils.properties file to connect to your database.
Pegasystems Inc.
US
Hi Aruldevan,
There isn't any file called connection.properties while using command line utility for import/export. I think you are referring to prpcUtils.properties file?
Pegasystems Inc.
US
If you are referring to the jdbc.custom.connection.properties within prpcUtils.properties you should generally never need to set this. This was added for Kerboros connectivity. You should only need to populate the first 6 properties under the "Connection Information" section and then whatever properties that are needed for the specific tool that you will be running.
# Connection Information
pega.jdbc.driver.jar=
pega.jdbc.driver.class=
pega.database.type=
pega.jdbc.url=
pega.jdbc.username=
pega.jdbc.password=
Pegasystems Inc.
US
There is a connection.properties file in the /scripts/utils directory. If you run prpcServiceUtils.sh the usage info says there is a --connProp option:
--connProp FilePath to connection.properties to operate on multiple instances.
However if I specify --connProp it says:
[utils]$ ./prpcServiceUtils.sh import --connProp /home/brett/115041_Pega72/scripts/utils
Unknown setting --connProp
prpcServiceUtils.sh export | expose | import | getStatus | help [options...]
Anyway, even if this option worked I would need a way to specify which connection in my connection.properties file to use. If this is supposed to work I'd love to know how...we're setting up deployment automation and being able to call prpcServiceUtils.sh with a target system and archive path parameter would be perfect.
Pegasystems Inc.
US
Update: The prpcServiceUtils.sh usage displayed is incorrect, the parameter is --connPropFile
This was correct in the usage for prpcUtil.sh and it's also correct in the 7.2 help. I'll put in a bug report on that.
So now it accepts the connection.properties file and it seems to have targeted the system I put in that file rather than the one in prpcServiceUtils.sh. So is this intended to run the same action against multiple systems rather than to select between preconfigured targets?