Configuration Properties

The following tables list the properties required for configuring the database of Offer and Price Engine services.

Authorization Service Properties

Authorization Service General Configurations
Property Name	Default Value
default.tenant.id	TIBCO
logging.config	config/logback_auth.xml
auth.superuser.appId	auth
auth.superuser.appKey	ENC(P2yXphz4OVM=)

Authorization Service Database Configurations
Property Name	Default Value	Other Possible Value
datasourceDriverClassName	org.postgresql.Driver	oracle.jdbc.driver.OracleDriver
adminDsUrl	jdbc:postgresql://localhost:5432/opeadmindb?currentSchema=opeadminschema	jdbc:oracle:thin://@localhost:1521/pdb1
adminDsUsername	opeadminuser	-
adminDsPassword	opeadminuser	-
hibernateDialect	org.hibernate.dialect.PostgreSQLDialect	org.hibernate.dialect.Oracle10gDialect
hibernateDsDefaults	false	-
adminHibernateShowSql	false	-
adminDsInitialSize	10	-
adminDsMaxWait	30000	-
adminDsMaxActive	100	-
adminDsMaxIdle	100	-
adminDsMinIdle	10	-
datasourceValidationQuery	SELECT 1	SELECT 1 from dual
adminDsTestOnBorrow	true	-
adminDsValidationInterval	5000	-

Authentication Token Generation Configuration
Property Name	Default Value
authentication.token.signing.key	ENC(nSa0k6lmjPPN8ZA5SO6BpQ==)
authorization.access.token.validity	43200
authorization.refresh.token.validity	2592000
authorized.client.id	order-management-client
authorized.client.secret	ENC(ggsmFvh5HBbeSD1j+l5Y0rP4qv0rJvEm)

Redis Data Source Configuration
Property Name	Default Value
adminRedisHost	localhost
adminRedisPort	6379
adminRedisPassword	password
redisClusterEnabled	true
redisTestOnBorrow	true
redisTestOnReturn	true
redisTestWhileIdle	true
redisBlockedWhenExhausted	true
redisJmxEnabled	true
redisLifo	true
redisMaxIdle	64
redisMinIdle	16
redisMaxTotal	64
redisNumTestsPerEvictionRun	5
redisSoftMinEvictableIdleTimeMillis	3000
redisMinEvictableIdleTimeMillis	6000
redisTimeBetweenEvictionRunsMillis	3000
redisSslEnabled	true
redisKeyStoreType	pkcs12
redisKeyStoreAbsoluteFilePath	C:/repository/Tibco_Projects/git_repo_LL/github/fos-framework-services/src/authorization-service/target/authorization-service/standalone/config/certificate/myhost.p12
redisKeyStorePassword	tibco123
redisTrustStoreType	jks
redisTrustStoreAbsoluteFilePath	C:/repository/Tibco_Projects/git_repo_LL/github/fos-framework-services/src/authorization-service/target/authorization-service/standalone/config/certificate/cacert
redisTrustStorePassword	tibco123

Common Configuration
Property Name	Default Value	Other Possible Value
cmPluggableCache	Redis	Relational

Catalog Service Properties

Catalog Engine Configuration
Property Name	Default Value
logging.config	config/logback_catalog.xml
isOfferSearchIndexEnabled	false
modelPurgeWorkerThreadCount	5

Messaging Configurations
Property Name	Default Value
catalogLoadingUsingEms	false
emsServerURL	tcp://localhost:7222
tibjmsNamingSecurityProtocol	-
tibjmsNamingSslEnableVerifyHost	-
emsServerUsername	admin
emsServerPassword	admin
jndiConnectionFactory	GenericConnectionFactory
initialContextFactory	com.tibco.tibjms.naming.TibjmsInitialContextFactory
jmsSessionTransacted	true
timeoutReceiveCalls	10000
concurrentEmsConsumers	5
productCatalogLoadingQueue	tibco.aff.catalog.product.request
priceCatalogLoadingQueue	tibco.aff.catalog.price.request
discountCatalogLoadingQueue	tibco.aff.catalog.discount.request
ruleCatalogLoadingQueue	tibco.aff.catalog.operulemodel.request
categoryCatalogLoadingQueue	tibco.aff.catalog.category.request
offerSearchProductIndexQueue	tibco.opes.offersearch.product
globalCacheCleanNotificationTopic	tibco.fos.global.cache.clean.publish

