Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84539members
353793posts

DCO ETL new configuration error

EcoStruxure IT forum

A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.

DCIM_Support
Picard
Picard
0 Likes
3
201

DCO ETL new configuration error

This question was originally posted on DCIM Support by Alessio De Maio on 2019-05-03


Hello,

I'm trying to set an ETL Import from an external database, but when I enter "Submit" it loads for ~5sec and then it gaves me a message: "Internal error during add, see logs".

Where can I find these logs?

DCO version is 8.2.12.

Thank you,

Alessio De Maio

(CID:143754897)

3 Replies 3
DCIM_Support
Picard
Picard
0 Likes
1
201

Re: DCO ETL new configuration error

This answer was originally posted on DCIM Support by Jef Faridi on 2019-05-03


Hi Alessio,

etl.log files plus other logs usually located in  /opt/jboss-as/standalone/log

Kind regards

(CID:143754988)

DCIM_Support
Picard
Picard
0 Likes
0
201

Re: DCO ETL new configuration error

This comment was originally posted on DCIM Support by Alessio De Maio on 2019-05-03


Hi Jef,

I ordered the .log file for the "Last modification time" on DCO Webmin, and I found out only two .log file wrote something when I hit "Submit". 

etl.log logged

2019-05-03 14:10:28,198 INFO [XgGBwqiQQ3ODO7nP6I4jOQ] [a3ab747d76de] [org.pentaho.di] (default task-14 XgGBwqiQQ3ODO7nP6I4jOQ) RepositoriesMeta - Reading repositories XML file: FromInputStream 2019-05-03 14:10:28,228 INFO [XgGBwqiQQ3ODO7nP6I4jOQ] [a3ab747d76de] [org.pentaho.di] (default task-14 XgGBwqiQQ3ODO7nP6I4jOQ) RepositoriesMeta - Reading repositories XML file: FromInputStream

and

access.log logged

2019-05-03 14:10:28,154 INFO [XgGBwqiQQ3ODO7nP6I4jOQ] [a3ab747d76de] [tokenbased] [com.apc.server_extensions.undertow.AccessLoggingHttpHandler] (default task-14 XgGBwqiQQ3ODO7nP6I4jOQ) >>> [AwD2t8Vdqf] [undefined] POST Request [/web/api/webclient/v8.1/etl-configuration/configuration] 2019-05-03 14:10:33,500 INFO [XgGBwqiQQ3ODO7nP6I4jOQ] [a3ab747d76de] [tokenbased] [com.apc.server_extensions.undertow.AccessLoggingHttpHandler] (default task-14 XgGBwqiQQ3ODO7nP6I4jOQ) <<< [AwD2t8Vdqf] [undefined] POST Request [/web/api/webclient/v8.1/etl-configuration/configuration] with body data: { "schedule": { "scheduleType": "Interval", "intervalType": "Minutes", "interval": 5 }, "database": { "databaseType": "External", "password": "db_pw", "databaseName": "db_name", "username": "db_user", "hostname": "db_hostname", "port": 5432, "driverClass": "org.postgresql.Driver", "url": "jdbc:postgresql://"here_was_the_compiled_link"", "dialectName": "org.hibernate.dialect.PostgreSQL94Dialect" }, "paused": false, "systemName": "testimport", "lastRun": null, "id": "", "configurationType": "Import", "transformation": { "name": "No transformation v 1.0.0", "configurationType": "Import", "elementType": "Job", "parameters": [] }, "importAsNameAssetPropertyName": null, "lockSerialNumber": false, "importNameToAssociatedItem": false, "importBarcodeToAssociatedItem": false, "lockBarcode": false, "lockName": false, "importSerialNumberToAssociatedItem": false } took 5346 milliseconds with status: 400 2019-05-03 14:10:36,402 INFO [PTxB8pGFSFWUkLJN5aa5yA] [2f183a4e6449] [] [com.apc.server_extensions.undertow.AccessLoggingHttpHandler] (default task-27 PTxB8pGFSFWUkLJN5aa5yA) >>> GET Request [/rest/platform/status] 2019-05-03 14:10:36,415 INFO [PTxB8pGFSFWUkLJN5aa5yA] [2f183a4e6449] [] [com.apc.server_extensions.undertow.AccessLoggingHttpHandler] (default task-27 PTxB8pGFSFWUkLJN5aa5yA) <<< GET Request [/rest/platform/status] took 13 milliseconds with status: 200

I omitted the private info of the DB, but this is all I got. I did not see any kind of error...

(CID:143755015)

DCIM_Support
Picard
Picard
0 Likes
0
201

🔒 Closed

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