Handling the error "Query failed" bzw. "An error occoured while querying the system use notification"
In the course of an update to firmware 21.0.X an error occurs in PLCnext Control. This error prevents the activation of licenses on the PLCnext Control.
[u]Error identification 1:[/u]
In PLCnext Store a license activation is not executed correctly.
The activation process showes "WAITING_FOR_DEVICE" longer than 1 minute.
In the Store device view, "processing" is permanently displayed at the license. The license is not transferred to the device.
[u]Error identification 2:[/u]
Use your browser and open the WBM of the device by entering the IP address. The following error message appears:
[img]https://www.plcnext-community.net/images/users/daniel_buschatzky/PLCnextStore_WBM_Fehler_Queryfailed3.png[/img]
[u]Error identification 3:[/u]
Use your browser and open the WBM of the device by entering the IP address. In the WBM, navigate to the Administration -> License Management location.
Here the situation is as follows:
[img]https://www.plcnext-community.net/images/users/daniel_buschatzky/PLCnextStore_WBM_Fehler_Queryfailed2.png[/img]
Cause of "Query failed" situation : The write permissions for the folder "Config" are not set correctly.
You can fix this error as follows:
Recommended procedure:
- Perform a type 1 reset. It is best to use the PLCnext Engineer for this. Afterwards a license activation is possible again. License activations already scheduled in the store will finish.
Hint:
The IP address is then again default 192.168.1.10
Your project is deleted.
The store service is deactivated
Your regtoken must be renewed. ( Proficloud.NET -> My Appliances -> select correct UUID -> Press "Reset Regtoken" )
Procedure 1 without a type 1 reset (Not recommended) :
- Creating the root user with the comand with Putty >> sudo passwd root
- delete the User-config folder with Putty. Use root rights (>> su -) >> rm /media/rfs/rw/upperdir/opt/plcnext/config/ -r
- Exit root User and Lock the root User >> sudo passwd -l root
- Reboot the device. >> reboot
Procedure 2 without a type 1 reset (Not recommended) :
- Creating the root user with the comand with Putty >> sudo passwd root
- Change access permissions for SSH
- Option 1: Change the line "#PermitRootLogin yes" to "PermitRootLogin yes" in the file /etc/ssh/sshd_config
- Option 2: Use the following command alternatively to the file change >> sed -i "/#PermitRootLogin/s/^#//" /etc/ssh/sshd_config && /etc/init.d/sshd restart
- Use winSCP to copy all elements from "/media/rfs/ro/opt/plcnext/config" to "/opt/plcnext/config".
- Exit root User and Lock the root User >> sudo passwd -l root
- Reboot the device.
[u]Error identification 1:[/u]
In PLCnext Store a license activation is not executed correctly.
The activation process showes "WAITING_FOR_DEVICE" longer than 1 minute.
In the Store device view, "processing" is permanently displayed at the license. The license is not transferred to the device.
[u]Error identification 2:[/u]
Use your browser and open the WBM of the device by entering the IP address. The following error message appears:
[img]https://www.plcnext-community.net/images/users/daniel_buschatzky/PLCnextStore_WBM_Fehler_Queryfailed3.png[/img]
![https://www.plcnext-community.net/images/users/daniel_buschatzky/PLCnextStore_WBM_Fehler_Queryfailed3.png[/img]](/home/leaving?allowTrusted=1&target=https%3A%2F%2Fwww.plcnext-community.net%2Fimages%2Fusers%2Fdaniel_buschatzky%2FPLCnextStore_WBM_Fehler_Queryfailed3.png%5B%2Fimg%5D){kind=link}
[u]Error identification 3:[/u]
Use your browser and open the WBM of the device by entering the IP address. In the WBM, navigate to the Administration -> License Management location.
Here the situation is as follows:
[img]https://www.plcnext-community.net/images/users/daniel_buschatzky/PLCnextStore_WBM_Fehler_Queryfailed2.png[/img]
![https://www.plcnext-community.net/images/users/daniel_buschatzky/PLCnextStore_WBM_Fehler_Queryfailed2.png[/img]](/home/leaving?allowTrusted=1&target=https%3A%2F%2Fwww.plcnext-community.net%2Fimages%2Fusers%2Fdaniel_buschatzky%2FPLCnextStore_WBM_Fehler_Queryfailed2.png%5B%2Fimg%5D){kind=link}
Cause of "Query failed" situation : The write permissions for the folder "Config" are not set correctly.
You can fix this error as follows:
Recommended procedure:
- Perform a type 1 reset. It is best to use the PLCnext Engineer for this. Afterwards a license activation is possible again. License activations already scheduled in the store will finish.
Hint:
The IP address is then again default 192.168.1.10
Your project is deleted.
The store service is deactivated
Your regtoken must be renewed. ( Proficloud.NET -> My Appliances -> select correct UUID -> Press "Reset Regtoken" )
Procedure 1 without a type 1 reset (Not recommended) :
- Creating the root user with the comand with Putty >> sudo passwd root
- delete the User-config folder with Putty. Use root rights (>> su -) >> rm /media/rfs/rw/upperdir/opt/plcnext/config/ -r
- Exit root User and Lock the root User >> sudo passwd -l root
- Reboot the device. >> reboot
Procedure 2 without a type 1 reset (Not recommended) :
- Creating the root user with the comand with Putty >> sudo passwd root
- Change access permissions for SSH
- Option 1: Change the line "#PermitRootLogin yes" to "PermitRootLogin yes" in the file /etc/ssh/sshd_config
- Option 2: Use the following command alternatively to the file change >> sed -i "/#PermitRootLogin/s/^#//" /etc/ssh/sshd_config && /etc/init.d/sshd restart
- Use winSCP to copy all elements from "/media/rfs/ro/opt/plcnext/config" to "/opt/plcnext/config".
- Exit root User and Lock the root User >> sudo passwd -l root
- Reboot the device.