Application Security Configurations
Property Name	Default Value
operation.roles.submitProductModel	ROLE_ADMIN
operation.roles.submitPriceModel	ROLE_ADMIN
operation.roles.submitDiscountModel	ROLE_ADMIN
operation.roles.submitOfferIdsModel	ROLE_ADMIN
operation.roles.submitCategoryModel	ROLE_ADMIN
operation.roles.submitRuleModel	ROLE_ADMIN
operation.roles.purgeProductModel	ROLE_ADMIN
operation.roles.purgePriceModel	ROLE_ADMIN
operation.roles.purgeDiscountModel	ROLE_ADMIN
operation.roles.purgeCategoryModel	ROLE_ADMIN
operation.roles.purgeOfferId	ROLE_ADMIN
operation.roles.submitRuleModel	ROLE_ADMIN

Catalog Data Source Configuration
Property Name	Default Value	Other Possible Value
datasourceDriverClassName	org.postgresql.Driver	oracle.jdbc.driver.OracleDriver
catalogDsUsername	opecataloguser	-
catalogDsPassword	opecataloguser	-
catalogDsUrl	jdbc:postgresql://localhost:5432/opecatalogdb?currentSchema=opecatalogschema	jdbc:oracle:thin:@//localhost:1521/pdb1
catalogDsInitializeSize	2	-
catalogDsMaxIdle	11	-
catalogDsMaxActive	12	-
catalogDsMaxWait	10000	-
datasourceValidationQuery	select 1 from dual	SELECT 1
catalogDsTestOnBorrow	false	-
catalogDsValidationInterval	5000	-
catalogDsTestWhileIdle	true	-
catalogDsTimeBetweenEvictionRunsMillis	5000	-
catalogDsMinEvictableIdleTimeMillis	5000	-
catalogDsNumTestsPerEvictionRun	5	-
catalogDsDefaultAutoCommit	false	-
catalogDsRollbackOnReturn	false	-
catalogDsCommitOnReturn	false	-
catalogDsCustomProperty	-	-

Redis Data Source Configuration
Property Name	Default Value
catalogRedisHost	localhost
catalogRedisPort	6379
redisTestOnBorrow	true
redisTestOnReturn	true
redisTestWhileIdle	true
redisBlockedWhenExhausted	true
redisJmxEnabled	true
redisLifo	true
redisMaxIdle	64
redisMinIdle	16
redisMaxTotal	64
redisNumTestsPerEvictionRun	5
redisSoftMinEvictableIdleTimeMillis	3000
redisMinEvictableIdleTimeMillis	6000
redisTimeBetweenEvictionRunsMillis	3000

Persistence
Property Name	Default Value	Other Possible Value
databaseType	postgres	oracle
hibernateDialect	org.hibernate.dialect.PostgreSQLDialect	org.hibernate.dialect.Oracle10gDialect
catalogHibernateShowSql	false	-

OfferSearchIndexService Properties

Engine Configuration
Property Name	Default Value
spring.elasticsearch.rest.uris	http://localhost:9200
logging.config	config/logback_offersearchindex.xml
com.tibco.af.opes.cacheType.cache.maxNoCategoryCached	0
enableCategoryModelGlobalCache	false
categoryCacheExpiryPeriod	30
com.tibco.af.ope.flags.suggest	false

EMS Configuration
Property Name	Default Value
emsServerURL	tcp://localhost:7222
securityProtocol	-
tibjmsNamingSslEnableVerifyHost	-
emsServerUsername	admin
emsServerPassword	admin
jndiConnectionFactory	GenericConnectionFactory
initialContextFactory	com.tibco.tibjms.naming.TibjmsInitialContextFactory
jmsSessionTransacted	true
timeoutMillis	10000
productIndexQueue	tibco.opes.offersearch.product
productIndexDeadQueue	tibco.opes.offersearch.product.dead
productIndexRedeliveryCount	5
productIndexReceiverCount	1

Redis Data Source Configuration
Property Name	Default Value
redisMaxIdle	64
redisMinIdle	16
redisLifo	true
redisJmxEnabled	true
redisTestWhileIdle	true
catalogRedisPort	6379
redisTimeBetweenEvictionRunsMillis	3000
catalogRedisHost	localhost
redisSoftMinEvictableIdleTimeMillis	3000
redisTestOnReturn	true
redisBlockedWhenExhausted	true
redisTestOnBorrow	true
redisNumTestsPerEvictionRun	5
redisMinEvictableIdleTimeMillis	6000
redisMaxTotal	64

