Mfg Solutions & Apps

Hi,    I'm learning how Operator Advisor works and how we can use it in our future projects.  I understand when I add properties in the _AP table before I run the service 'CreateTables', the properties are added in de database table.   But let's say the project is live, already containing data, and I want to upgrade the data model. How do we do this? Do we add a field in the datashape and add a column in the database manual? Or are there services to update all _AP tables? Because 'CreateTables' goes in error if I try a second time.   Jasper

A similar problem was described and solved for previous versions of THX: https://community.ptc.com/t5/Manufacturing-Apps/Control-Advisor-App-Kepware-server-added-but-not-visible/m-p/538017The solution to this issue was to install updates. What can be done in this case? Versions : Windows 7x64 maximum SP1Tomcat 8.5.30Postgres 10.3.3ThingWorx 8.3.3-b937Manuf Apps 8.3.1 ExtensionIndustrial Connectivity 8.3.65 Everything is installed and run smoothly. Connection with TWIC and tags are available in the composer. But the problem I have is that in my App Control Advisor, the list of Servers is empty.Even when I add new server the created server is not displayed. If i try to create the server again in the Control Advisor App a message tells me that the server already exists, which is normal. All screenshots are similar to the post to which I refer. Thank you, Peter.

Just downloaded Thingworx demo and KEPServerEX 6.6 When I tried to connect KepServerEX, I got the following error: "ThingWorx Native Interface Connection to ThingWorx failed. | Platform = <servername>:<server port>/Thingworx/WS, error = unknown error."   In summary, I think the issue was that you can not use the name "localhost" for your server name.   I checked that I had correctly setup all my ThingWorx items in Property Editor (Enabled, host name, port, application key, etc.)  However, I kept having problems.  I thought the problem was the application key, so i entered a bad application key and I got a different error (authentication error).  I tried changing the socket from 9080 to the example's 8080 and got a socket error.   After going into the thingworx controls advisor and deleting the server and then adding a new server called "TestServer" instead of "localhost", it now works.   I'm writing this post in hope that either someone ex

Hi all,    We are implementing Operator Advisor (in TW 8.4). It's clear that every table in the database has a copy in ThingWorx as a DataShape, also junction tables.    I'm wondering, what is the best way to show data from multiple tables in the database? The way I see it there are two options:  1. Use the Operator Advisor database services and make multiple calls and do intersects on the infotables you'll get as an answer.  2. Write your own JOIN query's in the database thing and display the answer in a datatable.   Another question leaning on the previous question: What datashape do you use when you display the joined data? Or do you make a new DataShape for every new call? 

I am trying to follow the sample setup from PTC and am having difficulty in that the IoT Gateway starts, finds the JRE "KEPServerEX\IoT Gateway IoT Gateway using JRE at [C:\Program Files (x86)\Java\jre1.8.0_191]"   Then the IOT Gateway service stops.  Why?  How do I determine the cause of this?  The Custom Controls Advisor cannot be used due to connectivity issues.  Thanks,     John  

I want to add asset and line type to create equipment pop up panel as in the attachment. Also, I want to assign asset detail mashup to each asset or line type. If possible, let me know the way.

Hi, I am using the ThingWorx v8.2. What is the ThingWorx sco and how to incorporate it with ThingWorx? Is there any extension available for this? I know that the manufacturing apps has the sco extensions and it is used for assets.  But Can we incorporate the SCO functionality in standalone ThingWorx? I have few questions like:   1) What is a connected asset in ThingWorxSco? 2) What are included in ThingWorx sco Enterprise subcription? 3) What are they refering to 15 users is included in Enterprise platform in Thingworx SCO? Please provide some idea.   Thanks, Shalini V.

Hi, I have a project coming up that will require to connect Manufacturing Apps with some sensors physically connected to a Raspberry PI (GPIO). Data from sensors are published to a MQTT broker (using Node-Red). I'm new with Manufacturing Apps, I would like to know which is the way to do the connection between the Manufacturing Apps and the MQTT server. If you have some suggestions I would appreciate that.  Many Thanks Regards, Martina

Hi experts, I'm trying the ThingWorx Manufacturing Apps according to the guide here: https://developer.thingworx.com/en/resources/guides/configure-manufacturing-apps/configure-factory-simulator-data.   One of the steps is to open the DemoFactorySimulator.opf in Kepware, after this step I should see "ThingWorx Native Interface , Connected to Thingworx" in the Kepware's log console, however I see "ThingWorx Native Interface Connection to ThingWorx failed. | error = could not initialize a secure ".   My environment: OS: Windows server 2012 R2 Installation file: ThingWorx-Manufacturing-Apps-8.3.0-05.exe Both of Thingworx and ThingWorx-Manufacturing-Apps are in the same machine, IP: 192.168.152.132, port: 9080   What I have verified: http://192.168.152.132:9080/Thingworx/Composer is accessible http://192.168.152.132:9080/Thingworx/FormLogin/Welcome is accessible telnet 192.168.152.132 9080 has no error Property Editor for ThingWorx in Kepware: see the attached picture. The

Graphs on Asset Advisor Monitored Properties have weird data that isn't chronological. See attached pictures

Hello Everyone I am facing problem in Manufacturing Apps. I imported all extension in thingworx 8.2 version and after accessing app it show me only console window option not other. i am not getting any kind of error/ exception while importing extension .  could you please help me in this.   Thanks in advance 

ThingWorx Manufacturing Apps extension dependenced fails to import. ThingWorx Platform 8.1.11 ThingWorx Manufacturing Apps 8.1.1 and 8.1.2 (I've tried with both) Apache Tomcat 8.5.37 Oracle Java 8 upd92 and upd202  (I've tried with both) PostgreSQL Microsoft Windows Server 2008 R2 SP1

