DataStage Errors and Workarounds

1)WebSphere_MQ_Connector,0: Fatal Error: Virtual data set.; output of "WebSphere_MQ_Connector": the record is too big to fit in a block; the length requested is: 1000027, the max block length is: 131072.

Sol : CHANGE THE MQ SIZE IN THE MQ EXPLORER TO MAX LIKE 99999999 etc.


2)Teradata_Enterprise,5: Insufficient blocks for partition 5. Reading suppressed.

Sol: IN THE TD_ENTERPRISE PROPERTIES ADD THE ADDITIONLA CONNECTION PROPERTIES IN IT
ENTER THE VALUE “SessionsPerPlayer=2,RequestedSessions=12, Synctimeout=300”

3)File_OO_Cy: When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.

Sol:before the sequential file stage In the Advanced Tab change the "Preserve Partioning" to "Clear"

this is because of the conflict of Read mode is parallel but by default sequential file only takes the data in sequential mode.