IoT & Connectivity

I'm doing some testing on an instance of 9.0.2 and I tried importing a JDBC extension that uses the 7.2 version of the MS SQL JDBC jar file, however, I got an error indicating a new version was available (that I did not import).   After further review, I found a newer version of the MS SQL JDBC jar file buried in the Thingworx web application file:   C:\..\Tomcat 9.0\webapps\Thingworx\WEB-INF\lib   File: mssql-jdbc-7.4.1.jre8.jar   Questions: With TWX 9.0, do we no longer have to have a specific extension installed to connect to MS SQL databases? When creating a new connection to MS SQL Server for a TWX application, do we just use the "Database" Thing Template, and configure accordingly? Method in #2 above is working, it's just different than what I'm used (started with 7.4). I think this is great, but want to be sure I'm using this as expected.

I need to select dates only from September month and need to disable rest of the previous dates in date picker widget. 

Hello,   I look for the good practice of dependencies management across multiple Java extensions. I work on a project where we have developed multiple Java extensions and where we use standard extensions. We always facing troubles with JAR dependencies across extensions and we finish to comment jar resource dependency within the metadata.xml in order to import extension. Moreover in some cases we need to know the order of import of extensions.   For example: - We have imported the extension DataExporter which contains the jar poi-4.0.0.jar - We need to import a custom extension which depends on poi-4.1.2.jar   And from here we can't import our custom extension. Checking ThingWorx system JARS conflict(s) detected [package: XXXXXX]. A workaround for this situation, as mentioned earlier, is to comment the poi-4.1.2.jar in the metadata.xml and rely on the existing  jar poi-4.0.0.jar already imported in the platform.   Do you guys have a cleaner workflow? Do y

Hi, How did you solve this issue?? Can you please tell the solution.

Thingworx 8.3.3 : Below picture shows implementation using repeater widget. Thingworx 8.5.2 : I want to implement the same using collection widget in 8.5.2 version but inner mashups are not stretching horizontally.I tried both Table/flow views.        

Hello, I have been beating my head against the wall with this for a while now.  Any help would be appreciated!   I have a VERY simple csv I'm using as a dataset:   That's it:  3 fields and "Temp", which is what I want to predict from the other 3.  So I upload this data into TWX Analytics (metadata correctly inferred), build the model, and publish it.  The problem is, every time I try to "test" the model, I can't.  No matter what values I put into the inputs, the job fails with "Data Shape Does Not Match - Number of Fields Are Different":     In addition, when I run the Signals for this model, no output is ever shown in the Features List when it is completed.  I have run this before with other (much more complicated) data sets and never had any issues.  The only error I see on the signals run is logged in the Script log:   GetSignalsAMS: Error: JavaException: java.lang.Exception: Field names do not match : Field [goal] Not Fo

Hi,   Any one knows what is type of password encryption in Thingworx?,what level of encryption is used?   Thanks&Regards, Latha    

Hi everybody,   I am working with data export widget to export data from my data table. It is working well.   I would like to schedule one time to launch this widget everyday rather than I do it manually.   I have been thinking to use the function "schedulers" to does it:     Does anyone know if this is possible?        

I would like to archive some Data Table records we have stored in ThingWorx (with a PostgreSQL Persistence Provider). I don't have much experience with setting up/optimizing PostgreSQL databases, so I am looking for some input. Note that we have both an application server and a separate database server which also has a PostgreSQL persistence provider set up. The records in this table are currently stored using that external persistence provider on the database server, not the application server.   Old records would not need to be regularly accessed and I want to offload them to clean things up a bit and reduce the amount of records in this particular Data Table. The way I see it there are 3 ways to do this: Add the records to a separate Data Table which also stores data using the external persistence provider Set up a separate database/table in PostgreSQL (not part of the ThingWorx data model), and create SQL queries using a JDBC connection to retrieve records as needed Add the r

Hello! The contractor performed work on connecting temperature sensors via the SiemensS71200 controller to the SCADA system via the Modbus TCP\IP Protocol. But they made the connection directly, bypassing our existing opc server. I'm currently trying to add this controller to our kepserverex 5.13, but it doesn't work. I always get _FailedReads in the _Statistics tab. In this case, the controller is pinged. Moreover, I get correct responses from the same ip address and modbus addresses in the opc server of another manufacturer. I don't know what I'm doing wrong. Port: 502 Screenshots include

Dear experts,    What would be your suggestion on finding a way to visualize a 2-level Network in a Mashup? Are there any Widgets that give that kind of functionality out of the box?   Thanks, Federico

Hi, hoping you're doing well   I don't finish to fully understand how work properly with thingworxs so I ask for your help again   I have a test Mashup     when I click the butto marked in red I got the results form db, this works fine   Now I need to get the datetime when I clicked the button222 (marked in blue) and pass this datetime to a service   I also made a generic service that gets an input parameter and log the data       I tested the generic service alone and works     But I cannot bind what I need from the mashup to the service or I dont know how to do it,...   How can I bind the click event to get the datetime from the datetime widget and execute the service with this value as an input parameter?   Please, do you have the proper coding to do that? so I can tested   Best Regards, Marcos

