DCO ETL new configuration error

[DCIM_Support]

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)

[DCIM_Support]

Hi Alessio,

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

Kind regards

(CID:143754988)

[DCIM_Support]

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]

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