Catalog Data Source Configuration
Property Name	Default Value	Other Possible Value
datasourceDriverClassName	org.postgresql.Driver	oracle.jdbc.driver.OracleDriver
catalogDsUsername	opecataloguser	-
catalogDsPassword	opecataloguser	-
catalogDsUrl	jdbc:postgresql://localhost:5432/opecatalogdb?currentSchema=opecatalogschema	jdbc:oracle:thin:@//localhost:1521
catalogDsInitializeSize	2	-
catalogDsMaxIdle	11	-
catalogDsMaxActive	12	-
catalogDsMaxWait	10000	-
datasourceValidationQuery	select 1 from dual	SELECT 1
catalogDsTestOnBorrow	false	-
catalogDsValidationInterval	5000	-
catalogDsTestWhileIdle	true	-
catalogDsTimeBetweenEvictionRunsMillis	5000	-
catalogDsMinEvictableIdleTimeMillis	5000	-
catalogDsNumTestsPerEvictionRun	5	-
catalogDsDefaultAutoCommit	false	-
catalogDsRollbackOnReturn	false	-
catalogDsCommitOnReturn	false	-
catalogDsCustomProperty	-	-
hibernateDialect	org.hibernate.dialect.PostgreSQLDialect	org.hibernate.dialect.Oracle10gDialect
catalogHibernateShowSql	false

ShoppingCart Service Properties

Shopping Cart Initial Configuration
Property Name	Default Value
logging.config	config/logback_shoppingcart.xml
server.basePath	/opes/api/v1
ope.url	http://localhost:8090
server.tomcat.uri-encoding	UTF-8
redisClusterEnabled	true
info.app.name	Shopping Cart
info.app.description	This is the shopping cart engine
cartPluggableCache	Relational

Shopping Cart Redis Configuration
Property Name	Default Value
shoppingCartRedisHost	localhost
shoppingCartRedisPort	6379
redisTestOnBorrow	true
redisTestOnReturn	true
redisTestWhileIdle	true
redisBlockedWhenExhausted	true
redisJmxEnabled	true
redisLifo	true
redisMaxIdle	64
redisMinIdle	16
redisMaxTotal	64
redisNumTestsPerEvictionRun	5
redisSoftMinEvictableIdleTimeMillis	3000
redisMinEvictableIdleTimeMillis	6000
redisTimeBetweenEvictionRunsMillis	3000
redisMinIdle	16
redisMaxTotal	64
redisNumTestsPerEvictionRun	5
redisSoftMinEvictableIdleTimeMillis	3000
redisMinEvictableIdleTimeMillis	6000
redisTimeBetweenEvictionRunsMillis	3000

Shopping Cart Data Source Configuration
Property Name	Default Value	Other Possible Value
hibernateDialect	org.hibernate.dialect.PostgreSQLDialect	org.hibernate.dialect.Oracle10gDialect
shoppingCartHibernateShowSql	false	-
datasourceDriverClassName	org.postgresql.Driver	oracle.jdbc.driver.OracleDriver
shoppingCartDsUsername	shoppingcartuser	-
shoppingCartDsPassword	shoppingcartuser	-
shoppingCartDsUrl	jdbc:postgresql://localhost:5432/shoppingcartdb?currentSchema=shoppingcartschema	jdbc:oracle:thin:@//localhost:1521/orcl.apac.tibco.com
shoppingCartDsInitializeSize	2	-
shoppingCartDsMaxIdle	11	-
shoppingCartDsMaxActive	12	-
shoppingCartDsMaxWait	10000	-
datasourceValidationQuery	select 1 from dual	SELECT 1
shoppingCartDsTestOnBorrow	false	-
shoppingCartDsValidationInterval	5000	-
shoppingCartDsTestWhileIdle	true	-
shoppingCartDsTimeBetweenEvictionRunsMillis	5000	-
shoppingCartDsMinEvictableIdleTimeMillis	5000	-
shoppingCartDsNumTestsPerEvictionRun	5	-
shoppingCartDsDefaultAutoCommit	false	-
shoppingCartDsRollbackOnReturn	false	-
shoppingCartDsCommitOnReturn	false	-
shoppingCartDsCustomProperty	-	-

Authorization Server Configuration Properties Used for Auth Token
Property Name	Default Value
authorization.service.username	apiUser
authorization.service.password	apiUser

Offer and Price Engine Service Properties

OPE Initial Configuration
Property Name	Default Value
server.basePath	/opes/api/v1
server.tomcat.uri-encoding	UTF-8
cxf.path	${server.basePath}/opeService
endpoints.docs.enabled	true
endpoints.health.sensitive	false
info.app.name	Offering and Pricing Engine
info.app.description	This is the core offer and pricing engine
scoreUpdaterDelayInMillis	120000
ledgerUpdaterDelayInMillis	120000

