Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Notifications
Login / Register
Community
Community
Notifications
close
  • Forums
  • Knowledge Center
  • Events & Webinars
  • Ideas
  • Blogs
Help
Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Sustainability
Sustainability

We Value Your Feedback!
Could you please spare a few minutes to share your thoughts on Cloud Connected vs On-Premise Services. Your feedback can help us shape the future of services.
Learn more about the survey or Click here to Launch the survey
Schneider Electric Services Innovation Team!

View Tables of ETL Import Database

EcoStruxure IT forum

Schneider Electric support forum about installation and configuration for DCIM including EcoStruxure IT Expert, IT Advisor, Data Center Expert, and NetBotz

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Schneider Electric Community
  • EcoStruxure IT
  • EcoStruxure IT forum
  • View Tables of ETL Import Database
Options
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Mute
  • Printer Friendly Page
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
Top Experts
User Count
Cory_McDonald
Admiral Cory_McDonald Admiral
124
Jef
Admiral Jef Admiral
110
gsterling
Captain gsterling Captain
71
APC_Steve
Captain APC_Steve Captain
62
View All

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Back to EcoStruxure IT forum
DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

0 Likes
11
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

View Tables of ETL Import Database

Dear all,

After finished configuring ETL import database from DCO web Access, I wanted to see table structure of the database created for the ETL, but I could not find any tables listed on my pgAdmin. Please see the picture below:

 

I have tried to run the ETL job, but it returned the following error message "ETL Configuration with the specified ID can not be found".

Can anyone explain what I missed? Or It is still under development since the API for ETL configurations are still in "Internal" status.

Any responses will be highly appreciated.

Thank you.

(CID:147196784)

Labels
  • Labels:
  • Data Center Operation
Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

  • All forum topics
  • Previous Topic
  • Next Topic
Replies 11
DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

0 Likes
0
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

Hello Bayu.

Can you confirm which version of DCO you are running?

Did you try to re-create the import database?

From the DCO web client, can you delete and recreate the import database? 

Do you see an error when you create the import database?

If the error/condition continues we'd ask you if possible to share log files from the DCO server.

Regards

Greg Sterling

(CID:147197222)

Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

0 Likes
0
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

Hello Sterling,

Thank you very much for your response.

I am running DCO 8.2.12.

Yes, I was creating the import database but actually I have been trying so many time, all combinations, Export and Import database, Internal and external. No tables created, only the database name, especially for the Internal Import (already mentioned on my previous question).  I can see the database names, as many as my trials, created in the ISXO database. Here are the pictures showing the databases name in the table etl_settings (in ISXO database):

and the databases listed but with no tables created (Tables = 0):

No errors shown when I was creating the import database using "Manage ETL Integrations" wizard in DCO web access, all run smoothly. But, after finished creating the ETL configuration for import database, when I wanted to run the job, it showed me the error ""ETL Configuration with the specified ID can not be found" (already mentioned as well on my question).

After creating the import database ETL Configuration, the last ETL Configuration just created in DCO Web Access just gone when we revisiting the "Manage ETL Integrations" menu.

The logs you request will be sent later soon.

Thank you very much. Looking forward to your reply.

(CID:147197388)

Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

0 Likes
0
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

Among the log files available, which one do you want me to share?

Here are tailed or probably related to ETL log chunk of the 3 of them:

etl.log

2019-07-19 14:18:14,939 INFO  [71ho1SwFRc2yvHTenPsRpg] [a3ab747d76de] [org.pentaho.di] (default task-9 71ho1SwFRc2yvHTenPsRpg) RepositoriesMeta - Reading repositories XML file: FromInputStream

2019-07-19 14:18:15,181 INFO  [71ho1SwFRc2yvHTenPsRpg] [a3ab747d76de] [org.pentaho.di] (default task-9 71ho1SwFRc2yvHTenPsRpg) RepositoriesMeta - Reading repositories XML file: FromInputStream

2019-07-23 06:00:49,003 INFO  [wFXzNtZbQkWjkcCXAjGtag] [a3ab747d76de] [org.pentaho.di] (default task-3 wFXzNtZbQkWjkcCXAjGtag) RepositoriesMeta - Reading repositories XML file: FromInputStream

2019-07-23 06:00:49,145 INFO  [wFXzNtZbQkWjkcCXAjGtag] [a3ab747d76de] [org.pentaho.di] (default task-3 wFXzNtZbQkWjkcCXAjGtag) RepositoriesMeta - Reading repositories XML file: FromInputStream

 http_acces.log

