Question
HMRC
GB
Last activity: 25 Mar 2024 7:38 EDT
Date property issue:JDBC date issue in Data type.
Issue:
- we have a date property, in data type can't perform export and import .
- Create/import Api failed
- getting an error called JDBC date
- attached all the necessary artefacts
WorkArounds performed:
- Searched in PDN and found this link but no luck
- https://support.pega.com/question/postgresql-date-column-unknown-jdbc-datatype?
- created new property and exposed it. still same issue
Business Justification:
It stopped testing of one of the core functionality.
Steps to Reproduce:
- Create a date property
- add it in data type
- try to import/export data
please refer to the uploaded artefacts .
Happy to discuss further via call/screenshare
Accepted Solution
Updated: 25 Mar 2024 7:38 EDT
Pegasystems Inc.
GB
INC-B5523 (JDBC date issue in data type)
Our support team have concluded their analysis. Latest update March 11th from GCS:
---------------------------------------
GCS engineer have confirmed from our DBA below alter query should work :
ALTER TABLE table_nameALTER COLUMN column_name TYPE new_data_type USING expression;
Below info should cover in query: DB name : PegaDATA Table Name : pr_data Property : pyLabel Original Column type: Date Required Column type: Varchar Property type: varchar
Post making changes please perform below steps: You can resave DB instances, respective class table , perform revalidate and save on all the rules where this property is referenced.
Please consult to your DBA with above information they will be able to help with query.
--------------------------
Please can you use the 'Accept Solution' link here to close this thread?
Updated: 4 Mar 2024 11:37 EST
Pegasystems Inc.
GB
@DeepikaK17074981 I can see that you logged INC-B5523 (JDBC date issue in data type)
Our support team is investigating:
Latest update:
---------------------------------------------
- I had words with our Cloud DBA team and Since your environment is on-prem you have to reach out to your internal DBA team in-order to change the property type from Date(13) to Varchar(08).
- On call when we create properties it got created properly as Varchar(8) and hence was not throwing issue,
- kindly help us understanding how did you create properties either is from external db directly or if from Pega
- I tried various ways but Pega is not creating property with Date (13).
--------------------------------------------------
Please continue to work with GCS and once the issue is resolved, please post a reply on this forum quesiton and mark it with Accept Solution.
Pegasystems Inc.
GB
@DeepikaK17074981 Please can you response to our GCS team?
Latest update 29 February:
----------------------------
As communicated earlier Unfortunately since your environment is not on Pega could, I would not be able to raise any CC request on your Behalf to make changes as For on-prem clients Cloud DBA won't support.
You can share below details with your DBA team.
- To alter table for chaining property type from Date to varchar: https://www.geeksforgeeks.org/postgresql-change-column-type/
If you are trying to execute the query,, you may not be having DBA privileges.
I would request to involve your DBA team to perform any DB related actions, addition to this you can check with Pega consulting team, in case you are requesting any help from how to update property type from date to Varchar.
------------------------------------
Accepted Solution
Updated: 25 Mar 2024 7:38 EDT
Pegasystems Inc.
GB
INC-B5523 (JDBC date issue in data type)
Our support team have concluded their analysis. Latest update March 11th from GCS:
---------------------------------------
GCS engineer have confirmed from our DBA below alter query should work :
ALTER TABLE table_nameALTER COLUMN column_name TYPE new_data_type USING expression;
Below info should cover in query: DB name : PegaDATA Table Name : pr_data Property : pyLabel Original Column type: Date Required Column type: Varchar Property type: varchar
Post making changes please perform below steps: You can resave DB instances, respective class table , perform revalidate and save on all the rules where this property is referenced.
Please consult to your DBA with above information they will be able to help with query.
--------------------------
Please can you use the 'Accept Solution' link here to close this thread?