Unable to allocate communication resources?

[pkll]

Hi All,

Code: Select all

Fatal Error: Unable to allocate communication resources

I am getting above Error.

Let me know why this error is comming?

[ray.wurlod]

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.

[pkll]

Hi Ray,

I am unable to read your entire sentence....

[stuartjvnorton]

Ray was asking what you were trying to do when you got this error.
IIS is a big place: help us help you.

[priyadarshikunal]

along with that, are you getting any other warning or error messages?

[pkll]

Yes I am getting below warnings and errors..

Code: Select all

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.

[ray.wurlod]

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.

[pkll]

Hi Ray,

Thanks for ur reply I am unable to read ur entire sentence.
Could you plz explain ?

[ray.wurlod]

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.