Because it was not able to allocate communication resources.
That is all of the information available in the error message.
You must help us to help you. What were you trying to do at the time? What does your design look like? What stage type threw this error? And so on. Without that information we have even less information than you do, and can only respond as I did in my first paragraph.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Oracle_Connector_21,0: The OCI function OCIStmtExecute returned status 1. Error code: 1, Error message: ORA-00001: unique constraint (SCOTT.SYS_C005447) violated.
Oracle_Connector_21,0: The OCI function OCIStmtExecute returned status -1. Error code: 24,381, Error message: ORA-24381: error(s) in array DML. (CC_OraStatement::executeInsert, file CC_OraStatement.cpp, line 1,538)
Oracle_Connector_21,0: The runLocally() of the operator failed.
Oracle_Connector_21,0: Operator terminated abnormally: runLocally() did not return APT_StatusOk
node_node1: Player 3 terminated unexpectedly.
HIST_DETAILS,0: Failure during execution of operator logic.
HIST_DETAILS,0: Output 0 produced 37031 records.
HIST_DETAILS,0: Fatal Error: Unable to allocate communication resources
I had run this job one month before it had executed .but it is not executed right now it is showing above errors.
Always start with the first error - "unique constraint (SCOTT.SYS_C005447) violated". There's nothing wrong with the DataStage job design. You're trying to insert a record that violates the indicated UNIQUE constraint. Answer: don't. Perhaps add some checking to your job.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ur was a city in ancient Babylonia. The second person personal pronoun in English is spelled "your". Plz may be a town in eastern Europe. The word you needed is spelled "Please".
We strive for a professional standard of written English here at DSXchange, not least to assist those of us whose first language is not English.
The reason you were not able to read my entire sentence is that you have not yet purchased yourself a premium membership. (I am assuming here that this is what you wanted explained.) Premium membership is the mechanism by which the hosting and bandwidth costs of DSXchange are met.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.