After upgrading to Manufacturing Apps 8.4 when i choose a property to edit from the additional properties menu I get the following error.    Error invoking service: Unable to Invoke Service GetAdditionalPropertyUI on PTC.SCA.SCO.ManageResourceUtils : null

Hi, I am using manufacturing apps through ThingWorx 8.2. I connected to the kepware but the manufacturing apps is not reading the tags and showing no status. Please help me on how to connect to the tags and develop OEE, availability and other parameters. Thanks, Shalini V.

I have an asset setup in Asset Adviser. I setup a tag in trending and troubleshooting per the instructions i found in one of the online tutorials. The trend doesnt show up in Monitored Properties from the asset adviser page. Any ideas?

Hi there,   Has anyone come across or developed an updated version of the Dygraph and Timeline Chart Widgets so that they are responsive.   We have a series of JSON data being streamed in from live assets and these get populated well the existing ootb widgets, but we need these to autoadjust based on the different devices these can be viewed on.   Regards, Andrew

Hi -    I'm working on a solution to transfer data between a PLC and MSSQL Database using KEPServerEX. I was able to implement the push (data from PLC being transferred to the MSSQL DB ) using the ODBC client and writing to a stored procedure.   However, I'm having issues with pulling the data to KEPServerEX with a parameter (i.e. ID). I would like to call a stored procedure or function with the parameter 'id' to limit the result set to a single row from the SQL Server.   I've attempted the data pull on a test database with a stored procedure (returning no results), a function (also returning no results), a query that selects from the function (which returns results, but no parameter), and several other attempts only to reach a dead end.   Wondering if anyone has experience with the ODBC client driver that may have found a solution to this. The simplest way would be to have an input tag used in the query and do something like: SELECT * FROM ufn_GetDevices(&nbs

Hi, Greetings!                  I want to install Manufacturing App with SQL Server database instead of Postgres database. Is this possible? If yes then how to do that? I have searched for the document for the same but no success. Your response is highly appreciated.   Thanks.

Hi Developers,   What are the HA features for KepserverEX ?    The current scenario is that we have defined channels, devices and data tags in a single Kepserver and its now connected to the Thingworx composer. Now we're looking for fail safe scenarios on the Kepserver machine. I couldn't find documents for this.   I came across link and learnt about Redundancy Master. I'm didn't quite get how to use this and this document seems to be outdated. We're currently using TWX_Industrial Connectivity 8.3.    Please suggest some useful guides.   Thanks and Regards, Saran    

Hi, While trying to import the extension "ThingworxManufacturingApps-8.0.1-02-extension.zip"  i'm getting the following error.   AppHomePage-extension:8.0.1 C:\ThingworxStorage\extensions\temp\ThingworxManufacturingApps-8.0.1-02-extension_d72e2141-4700-4db8-9429-50e5940689bd\ThingworxManufacturingApps-8.0.1-02-extension.zip signed extension file does not match digests   And import of "ThingworxManufacturingApps-8.0.1-02-extension-dependencies.zip" fails with the following error.   "TWX_Converge_Styles_ExtensionPackage:8.0.1Import Failed: Unable to update vocabulary [ TWUTL ]: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]" Am i doing the import in the right way ? Please advice Thanks and Regards, Aishwarya H MESTECH Services  

With reference to enabling of "Store and Forward" option in TWX Industrial Connectivity, I would like to get clarity on the following: When there is a connectivity loss, does TWX Industrial Connectivity continuously check Thingworx for the instance of connection loss and retrieval (or) does Thingworx requests for lost data once when the connection is regained? In simple words, which side initiates the process? When "Store and Forward" is enabled, does TWX Industrial Connectivity store each and every data regardless of connectivity or does it store only when there is a connectivity loss? 

How to include a remoteDatabase thing to  Asset Adviosr equip list?   How to put a RemoteDatebase Thing , to be showed in the equipment lists in Asset Advisor, Production Advisor? The background is, the remote thing is an equipment with Microsoft Access Database, and we can get all necessary OEE parameters from it easily.   I have tried Kepware to connect to the access database , but it has a lot of issues on SQL query and datetime calculation logic. ------> Kepware is not OK here. so I established a RemoteDatebase thing, resp this equipment ,based on Thingworx EMS ADO services solution. And finally I can get the properties of the equipment in Composer.-----> OK to get properties with EMS solution.   However, the only issue now is,  I can't get this equipment showed in the Asset Advisor, Production Advisor, because it is based on the RemoteDatebase ThingTemplate(not PTC.ISA95.PhysicalAssetThingTemplate)...

With the trends in IOT and the use of it moving up the hierarchy would it make sense to make KepServerEX a bit more Enterprise capable? Things like: - Able to manage and run multiple projects - so different teams or lines/areas can be connected and changes can be limited to multiple smaller projects rather than just one - Active Directory integration for configuration (and run-time if possible for UA?) security - Web client access for configuration and control - Maybe through REST-ful API in ThingWorx? so users don't need to be given access to the server to make changes or manage

Where can i find the Administration and Configuration module ? I am trying to setup an asset for maintenance but i cannot find that module in my mfg apps menu.  

Hi, I have been doing some research to find out how to connect "'things" to Manufacturing apps when not using KepServer. We have a project coming up that will require an Arduino with some sensors to connect to Manufacturing apps. I assumed, that as the modbus works so well with the RaspberryPI (Sensehat Example) that the same could be done with the Arduino. I cant find a way to do it. Ideally I would like to connect to Kepserver and then to TWX. If you have some suggestions I would appreciate that.  If that's not possible how easy is it to take my Arduino things communicating via REST and use those in MFG Apps? Regards, Bryan