Catalog Store Configuration for OPES
Property Name	Default Value
spring.main.allow-bean-definition-overriding	true
com.tibco.fos.model.cacheType.cache.maxNoProductcached	1000
spring.jackson.serialization.WRITE_DATES_AS_TIMESTAMPS	true
enableProductModelGlobalCache	false
productCacheExpiryPeriod	30
productCacheRefreshOffset	5
com.tibco.af.opes.cacheType.cache.maxNoPriceCached	1000
enablePriceModelGlobalCache	true
priceCacheExpiryPeriod	30
com.tibco.af.opes.cacheType.cache.maxNoDiscountCached	1000
enableDiscountModelGlobalCache	true
discountCacheExpiryPeriod	30
com.tibco.af.opes.cacheType.cache.maxNoRuleCached	1000
enableRuleModelGlobalCache	true
ruleCacheExpiryPeriod	30
com.tibco.af.opes.cacheType.cache.maxNoCategoryCached	1000
enableCategoryModelGlobalCache	true
categoryCacheExpiryPeriod	30
com.tibco.af.opes.cacheType.cache.maxNoOfferIdsCached	1000
enableOfferIdsModelGlobalCache	true
offerIdsCacheExpiryPeriod	30
com.tibco.af.opes.cacheType.cache.maxNoFilterCached	1000
enableFilterProductGlobalCache	true
filterProductCacheExpiryPeriod	30
com.tibco.af.opes.cacheType.cache.maxNoSegmentCached	1000
enableSegmentProductGlobalCache	true
segmentProductCacheExpiryPeriod	30
com.tibco.fos.model.cacheType.cache.maxNoTopLevelProductsCached	1000
enableTopLevelProductsGlobalCache	true
topLevelProductsCacheExpiryPeriod	30

Redis Data Source Configuration
Property Name	Default Value
redisMaxIdle	64
redisMinIdle	16
redisLifo	true
redisJmxEnabled	true
redisTestWhileIdle	true
catalogRedisPort	6379
redisTimeBetweenEvictionRunsMillis	3000
catalogRedisHost	localhost
redisSoftMinEvictableIdleTimeMillis	3000
redisTestOnReturn	true
redisBlockedWhenExhausted	true
redisTestOnBorrow	true
redisNumTestsPerEvictionRun	5
redisMinEvictableIdleTimeMillis	6000
redisMaxTotal	64

OPE Integration Configuration
Property Name	Default Value
tnt##com.tibco.af.ope.flags.chkrelevantoludfs	false
tnt##com.tibco.af.ope.flags.chkvalidoludfs	false
tnt##com.tibco.af.ope.flags.chkvalidlinkudfs	false
tnt##com.tibco.af.ope.flags.chkrecordtypevalid	false
tnt##com.tibco.af.ope.flags.chkrecordinventory	false
tnt##com.tibco.af.ope.flags.setnorecordstatustoactive	false
tnt##com.tibco.af.ope.flags.validateudfdatatype	false
tnt##com.tibco.af.ope.flags.validateudfrange	false
tnt##com.tibco.af.ope.flags.validateudfregex	false
tnt##com.tibco.af.ope.flags.regexcurrency	[0-9]*.?[0-9]{0,2}
tnt##com.tibco.af.ope.flags.regexdigits	[0-9].?[0-9]
tnt##com.tibco.af.ope.flags.regexdate	[0-3]?[0-9]/[0-1][0-9]/[1-2][0-9]{3}
tnt##com.tibco.af.ope.flags.regextime	[0-2]?[0-9]:[0-5][0-9]
tnt##com.tibco.af.ope.flags.regexboolean	TRUE\|FALSE
tnt##com.tibco.af.ope.flags.udfignorelist	-
tnt##com.tibco.af.ope.flags.reportAllOfferValidations	true
tnt##com.tibco.af.ope.cacheType.cache.lazyLoadProducts	true
tnt##com.tibco.af.ope.flags.filteroutduplicates	false
tnt##com.tibco.af.ope.flags.enable.page	false
tnt##com.tibco.af.ope.flags.allow.empty.response	false
tnt##com.tibco.af.ope.flags.ineligible.reason	false
tnt##com.tibco.af.ope.flags.ineligible.price.reason	false
tnt##com.tibco.af.ope.log.processingtime	false

Custom class names for the ope extension
Property Name	Default Value
com.tibco.af.ope.ope.ext.classes	false