Hi,   For a proof of concept, i need to do an IOT setup at a client's premises using Thingworx and Kepserver. There is no licence for any of these, and i am using the trial versions. I have installed the Thingworx Foundation. I want to add the manufacturing app extension. How do i do so.   I know how to download and install extensions if we have licence. For trial version how to do so.     Regards, Sri1

Hi in KepServerEX6 I created a channel ODBC Client to get data from a Access database. I created a Device for a table and successfully generated a tag. Now I would like to get data from other tables. I created another device (correct ? ) but the tag generation return error "Unable to generate a tag database for <MY DEVICE>:Automatic tag generation for device <MY DEVICE>' refused due to active client connections" I read another topic , same error. The suggestion was to 'Close all OPC client connections to the device and retryAutomatic Tag Generation' but how can I verify the open connections and close them ? Many Thanks  

Thingworx 8.5.2 :   How do I apply hover,selected styles to dropdown list items as I dont see any option.   I donot want to use style theme here.   Please help me out asap.Thanks in advance  

I know that we can use the expand, collapse option of the containers to accomplish something like a navigation panel, but i don't want other containers to move from its position when the navigation container is expanded. Is there any CSS code or anyway to do that?

Hi,   I am able to create a value stream object using the service CreateThing under Resource - EntityServices : connectedClient.invokeService(RelationshipTypes.ThingworxEntityTypes.Things, "SampleValueStream", "CreateThing, vc, 5000); and vc object contains the thingtemplate = "ValueStream".    Now I need to assign the PersistanceProvider to this value stream and also add the properties it will hold the data of. I can see the services listed in Thingworx composer UI - SetPersistenceProvider, AddPropertyDefinitions which can be used for these functionalities.    But I do not see the entity type ValueStream available in class 'RelationshipTypes.java' for accessing the services via connectedThingClient's invokeService() api.   Can anyone please help me how to specify the entityType and access these services via invokeService() api?   Regards, Vaishnavee

Thingworx 8.5.2 :   Navigation mashup has two infotable parameters but I could not see the parameters when I created the navigation function.   I could not bind anything to parameters as I dont see them.   Please resolve the issue asap.Thanks in advance

Hi, i'm using thingworx 8.5.5 and i cannot delete anything from it. I get the following error:   Thank you !

Hi, i'm trying to build a Thingworx Extension service who has to Export and Import entities from a Source Control thing.I've already built the "Export", invoking SourceControlFunctions resource and its ExportSourceControlledEntities service.     @ThingworxServiceDefinition(name = "ExportEntitiesToFileRepository", description = "Esporta le entities di una collection/project nel path specificato della thing File Repository indicata nella configurazione.\r\nNON ESEGUE NESSUNA ATTIVITA' di source control", category = "", isAllowOverride = false, aspects = { "isAsync:false" }) @ThingworxServiceResult(name = "Result", description = "", baseType = "BOOLEAN", aspects = {}) public Boolean ExportEntitiesToFileRepository() { String repositoryThingName = getStringConfigurationSetting("Configuration", "repository_thing"); _logger.error("Repository Thing: "+repositoryThingName); SourceControlFunctions scf = (SourceControlFunctions) EntityUtilities.findEntity("SourceCo

Greetings all.  I am working through the IoT Modeling with ThingWorx program through PTC Academy and am running into issues with M6:19 Aggregator Service.  Step 36 asks me to execute the "Rollup" service, but when I do, I get the error:  Error executing service Rollup. Message :: TypeError: Cannot call method "GetPowerConsumers" of null - See Script Error Log for more details.I am new to ThingWorx (obviously, since I'm taking programs through the Academy) so this could be something very easy to resolve, however, I haven't been able to figure it out.  Any suggestions?

Hi Team,   How to get the no of days remaining for a ThingWorx License via some service?   Thanks in advance

Hi, hoping you're doing just fine..   I'm pretty new with thingworx and I need to develop mashups that read/write data from/to SQLServer and handle some of that data to do custom reports   So, I have some troubles to store sql results in a database entity to use in the example mashup that I've been working   what I did was:   - Create a test data shape with the sql table structure: - Create a test data table with the adding the shapes I just create:     - Create a Database Thing that make the connection to SQL server and in a javascript do the query.... you'll se the results down (I also tryied to set the test data shape in the output and nothing)           - In the database thing I also added properties     From there I'm lost, I don;t know how to set the properties with the data returned   Can you help me with some code to base on, so I can store the values in the properties and display in a widget (can be a gri

Hi Team,   Suppose I want to call one common service of 5 ThingWorx Environments in one service of master ThingWorx environment (can say 6th environment) to see the result on any mashup in 6th environment.   Result on mashup in 6th enironment will be like :- Env1---> ResultOfEnv1 Env2---> ResultOfEnv2 Env3---> ResultOfEnv3 Env4---> ResultOfEnv4 Env5---> ResultOfEnv5   What would be the solution?   Thanks in advance.  

    Hello I am using a grid to create a history of my data, however my data "strings" do not appear, because from the querypropertyhistory service they are not there. How can I include the strings in the querypropertyhistory service?