Discussion
de Volksbank
NL
Last activity: 11 Jan 2023 23:30 EST
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***