Discussion

3
Replies
329
Views
GOURI_SHANKAR_K Member since 2011 10 posts
Cognizant
Posted: 10 months ago
Last activity: 9 months 4 weeks ago

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***

Data Integration Developer Knowledge Share
Share this page LinkedIn