This answer was originally posted on DCIM Support by Rashmi on 2017-07-27
After restoring, ETL database is Paused automatically, We have to start it manually through webmin - ETL integration mgmt page.
This comment was originally posted on DCIM Support by xpower123 on 2017-07-27
Manual start, run ETL will be an error.
This answer was originally posted on DCIM Support by Ed Tarento on 2017-07-27
If you've check the DB via webmin and tried to start as advised by Rashmi and got an error, drop the External System via DCO GUI then the DB then recreate the DB via webmin and then recreate the External System via DCO GUI)
This answer was originally posted on DCIM Support by Ulrik Jørgensen on 2017-07-31
After a restore the custom transformation files are not restored to the correct location. They have to be copied from the /data/pentaho_restore/import folder to the /data/pentaho/import folder. In a cluster the /data/pentaho_restore folder is located on the server that initiated the restore, and the files have to be copied to all servers in the cluster.
This comment was originally posted on DCIM Support by Ulrik Jørgensen on 2017-07-27
Would it be possible for you to share the server log files? They can be downloaded via the Webmin console on port 10000?
This comment was originally posted on DCIM Support by xpower123 on 2017-07-28
The attachment is a log of ETL runs etl1.log
This comment was originally posted on DCIM Support by Ulrik Jørgensen on 2017-07-28
The log file indicate that the BMS login to DESIGO is invalid. Could you check the instance, database, username and password settings?
It seems you have re-uploaded the database driver and added the import transformations to /data/pentaho/import folder.
There might be other issues, but they would then be logged in the server.log file. Note: the complete set of log files can be downloaded in Webmin -> StruxureWare DC Operation -> Download Log Files.
This comment was originally posted on DCIM Support by Brenda Sun on 2017-08-04
we test for days, the ETL can get the latest data from BMS, but another issue come out.
It seems that all rackpdu data lost, so that it can't calculate PUE.
you can find the issue in the picture below, the pdu shows "associated device data has been lost"
Do you think this issue is related to the wrong ETL file? becase the ETL file has been modified many times, so after we restore the DCO, we asked for a latest set of ETL script, didn't use the one we used before. but this 2 set of ETL come from the same person. Hope this information will be helpful .
Discuss challenges and get support in energy and automation with 30,000+ experts and peers.
Over 10,000+ support articles are available to help you find answers to your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!