Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

ACS File Import Error


Level 2

Hello Everyone,

I am getting issue on file import for one of the custom resource created. Custom resource have attribute "scantime" of datatype as "date & time" and flat file which is having scantime data as "14:00:00". While setting up import workflow using load file activity column definition allows to select data type as "time" and when it try to update/create record using update data activity it throws an below error.

ERROR: column "tsscantime" is of type timestamp with time zone but expression is of type time without time zone LINE 1: ...ld867369179, NULL),COALESCE( sFld867369183, NULL),COALESCE( ... ^ HINT: You will need to rewrite or cast the expression.

I just want to have time alone in the field "scantime" not the date and time.  But while creating data type it's allowing to select either "date" or "date & time". There is no "time" data type. But in the column definition having data type field "time".

Appreciate any help.



0 Replies