We are standing up a new Control Hub 3.75 with Data Collectors (DC) version 3.18 and 5.9.1 to run parallel on the new control hub. We are able to ingest data on DC 3.18 with no issues. However, we are receiving the following error on DC 5.9.1:
” Datacollector 'https://streamsets:18636' has pipeline in status 'STARTING_ERROR'; message is 'JDBC_09 - Could not retrieve information regarding the columns for table 'SECTION_SCHEDULES''
We have run the DDL Job (Start Up) to populate the schema in AWS S3 with no errors on DC 3.18 and DC 5.9.1. The job fails when running DC 5.9.1 on JenzEx and Colleague Student Information Systems.
If there is something that someone has come across that would help in troubleshooting this error, it would be greatly appreciated.