We have a SQL Server 2012 Table with fields of type datetimeoffset(7). We need t

JEAN PIERRE over 10 years ago

We have a SQL Server 2012 Table with fields of type datetimeoffset(7). We need to match this table to a CDT. We tried the Appian datatype datetime but this didnt worked. (error: The data source schema does not match the type mappings: Wrong column type in VCA_BO.dbo.ScvPs for column created. Found: datetimeoffset, expected: datetime (APNX-2-4056-000) ).
What is the correct Appian datatype to match the SQL Server datatype datetimeoffset?...

Discussion posts and replies are publicly visible

0 JEAN PIERRE over 10 years ago

An error: the server is SQL Server 2008 R2 not SQL Server 2012
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aswinb over 10 years ago

I don't think you can have datetimeoffset.....if feasible try changing the database datatype to datetime.....I also experienced similar problems with smallint....Appian only likes tinyint....just FYI
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 JEAN PIERRE over 10 years ago

We cannot change the data type of this external system. We have excluded this property out of the CDT definition.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 atulp over 10 years ago

Please see the below XSD element

<xsd:element name="datetm" nillable="true" type="xsd:date">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Column( name="datetm",columnDefinition="datetimeoffset(7)",nullable=true)
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel