Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
Hello,
I have created a mashup which consists of 4 different mashups in it , which is mapped to fetch the data from the database and to display it on the mashup. (my mashup link is something like this https://<xyzname>-dev-twx.es.thingworx.com/Thingworx/Mashup/<mashup_name>
As i have also had auto refresh function to the services with 5 seconds refresh interval, the thing is mashup services are getting the real time data but in the mashup we are not able to any data even though the delay is been given to 5 seconds as we have the data in each second in the database , In mashup we are seeing only refresh loading symbols on the widgets instead of data where the loading symbol will not be removed .
How to get rid of the loading symbol from the mashup and make the fetched data visible (also can i keep the auto refresh to 1 seconds as our machine data will be keep on updating for each second , is that the reason why I am unable to see the data) and also how to get the mashup loaded fast (can we implement any cdn to the mashup.
Kindly help me to get the solution to this issue as soon as possible.!
Please refer the below image where you can get the brief idea about what I am trying to convey
Regards,
Shree
Solved! Go to Solution.
Hi @NH_shree
No it wont affect anything.
To debug your mashup, Create a New test mashup and bind value to widget. Don’t call any other service in that mashup and check whether data is loading properly
/VR
Hi @NH_shree
You can disable the loading icon in widget property
To improve loading time, could you please tell me how exactly you are fetching data from Database (maybe some sample query)
/VR
Hi @Velkumar ,
for the above image the query is as follows
the query is written like this ( sample for here i have used 3 parameters related to the above image)
SELECT Extruder_0_Filament_Run_Out,Extruder_1_Filament_Run_Out
FROM SFv2printer
WHERE created_at=(select max(created_at) from SFv2printer);
Regards,
Shree
@NH_shree Have you checked in the browser developer tool how many times the service is being called and the time taken to execute it?
Hi @NH_shree
1. Open your mashup in runtime
2. Press the F12 button and select Network
3. In the network you can see service calls and the time taken to load
/VR
Hi,
Also if i try to access my mashup page it is showing me the error like below
Previously it was working fine but now a days it is showing like this and on the mashup the data is also not updating
Regards,
Shree
Hi @Velkumar ,
I am getting like this in the browser
Row 1903 is the last data it should show but i am waiting , still it is showing like this and previously atleast it was showing last data logged even though the data loading symbol overlaps it but now when i am checking it from yesterday it is showing me 0 value, what could be done.
Regards,
Shree
Hi,
The services are getting the status response 200 sometimes ,
again it is showing failed status
Hi @NH_shree
Could you please check what is the error message for failed calls?
Click on call and Response should give error message
/VR
Hi @NH_shree
No it wont affect anything.
To debug your mashup, Create a New test mashup and bind value to widget. Don’t call any other service in that mashup and check whether data is loading properly
/VR