Question
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
PT Sinarmas Multifinance
ID
Last activity: 24 Nov 2016 4:10 EST
External Mapping
sir, I tried the external mapping, when I tried to table that has 43 columns, at pega only detected 39 column, how to solve?
thanks
***Updated by Moderator: Vidyaranjan| Included Categories***
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
PT Sinarmas Multifinance
ID
I've found the answer. In postgres there are two types of data: date and timestamp, in pega he could only take the timestamp while the date error
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Pegasystems Inc.
IN
Can you please elaborate the issue.
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Pegasystems Inc.
US
Have you resaved the database table instance or restarted the servers after adding the exposed properties?
Updated: 17 Nov 2016 5:33 EST
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
V Pattiruhu
Mr. BaskaraEkaputraA,
i believe that problem was caused by data type on your table. would you like to check the data type. what is your database server?. can you elaborate more detail about your database server and version. as my experience, when i create an integration table which have "Date" datatype in column, the column will be not identified by Pega. i'm Using Pega 7.2.1 and PostgreSQL 9.3.13. But when your datatype is "Timestamp" the integration runs well.
NB : within this post, i would like to ask Pega Support, why Pega cant identify "date" datatype in table?. can you explain to us. thank you very much.
regards,
Pieter
"sir, I tried the external mapping, when I tried to table that has 43 columns, at pega only detected 39 column, how to solve?
thanks"
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
BlueRose Technologies
AU
Hi Baskar,
Can you please take screenshots of table columns with data types and external mapping wizard of that table.
Thanks,
Prudhvi
Accepted Solution
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
PT Sinarmas Multifinance
ID
I've found the answer. In postgres there are two types of data: date and timestamp, in pega he could only take the timestamp while the date error
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
PT Sinarmas Multifinance
ID
New reply sorry, I'm too busy at work so rarely see PDN ^^