DatabaseUpdater match column

Hi @Brad Nesom​ 

If the column you're doing the matching on (GFID) is the data type 'text', then the table update will fail. You need to use char or varchar in this case instead.

If you're unable to change your column data type to char/varchar you could use a WHERE Clause in your DatabaseUpdater to cast your GFID to varchar instead.

See the screenshot below for an example:

Hope this helps!

Dan

​@danminneyatsaf 

I am still having an issue with this. 

My table has the gfid column set to varchar. but i still get this error.

254	2025-4-21 17:17:53 | Microsoft SQL Server Non-Spatial Writer: Failed to write a feature of type `dbo.L_DRIVE_COGO_25' to the database. Provider error `(-2147217871) Query timeout expired'. SQL Command `UPDATE [dbo].[L_DRIVE_COGO_25] SET [GFID]=?, [process_flag]=? WHERE [GFID]=?'

Hello, ​@gisbradokla.

Sorry you’re still running into issues with this error. Would you be able to try increasing the Command Timeout parameter and see if that helps out? Image for reference:

Best,

AliAtSafe wrote:

Hello, ​@gisbradokla.

Sorry you’re still running into issues with this error. Would you be able to try increasing the Command Timeout parameter and see if that helps out? Image for reference:

  

  

Best,

I can try that.

It seems as far as the log shows that it is attempting for hours instead of the 30 seconds specified in the parameter setting.

3154    2025-4-24 20:39:36 | Reading source feature # 2000
3155    2025-4-24 20:40:06 | Microsoft SQL Server Non-Spatial Writer: Failed to write a feature of type `dbo.L_DRIVE_COGO_25' to the database. Provider error `(-2147217871) Query timeout expired'. SQL Command `UPDATE [dbo].[L_DRIVE_COGO_25] SET [GFID]=?, [process_flag]=? WHERE [GFID]=?'
3156    2025-4-25 00:32:52 | ... Last line repeated 449 times ...
3157    2025-4-25 00:32:52 | Reading source feature # 2500
3158    2025-4-25 00:33:22 | Microsoft SQL Server Non-Spatial Writer: Failed to write a feature of type `dbo.L_DRIVE_COGO_25' to the database. Provider error `(-2147217871) Query timeout expired'. SQL Command `UPDATE [dbo].[L_DRIVE_COGO_25] SET [GFID]=?, [process_flag]=? WHERE [GFID]=?'
3159    2025-4-25 04:50:53 | ... Last line repeated 499 times ...
3160    2025-4-25 04:50:53 | Reading source feature # 3000
3161    2025-4-25 04:51:23 | Microsoft SQL Server Non-Spatial Writer: Failed to write a feature of type `dbo.L_DRIVE_COGO_25' to the database. Provider error `(-2147217871) Query timeout expired