Jul 19 09:53:18 localhost httpd_access: 192.168.77.99 - - [19/Jul/2019:09:53:18 +0200] "GET /web/api/webclient/v8.1/etl-configuration/driver HTTP/1.1" 200 160

Jul 19 09:53:18 localhost httpd_access: 192.168.77.99 - - [19/Jul/2019:09:53:18 +0200] "GET /web/api/webclient/v8.1/etl-configuration/dialect HTTP/1.1" 200 111

Jul 19 09:53:18 localhost httpd_access: 192.168.77.99 - - [19/Jul/2019:09:53:18 +0200] "GET /web/api/webclient/v8.1/etl-configuration/configuration HTTP/1.1" 200 2

 

server.log

 2019-07-19 10:35:31,592 INFO  [] [] [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) WFLYJCA0010: Unbound data source [java:jboss/datasources/PostgresDS]
2019-07-19 10:35:33,048 INFO  [] [] [org.jboss.as.server.deployment] (MSC service thread 1-1) WFLYSRV0208: Stopped subdeployment (runtime-name: com.apc.external.server-8.2.12.OD-c0a100a9283af158f349eae2e864ad6235804c21.jar) in 10453ms
2019-07-19 10:35:33,048 INFO  [] [] [org.jboss.as.server.deployment] (MSC service thread 1-2) WFLYSRV0208: Stopped subdeployment (runtime-name: com.apc.etl.server.synchronizers-8.2.12.OD-c0a100a9283af158f349eae2e864ad6235804c21.jar) in 10582ms
2019-07-19 10:35:33,049 INFO  [] [] [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) WFLYJCA0019: Stopped Driver service with driver-name = postgres

 

Thanks.

(CID:147197395)

Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

0 Likes
0
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

If possible, can you share the server.log and etl.log files?

Regards

Greg Sterling

(CID:147197529)

Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

0 Likes
0
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:50 PM . Last Modified: ‎2024-04-03 01:04 AM

Please find the files on the following links:

  • server.log.zip
  • etl.log

I do hope you could find the solution by inspection the log.
Thank you.

Regards,

Bayu Raharjo

(CID:147197797)

Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2024-04-03 01:04 AM

0 Likes
0
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2024-04-03 01:04 AM

Hello Bayu

There are a number of errors in the server.log.

Is this an offline demo configuration or a copy of a demo configuration? There are a number of services which appear they may not be running and there are errors suggesting there has been trouble writing to the postgres database.

How much memory is assigned to this DCO server? It would appear its has approximately 8GB of memory. Its disk is not full or near full, correct?

When was the last time this server was restarted?

Assuming this is not an offline demo configuration, if you can allocate more memory to this configuration I would suggest doing so. Bringing it up to at least 10GB, recommended is 16GB in our system requirements docs.

Regards

Greg Sterling

(CID:147197889)

Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2024-04-03 01:04 AM

0 Likes
0
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2024-04-03 01:04 AM

Hello Greg Sterling,

Thank you for your reply.

Is this an offline demo configuration or a copy of a demo configuration? There are a number of services which appear they may not be running and there are errors suggesting there has been trouble writing to the postgres database.

Yes, DCO I use is a demo version. Some services are not running in a demo version? ETL doesn't work in Demo version?

We already reconfigure RAM to 10 and 16 GB and still ETL database is not created.

 

Thank you.

 

(CID:147200971)

Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2024-04-03 01:04 AM

0 Likes
0
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2024-04-03 01:04 AM

I tried the offline demo and had a similar experience. Seems like creating/managing ETL databases is not working. I will pass this on to dev for comment.

(CID:147203434)

Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2024-04-03 01:04 AM

0 Likes
0
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2024-04-03 01:04 AM

Ok. Clear now.
Perhaps, you may update on this thread if you got any comments from dev.


Many thanks.

(CID:147203892)

Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2024-04-03 01:04 AM

0 Likes
0
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2024-04-03 01:04 AM

Hello Bayu. I received confirmation the use of ETL is not supported with the offline demo, so it is not expected to work.

Regards

Greg Sterling

(CID:147784103)

Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

DCIM_Support
Picard DCIM_Support
Picard

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2023-10-22 04:15 AM

0 Likes
0
1106
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

Posted: ‎2020-07-05 08:51 PM . Last Modified: ‎2023-10-22 04:15 AM

superhero.png

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.

Reply
Contact Support

Link copied. Please paste this link to share this article on your social media post.

To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2025 Schneider Electric

This is a heading

With achievable small steps, users progress and continually feel satisfaction in task accomplishment.

Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.

of