OPE Extension Configuration
Property Name	Default Value
tnt##com.tibco.af.ope.extn.enableRuleBasedEligibilityEvaluation	false
tnt##com.tibco.af.ope.extn.enableRuleBasedIneligibilityEvaluation	false
tnt##com.tibco.af.ope.extn.enableRuleBasedIncompatibilityEvaluation	false
tnt##com.tibco.af.ope.extn.missingRuleEntityDefault	false
com.tibco.af.ope.extn.invConf.host	localhost
com.tibco.af.ope.extn.invConf.port	8080
com.tibco.af.ope.extn.invConf.user	admin@tibco
com.tibco.af.ope.extn.invConf.password	admin

Catalog Data Source Configuration
Property Name	Default Value	Other Possible Value
datasourceDriverClassName	org.postgresql.Driver	oracle.jdbc.driver.OracleDriver
catalogDsUsername	opecataloguser	-
catalogDsPassword	opecataloguser	-
catalogDsUrl	jdbc:postgresql://localhost:5432/opecatalogdb?currentSchema=opecatalogschema	jdbc:oracle:thin:@//localhost:1521/pdb1 -
catalogDsInitializeSize	2	-
catalogDsMaxIdle	11	-
catalogDsMaxActive	12	-
catalogDsMaxWait	10000	-
datasourceValidationQuery	select 1 from dual	SELECT 1
catalogDsTestOnBorrow	false	-
catalogDsValidationInterval	5000	-
catalogDsTestWhileIdle	true	-
catalogDsTimeBetweenEvictionRunsMillis	5000	-
catalogDsMinEvictableIdleTimeMillis	5000	-
catalogDsNumTestsPerEvictionRun	5	--
catalogDsDefaultAutoCommit	false	-
catalogDsRollbackOnReturn	false	-
catalogDsCommitOnReturn	false	-
catalogDsCustomProperty	-	-

Messaging Configurations
Property Name	Default Value
emsServerURL	tcp://localhost:7222
securityProtocol	-
tibjmsNamingSslEnableVerifyHost	-
emsServerUsername	admin
emsServerPassword	admin
jndiConnectionFactory	TopicConnectionFactory
initialContextFactory	com.tibco.tibjms.naming.TibjmsInitialContextFactory
jmsSessionTransacted	true
timeoutMillis	10000
globalCacheCleanupTopicName	tibco.fos.global.cache.clean.publish

Persistence Configurations
Property Name	Default Value	Other Possible Value
databaseType	postgres	oracle
hibernateDialect	org.hibernate.dialect.PostgreSQLDialect	org.hibernate.dialect.Oracle10gDialect
catalogHibernateShowSql	false	-

Api Response Cache Configuration for OPES Configurations
Property Name	Default Value
getOfferResponseCacheExpiryPeriod	30
com.tibco.af.opes.cache.maxNoGetOfferResponseCached	1000
validateOfferResponseCacheExpiryPeriod	30
com.tibco.af.opes.cache.maxNoValidateOfferResponseCached	1000
getProdInfoResponseCacheExpiryPeriod	30
com.tibco.af.opes.cache.maxNoGetProdInfoResponseCached	1000
getPricesResponseCacheExpiryPeriod	30
com.tibco.af.opes.cache.maxNoGetPricesResponseCached	1000
getPriceInfoResponseCacheExpiryPeriod	30
com.tibco.af.opes.cache.maxNoGetPriceInfoResponseCached	1000
getCategoryResponseCacheExpiryPeriod	30
com.tibco.af.opes.cache.maxNoGetCategoryResponseCached	1000
enableOpeApisResponseCache	false

Common configuration Service Properties

General Configurations
Property Name	Default Value	Other Possible Value
default.tenant.id	TIBCO	-
enableSecureAPI	true	-
cmPluggableCache	Redis	Relational
catalogMode	OPES	-
enableProductScoringAndLedger	false	-
enablePriceScoringAndLedger	false	-
enableDiscountScoringAndLedger	false	-

Actuator Configurations
Property Name	Default Value
management.endpoints.web.exposure.include	health,info,ready
management.endpoints.jmx.exposure.include	-
management.endpoints.web.base-path	/management
management.endpoints.health.enabled	true
management.endpoint.health.show-details	NEVER
management.health.defaults.enabled	true
management.endpoints.info.enabled	true
management.endpoints.metrics.enabled	true
management.endpoints.jolokia.enabled	true
management.health.redis.enabled	false

Authorization Server Configuration Properties Used for Swagger UI Configurations
Property Name	Default Value
authorizationServiceTokenEndPoint	http://localhost:9091/oauth/token
authorization.client.id	order-management-client
authorization.client.secret	order-management-secret
authentication.token.signing.key	ENC(nSa0k6lmjPPN8ZA5SO6BpQ==)
useAccessTokenFromProperty	false