Question
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***
Accepted Solution
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
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
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"
BlueRose Technologies
SE
Hi Baskar,
Can you please take screenshots of table columns with data types and external mapping wizard of that table.
Thanks,
Prudhvi
Accepted Solution
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