on 09-19-2017 12:18 PM - last edited on 02-04-2024 12:23 AM by postmig_api_4
Hi,
I have configured processingService as below
I have testing throught HTTP Request as below.
When i see the message log. I am getting DB_AVAILABILITY as 0.0.
Please help me to fix the issue.
My HANA DB Details as below in Tables.png
Let me know if anything else i have missed out.
Thank you in advance.
Thanks,
Babu
Hello Babu,
"T_IOT_MONITOR_LOG" table keeps the built-in JMX Checks [1], [2] of the IoT MMS. The "DB_AVAILABILITY" is one of them. Having its value equal to zero means everything is "ok". Zero value follows the Nagios guidelines [3].
As far as I understood, you try to leverage the "Customized Table Mapping" and want your device messages land in the "temperature" table, right? Watch out, you table is located in "BABU" schema but you have configured your mapping with "MYSCHEMA" name.
Regards,
Anton
[3] https://nagios-plugins.org/doc/guidelines.html#THRESHOLDFORMAT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To do that, please provide more information.
Hi Anton,
Please see below for the information.
I have user : BABU
2.Is your "temperature" table is of type "row" or "column"?
I have mentioned column type in ProcessingService.
I have Table type COLUMN in db as well. I have observed once i have deployed the IoT service again. I can see the two tables has been populated automatically and also i can see the data inside two tables which i have highligted below. can you please tell me why and how these tables has been populated here>
3.What are DeviceType and MessageType IDs you used when creating a mapping?
4.What is your payload which device sends? What Message Type ID is used there? To what DeviceType your device belongs?
To avoid confusion now i have removed all the remaining, message, device types and device.
But still problem exist. Please help me.
Thanks,
Babu
my payload is as below.
Message:
{"mode":"sync","messageType":"986294cc4603be27bd93","messages":[{"TEMP":"123","LIGHT":"20"}]}
EndPoint:
Below is the error i got for the above request:
CodeMessage202{"msg":"https://iotmms****trial.hanatrial.ondemand.com/com.sap.iotservices.mms/v1/api/http/ack/a4131b95-6657-4650-b72b-084aa9d81260/1ec76cd5-51f9-4db6-ac0e-3438ffce56c8","retryAfterHeaderValue":"60"}
Hello Babu,
let me please summarize the above provided information and point to the missing parts:
Waiting for the missing points (5 and 7)
Anton
P.S. I would also recommend to increase the log level for the "*iot*" relevant packages in the "iotmms" application (re-start is required) and check if something suspicious is already there in the logs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anto,
I have actually posted wrong payload, which i used earlier.
Now when I tried with correct payload as u mentioned. Its works fine.
The one change i have done is I have changed the DB Table Type as COLUMN which was ROW by default.
I also checked in my HANA DB Table. values has been populated there.
Thanks for your help.
Cheers,
Babu
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.