|
Known Issue
|
Tracking Number
|
|---|---|
|
Users should not directly modify the database.
Changes to the database schema must be performed through the supported services provided by the PTC.DBConnection.Database_TS Thing Shape and the PTC.DBConnection.Manager_TS Thing Shape.
Changes to stored procedures and functions that are provided by PTC are not supported. Stored procedures and functions can be overridden on upgrade, so any changes would be lost.
|
—
|
|
The building blocks code does not support the Participate in platform transactions option.
Workaround: You can make use of this option to perform multiple database transactions from a single service by using the ExecuteService service on the PTC.DBConnection.SQLThingDatabase Thing with the following inputs:
• thingName—Name of the Thing which has the service to be executed.
• serviceName—Name of the service to be executed.
• params—If the service named in the serviceName parameter has input parameters, provide them here. If it does not, provide dummy input such as {"test":"test"}.
For more information about the transactions option, see Connecting to an External Database in the ThingWorx Platform Help Center. NOTE—The workaround does not support rolling back changes to the external database when other actions of the same ThingWorx Platform transaction fail.
This issue will be addressed in a future release.
|
DPM-14886
|