v14 database error: the OleDbType property is uninitialized
Altair EmployeeI am using v14 and test database connection within Project setup. However when the job is run I go the following error:
Failed: Parameter[0]: the OleDbType property is uninitialized: OleDbType.Empty.Datawatch.Common.Exceptions.DatawatchSdkException: Export failed at Datawatch.Export.DatawatchSdk.ProjectExporter.ProjectExport(ExportProjectModel exportModel) at Datawatch.Services.DataPump.Processing.ProjectProcessor.ProcessProject(PumpProjectFile pumpProjectFile, PumpJob job) at Datawatch.Services.DataPump.Processing.JobProcessor.ProcessExport(PumpJobExtended job, PumpProjectFile pumpProjectFile, PumpManifestSerialized manifestSerialized) at Datawatch.Services.DataPump.Processing.JobProcessor.ProcessJob(PumpJobExtended job, PumpManifestSerialized manifestSerialized)
Installed driver for SQL 2008 R2, tried to use Configuration Definition. All connection test successful. However when the job is run, I got the error
Please help!!
Find more posts tagged with
Altair EmployeeHi Chung,
Have you tried reaching out to Datawatch Support: https://www.datawatch.com/support/
They will be able to provide you with assistance.
I did but haven’t hear back yet.
Altair EmployeeHi Chung,
Does the account have the required database rights? I believe the ‘test connection’ just needs to see the database instance. I don’t believe it will be verifying full read/write access.
If you are using SQL authentication, then it would be whatever user you are specifying in the connection dialogue or connection string.
If you are using a trusted connection, it will be the domain account that is being used to run the Datawatch Agent service on the Automator server.
Regards,
Steve.
Hi Chung,
Have you tried reaching out to Datawatch Support: https://www.datawatch.com/support/
They will be able to provide you with assistance.