Discussion

Data Table test connectivity issue - contains a px, py, or pz property: pxcreatedatetime

Hello All,

When you face issue with Data Table test connectivity as - "contains a px, py, or pz property: pxcreatedatetime" or if you see issue when adding in PZPVSTREAM or BLOB column.

This is because it is expecting other columns in the table, so if you want to have px properties, make sure you have below columns as well, this will resolve that you get on test connectivity.

Table

Name Null Type
---------------- -------- ------------------
PXCOMMITDATETIME TIMESTAMP(6)
PXCREATEDATETIME TIMESTAMP(6)
PXCREATEOPERATOR VARCHAR2(128 CHAR)
PXCREATEOPNAME VARCHAR2(128 CHAR)
PXCREATESYSTEMID VARCHAR2(32 CHAR)
PXINSNAME VARCHAR2(128 CHAR)
PXOBJCLASS VARCHAR2(96 CHAR)
PXSAVEDATETIME TIMESTAMP(6)
PXUPDATEDATETIME TIMESTAMP(6)
PXUPDATEOPERATOR VARCHAR2(128 CHAR)
PXUPDATEOPNAME VARCHAR2(128 CHAR)
PXUPDATESYSTEMID VARCHAR2(32 CHAR)
PYLABEL VARCHAR2(64 CHAR)
PYRULESETNAME VARCHAR2(64 CHAR)
PZINSKEY NOT NULL VARCHAR2(255 CHAR)
PZPVSTREAM BLOB

- Gouri Shankar

***Moderator Edit-Vidyaranjan: Converted Question to Discussion & tagged Developer knowledge share***

Comments

Keep up to date on this post and subscribe to comments

Pega
October 1, 2019 - 7:00am

Hi Gourishankar,

Please refer to the following article it might help you:
https://community1.pega.com/community/pega-product-support/question/moving-data-table-prother-db2-table

October 9, 2019 - 9:53am

Hi, This is not a question, this is the solution,  i have posted if you get that kind of issue.

 

October 10, 2019 - 1:30am
Response to GOURI_SHANKAR_K

Thanks @GOURI_SHANKAR_K !

Vidyaranjan | Community Moderator | Pegasystems Inc.