v14 database error: the OleDbType property is uninitialized

Altair Forum User

I 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!!

Altair Forum User

Hi Chung,

 

Have you tried reaching out to Datawatch Support:  https://www.datawatch.com/support/

 

They will be able to provide you with assistance.

Altair Forum User

Altair Forum User said:

Hi 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 Forum User

Hi 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.