Column definition mapping 'uniqueidentifier '

ajinkyab277

Certified Lead Developer

over 7 years ago

Is there any by which I can map Sql server database row with data type 'uniqueidentifier ' with appian column.

Discussion posts and replies are publicly visible

Parents

0 ajinkyab277
Certified Lead Developer
over 7 years ago

Hi Vinit ,
I am trying to insert data in Session table. In Session table, we have many columns out of which GuId is one of the column with the data type uniqueidentifier . This column gets auto-populated from a database.
I am able to verify mapping successfully with above changes that you suggested . But when I try to write session data in database 'Wtite to data store' smart service throws below error.

could not load an entity: [DsReportSessionDT37737#]:
com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when
converting from a character string to uniqueidentifier.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ajinkyab277
Certified Lead Developer
over 7 years ago

Hi Vinit ,
I am trying to insert data in Session table. In Session table, we have many columns out of which GuId is one of the column with the data type uniqueidentifier . This column gets auto-populated from a database.
I am able to verify mapping successfully with above changes that you suggested . But when I try to write session data in database 'Wtite to data store' smart service throws below error.

could not load an entity: [DsReportSessionDT37737#]:
com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when
converting from a character string to uniqueidentifier.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data