Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section describes the different properties that you can use in the STR to configure EC/ECSAs.

...

Database Properties

PropertyDescription
max.cached.prepared.statements

Default value: 15

If you have want to change the number of preparedStatements that are cached between connections, you can use this property to specify a different number than default.

Note
titleNote!

If you are using SAP HANA as a database type in a Database profile, used by Database agents, this value has to be set to 0.


connectionpool.strict.pool.size

Default value: false

If you enable this property, the database pool enables the Blocking Queue implementation where there is a strict restriction to the maximum number of connections.

Note
titleNote!
When the property is set to false, then the database connection pool will create additional temporary connections. When the pool is full, these connections are closed as soon as the workflow thread returns the connection to the pool.


connectionpool.wait.timeout.milliseconds

 


Note
titleNote!

This property can only be used if the connectionpool.strict.pool.size property is set to true.

Default value: 5000

This property is used to configure the amount of time a thread should remain in the  blocked queue until it tries for a new connection. If a connection is made available before this time, the thread's waiting time is interrupted.

...

PropertyDescription

ec.backlog.dir

Default value: $MZ_HOME/tmp

This property is applicable for ECs and determines whether you want events and error messages occurring when the contact is lost to be logged in a backlog or not. If the property is not present, events and messages will not be logged. The value of this property specifies where the backlog resides.

ecsa.backlog.dir

Default value: $MZ_HOME/tmp

This property is applicable for ECSAs. All events and error messages occurring when the contact is lost will be logged in a backlog. The value of this property specifies where the backlog resides.

ec.excel.dateformat

Default value: "dd/MM/yyyy"

This property will define the format of the date to be decoded for the ExcelCellUDR. For the date to be parsed successfully, you will have to provide the format of the date received by the ExcelCellUDR. The values in this property conforms to the standards of the SimpleDateFormat java class. If the date is not parsed successfully, the data type of the date field will be treated as a string.

ec.shutdown.time

Default value: 60000

This property specifies the maximum time (in milliseconds) the EC will wait before a real-time workflow stops after a shutdown has been initiated. This is to enable the workflow to stop all input and drain all UDRs in the workflow before shutting down.

The wait time is initially set to 60 seconds. If this value is set to 0 all draining is ignored and the workflow will stop immediately.

pico.bootstrapclass

Default value: ""

This property specifies the bootstrap classes that are required by some components.

pico.ec.do_graceful_shutdown

Default value: true

This property determines the behavior of the mzsh command shutdown. When you have set the value of this property to false and run the command, it will cause EC/ECSAs to shut down without forcing the workflows to stop first.

pico.rcp.server.port

Default value: ""

This property specifies the port that is used for EC to EC communication. If no port is set, a dynamic port will be used and the port number will change each time an EC is restarted. 

mz.json.date.format

Default value: "yyyy-MM-dd'T'HH:mm:ssZ"

This property sets the default JSON format during encoding with jsonEncodeUdr. The format can then be decoded using the jsonDecodeUdr command. 

mz.apl.jsonencodeudr.ignore.bigint.convert

Default value: false

When set to true, this property will allow customers to skip Big Integer and Big Decimal to string conversion when using the jsonEncodeUDR APL function.

mz.use.drdateformat

Default value: true

The date syntax used in the APL functions dateToString and strToDate conforms to the Java class SimpleDateFormat in Java 6.

Even though the syntax conforms to SimpleDateFormat, it is not directly based on this class.

You can enable date format handling based on the SimpleDateFormat class in the installed Java version by setting this property to false. This enables use of additional patterns that are available in the installed Java version. For more information about the functions dateToString and strToDate, see the APL Reference Guide.

mz.use.date.timezone

Default value: false

Setting this property to true will instruct  to use the attached time zone when SQL input originates from a date object.

In most cases, the property should be set in the pico configuration of EC/ECSAs . However, in case of audit processing, the property should also be set in the pico configuration of the Platform.

Note that if the mz.use.date.timezone property is used for setting dates with another time zone, there will be no way of keeping track of the actual time zone in the database, and you may have to manually convert the date during selection. To keep track of the time zone in an Oracle database, use the data type TIMESTAMP WITH TIME ZONE.

pico.type

Default value: ""

This property specifies the type of pico instance used for the EC. The possible values are EC and ECSA.

...


Scroll ignore
scroll-viewportfalse
scroll-pdftrue
scroll-officefalse
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmlfalse


Next: